Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0020857Openbravo ERP05. Production managementpublic2012-06-25 13:572012-06-30 05:10
jecharri 
jecharri 
highmajoralways
closedfixed 
5
 
3.0MP133.0MP13 
Core
No
0020857: It exist one problem in pl MRP_PURCHASEORDER
It exist one problem in pl MRP_PURCHASEORDER

When is inserting c_orderline it can be a problem with value of column DISCOUNT becasue is setting this value to (((v_PriceList-v_PriceStd) / v_PriceList) * 100)

In case that v_pricelist is 0 the user will se the error division by zero.
-----
The solution will be to launch an exception saying to end user that he has the porduct XXX with price list 0
No tags attached.
Issue History
2012-06-25 13:57jecharriNew Issue
2012-06-25 13:57jecharriAssigned To => mirurita
2012-06-25 13:57jecharriModules => Core
2012-06-25 13:57jecharriResolution time => 1343426400
2012-06-25 17:59jecharriProposed Solution updated
2012-06-26 11:51miruritaAssigned Tomirurita => jonalegriaesarte
2012-06-28 12:46jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-06-28 18:05hgbotCheckin
2012-06-28 18:05hgbotNote Added: 0050262
2012-06-28 18:05hgbotStatusnew => resolved
2012-06-28 18:05hgbotResolutionopen => fixed
2012-06-28 18:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0d1948d3e51655fc8ee2f69d0ac95a523960c059 [^]
2012-06-29 08:19hgbotCheckin
2012-06-29 08:19hgbotNote Added: 0050265
2012-06-29 08:19hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/0d1948d3e51655fc8ee2f69d0ac95a523960c059 [^] => http://code.openbravo.com/erp/devel/pi/rev/11f541c73c6fbf5c8835a2436e4935d428592a46 [^]
2012-06-29 10:04jonalegriaesarteNote Added: 0050272
2012-06-29 10:04jonalegriaesarteStatusresolved => closed
2012-06-29 10:04jonalegriaesarteFixed in Version => 3.0MP13
2012-06-30 05:10hudsonbotCheckin
2012-06-30 05:10hudsonbotNote Added: 0050294
2012-06-30 05:10hudsonbotCheckin
2012-06-30 05:10hudsonbotNote Added: 0050296

Notes
(0050262)
hgbot   
2012-06-28 18:05   
Repository: erp/devel/pi
Changeset: 0d1948d3e51655fc8ee2f69d0ac95a523960c059
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Jun 28 18:04:26 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/0d1948d3e51655fc8ee2f69d0ac95a523960c059 [^]

Fixes issue 20857: It exist one problem in pl MRP_PURCHASEORDER.
The problem happens when the product has a zero price list.

---
M src-db/database/model/functions/MRP_PURCHASEORDER.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0050265)
hgbot   
2012-06-29 08:19   
Repository: erp/devel/pi
Changeset: 11f541c73c6fbf5c8835a2436e4935d428592a46
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Fri Jun 29 08:19:07 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/11f541c73c6fbf5c8835a2436e4935d428592a46 [^]

Fixes issue 20857: It exist one problem in pl MRP_PURCHASEORDER.
Now when the product price list is Zero the discount is filled with zero.

---
M src-db/database/model/functions/MRP_PURCHASEORDER.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0050272)
jonalegriaesarte   
2012-06-29 10:04   
Verified and working fine. Now when the price is 0, the discount inserted is 0.
(0050294)
hudsonbot   
2012-06-30 05:10   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ce760b148e29 [^]

Maturity status: Test
(0050296)
hudsonbot   
2012-06-30 05:10   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/ce760b148e29 [^]

Maturity status: Test