[ https://issues.apache.org/jira/browse/OFBIZ-12390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17605870#comment-17605870 ]
Ingo Wolfmayr edited comment on OFBIZ-12390 at 9/16/22 2:46 PM: ---------------------------------------------------------------- Hi Jacques, I have updated the XML files. 1.) Import [^pricecheckData-1.xml] 2.) Import Orders.xml 3.) Update the order to recalculate prices. The order will then be up-to-date. There is no payment preference right now. 4.) Goto Webtools and run the service "createPaymentFromOrder" - it will create a new payment preference. If you create one payment preference before applying the patch you will see the wrong amount. Apply the patch and run the service again. You will see a second preference with the right amount. See the image below. Thanks, Ingo !image-2022-09-16-16-43-38-897.png! was (Author: iwolf): Hi Jacques, I have updated the XML files. 1.) Import [^pricecheckData-1.xml] 2.) Import Orders.xml 3.) Update the order to recalculate prices. The order will then be up-to-date. There is not payment preference right now. 4.) Goto Webtools and run the service "createPaymentFromOrder" - it will create a new payment preference. If you create one payment preference before applying the patch you will see the wrong amount. Apply the patch and run the service again. You will see a second preference with the right amount. See the image below. Thanks, Ingo !image-2022-09-16-16-43-38-897.png! > Order/Invoice: Item total result diff total result > -------------------------------------------------- > > Key: OFBIZ-12390 > URL: https://issues.apache.org/jira/browse/OFBIZ-12390 > Project: OFBiz > Issue Type: Improvement > Components: accounting, order > Affects Versions: Trunk, 17.12.08, 18.12.01, Upcoming Branch > Reporter: Ingo Wolfmayr > Priority: Major > Attachments: Orders.xml, cartRounding.patch, > image-2021-11-19-09-44-18-759.png, image-2021-11-19-09-44-44-443.png, > image-2021-11-19-09-59-07-571.png, image-2022-09-16-16-43-38-897.png, > pricecheckData-1.xml > > > In some cases the order total is not correct: > net price: €1.273 > 10% sales tax: € 0.127 > quantity: 1 > grand total: € 1.40 > Now taking the same product and adding it with two order lines: > grand total: € 2.79 > Right now the grand total is calculated by total all item net prices, total > all adjustments and finally adding those two values together. > The following screenshots are taken from the orderview. Ofbiz request a > payment of € 2.80 but will create an invoice with a grand total of € 2.79. > !image-2021-11-19-09-44-18-759.png! > !image-2021-11-19-09-44-44-443.png! > Heres the result with just one orderline: > !image-2021-11-19-09-59-07-571.png! > > I have created a XML file for testing. Import the file via XML import and > create an order: > partyId: AUT_CUSTOMER > productStore: Test GmbH > product 1: AUT_PRODUCT (quantity 1) > product 1: AUT_PRODUCT_CP (quantity 1) > Checkout with default settings. > From my perspective the calculation should be changed to calculate the total > amount for each line and calculate the grand total from these results. > -- This message was sent by Atlassian Jira (v8.20.10#820010)