Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0041183Openbravo ERP07. Sales managementpublic2019-06-26 14:152019-07-23 14:32
marvintm 
rqueralta 
normalmajoralways
closedfixed 
5
 
3.0PR19Q4 
guilleaer
Core
No
0041183: Payment information of the sales order is shown incorrectly in case of payments with different precisions in both currencies
The following issue was previously reported for the WebPOS:

https://issues.openbravo.com/view.php?id=40928 [^]

After it was fixed, the amounts are properly saved in the Openbravo backend. However, the payment information is still not shown correctly in the backoffice windows.

The reason is that the window is showing the information returned from the FIN_PAYMENT_DETAIL_V view, and this view is calculating the amount instead of showing the information from the table columns.
Follow the steps described in the issue https://issues.openbravo.com/view.php?id=40928 [^]

Verify that in the backoffice, the amounts shown are still not correct in the Sales Order payment plan, but in the payment information everything is correct.
No tags attached.
related to defect 0040928 closed rqueralta Retail Modules The precision of the financial account currency is not used in transactions when paying a ticket with a different currency 
Issue History
2019-06-26 14:15marvintmNew Issue
2019-06-26 14:15marvintmAssigned To => Triage Finance
2019-06-26 14:15marvintmModules => Core
2019-06-26 14:15marvintmTriggers an Emergency Pack => No
2019-06-26 14:15marvintmRelationship addeddepends on 0040928
2019-06-26 14:15marvintmRelationship deleteddepends on 0040928
2019-06-26 14:16marvintmRelationship addedrelated to 0040928
2019-06-26 14:16marvintmAssigned ToTriage Finance => Sandrahuguet
2019-06-26 14:17marvintmResolution time => 1563314400
2019-06-26 14:47ngarciaIssue Monitored: ngarcia
2019-06-26 15:58SandrahuguetAssigned ToSandrahuguet => nonofrancisco
2019-07-01 17:54SandrahuguetStatusnew => scheduled
2019-07-03 16:32SandrahuguetAssigned Tononofrancisco => collazoandy4
2019-07-09 12:06SandrahuguetAssigned Tocollazoandy4 => rqueralta
2019-07-09 12:11SandrahuguetNote Added: 0113240
2019-07-11 20:33hgbotCheckin
2019-07-11 20:33hgbotNote Added: 0113317
2019-07-11 20:33hgbotStatusscheduled => resolved
2019-07-11 20:33hgbotResolutionopen => fixed
2019-07-11 20:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b2ebddbb42ab0fec760e4e7cb4944675795123ec [^]
2019-07-23 14:32guilleaerReview Assigned To => guilleaer
2019-07-23 14:32guilleaerStatusresolved => closed
2019-07-23 14:32guilleaerFixed in Version => 3.0PR19Q4

Notes
(0113240)
Sandrahuguet   
2019-07-09 12:11   
No change should be made in FIN_PAYMENT_DETAIL_V view.

finacc_txn_convert_rate should be adjusted depending on precision and when this column is correctly calculated paidconverted (psd.amount * p.finacc_txn_convert_rate) and expectedconverted (COALESCE(psi.amount, pso.amount) * p.finacc_txn_convert_rate) will show the correct values
(0113317)
hgbot   
2019-07-11 20:33   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: b2ebddbb42ab0fec760e4e7cb4944675795123ec
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Tue Jul 09 15:56:01 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b2ebddbb42ab0fec760e4e7cb4944675795123ec [^]

Fixed issue 41183: Payment information of the sales order is shown incorrectly
in case of payments with different precisions in both currencies

- If payment precision is different of order precision, mulrate is calculated
again

---
M src/org/openbravo/retail/posterminal/OrderLoader.java
---