Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0017208Openbravo ERP08. Project and service managementpublic2011-05-17 16:532011-06-07 17:50
xabiermerino 
dalsasua 
urgentmajoralways
closedfixed 
5
2.50MP29 
2.50MP31 
Core
No
0017208: It is not possible save a Project Line with Planned Price = 0
It is not possible save a Project Line with Planned Price = 0. This error appears:

ERROR: division by zero

In several cases products with price 0 are used.
- As Openbravo Admin go to Project & Service Management || Transactions || Service Project || Service Project >> Project Line
- Create a line with Planned Price = 0
- Save
In Trigger C_projectline_trg3: v_oldLine_PlannedMarginAmt:=COALESCE((COALESCE(old.PLANNEDPRICE,0)-COALESCE(old.PLANNEDPOPRICE,0))*100/COALESCE(old.PLANNEDPRICE,1),0);
-->
"IF (COALESCE(old.PLANNEDPRICE,0) <> 0) THEN
v_oldLine_PlannedMarginAmt:=COALESCE((COALESCE(old.PLANNEDPRICE,0)-COALESCE(old.PLANNEDPOPRICE,0))*100/old.PLANNEDPRICE,0);
END IF;"



v_newLine_PlannedMarginAmt:=COALESCE((COALESCE(new.PLANNEDPRICE,0)-COALESCE(new.PLANNEDPOPRICE,0))*100/COALESCE(new.PLANNEDPRICE,1),0);
-->
IF (COALESCE(new.PLANNEDPRICE,0) <> 0) THEN
v_newLine_PlannedMarginAmt:=COALESCE((COALESCE(new.PLANNEDPRICE,0)-COALESCE(new.PLANNEDPOPRICE,0))*100/new.PLANNEDPRICE,0);
END IF;

No tags attached.
blocks defect 00172073.0MP0 closed adrianromero It is not possible save a Project Line with Planned Price = 0 
Issue History
2011-05-17 16:53xabiermerinoTypedefect => backport
2011-05-17 16:53xabiermerinofix_in_branch => 2.50
2011-05-17 16:54xabiermerinoversion3.0RC6.1 => 2.50MP29
2011-05-17 16:54xabiermerinoTarget Version3.0MP0 => 2.50MP31
2011-05-17 17:46xabiermerinoIssue Monitored: networkb
2011-05-30 13:21hgbotCheckin
2011-05-30 13:21hgbotNote Added: 0037725
2011-05-30 13:21hgbotStatusscheduled => resolved
2011-05-30 13:21hgbotResolutionopen => fixed
2011-05-30 13:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/f8c459bb273e9aee287ee801ed26b6c189ae6953 [^]
2011-05-30 13:33adrianromeroNote Added: 0037731
2011-06-03 10:57dalsasuaAssigned Toadrianromero => dalsasua
2011-06-07 17:50xabiermerinoNote Added: 0038155
2011-06-07 17:50xabiermerinoStatusresolved => closed

Notes
(0037725)
hgbot   
2011-05-30 13:21   
Repository: erp/stable/2.50
Changeset: f8c459bb273e9aee287ee801ed26b6c189ae6953
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Fri May 27 14:26:29 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/f8c459bb273e9aee287ee801ed26b6c189ae6953 [^]

Fixes issue 0017208: It is not possible save a Project Line with Planned Price = 0
It has been modified the related triggers in order to verify that if planned price is zero, calculate properly related values

---
M src-db/database/model/triggers/C_PROJECTLINE_TRG.xml
M src-db/database/model/triggers/C_PROJECTLINE_TRG3.xml
---
(0037731)
adrianromero   
2011-05-30 13:33   
* Testing the issue

Follow carefully the steps to test and verify that the project line can be saved when planned price is 0 too.

Because it has been modified triggers in the project lines table, it must be verfied also that records can be inserted, updated and deleted. Also all actions must be tested in both database engines: postgresql and oracle.

* Other areas affected.

No other areas affected. Only the triggers of project lines has been modified.
(0038155)
xabiermerino   
2011-06-07 17:50   
verified