Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010130Openbravo ERP02. Master data managementpublic2009-07-30 13:582009-08-18 00:00
Reporternetworkb 
Assigned Toharikrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.50MP2 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010130: The discounts are not correctly copied when using create lines from in the invoice window
DescriptionThe discounts are not correctly copied when using create lines from in the invoice window.
The discounts are copied but the multiplication with the price and quantity
to calculate the total is not correctly done.
Steps To Reproduce-Create a sales order with one line an a discount
-Complete the sales order and see that the discount has been aplied.
-Create a new sales invoice
-Execute the create from lines and select the lines of the order created previously.
-See that the lines have been created.
-Check the line of the discount and see that the total of this line is not correct
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00115122.50MP10 closed rafaroda Invoice line net amount wrongly rounded of, while line item is created using the button create line from 
related to defect 00119432.50MP11 closed harikrishnan the quantity of line is rounded when it is created by "create from lines" in goods receipt 
Attached Filespng CreateLinesFrom.png (69,677) 2009-07-31 17:00
https://issues.openbravo.com/file_download.php?file_id=1612&type=bug
png

png Select.png (18,934) 2009-08-05 12:11
https://issues.openbravo.com/file_download.php?file_id=1623&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-07-30 13:58networkbNew Issue
2009-07-30 13:58networkbAssigned To => rafaroda
2009-07-31 10:37networkbNote Added: 0018754
2009-07-31 17:00rafarodaFile Added: CreateLinesFrom.png
2009-07-31 17:12rafarodaAssigned Torafaroda => harikrishnan
2009-07-31 17:12rafarodaStatusnew => scheduled
2009-08-04 09:50rafarodaPriorityimmediate => high
2009-08-05 12:11rafarodaFile Added: Select.png
2009-08-05 12:12rafarodaNote Added: 0018839
2009-08-06 11:52hgbotCheckin
2009-08-06 11:52hgbotNote Added: 0018860
2009-08-06 11:52hgbotStatusscheduled => resolved
2009-08-06 11:52hgbotResolutionopen => fixed
2009-08-06 11:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b1a726132510ffc93da4a16f58c5546fc370c67f [^]
2009-08-17 11:09sureshbabuStatusresolved => closed
2009-08-17 11:09sureshbabuNote Added: 0018961
2009-08-17 11:09sureshbabuFixed in Version => pi
2009-08-18 00:00anonymoussf_bug_id0 => 2839268
2010-01-11 09:43rafarodaRelationship addedrelated to 0011512
2010-01-12 18:10rafarodaRelationship addedrelated to 0011943

Notes
(0018754)
networkb   
2009-07-31 10:37   
We have seen that what happens is that the decimals are not correctly managed in the multiplications in this process
(0018839)
rafaroda   
2009-08-05 12:12   
Copy lines from is not respecting currency precision for line net amount:

SELECT ol.priceactual AS ORDERPRICE, IL.PRICEACTUAL AS INVOCIEPRICE,
ol.qtyordered AS ORDERQTY, IL.QTYINVOICED AS INVOICEQTY,
OL.linenetamt AS ORDERNETAMT, IL.LINENETAMT AS INVOICENETAMT
FROM C_ORDERLINE OL, C_INVOICELINE IL
WHERE il.c_orderline_id = ol.c_orderline_id
ORDER BY IL.UPDATED DESC
(0018860)
hgbot   
2009-08-06 11:52   
Repository: erp/devel/pi
Changeset: b1a726132510ffc93da4a16f58c5546fc370c67f
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Thu Aug 06 15:20:12 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/b1a726132510ffc93da4a16f58c5546fc370c67f [^]

Fixes Issue 10130: The discounts are not correctly copied when using create lines from in the invoice window

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
(0018961)
sureshbabu   
2009-08-17 11:09   
Tested, discount is rightly applied in the discount line item in invoice document.