Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0033898
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2016-09-05 16:392019-01-07 17:45
ReporterguilleaerView Statuspublic 
Assigned Toguilleaer 
PrioritynormalResolutionfixedFixed in VersionRR16Q4
StatusclosedFix in branchFixed in SCM revision9514e62268ee
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033898: Rounding issues paying with foreign currency

DescriptionHaving a certain configuration, payments done in foreign currency does not match with the amounts expected in the "default" currency.

Example:
The customer have to pay 541.65€ but he decides to pay it using USD
In that case -> 32.827272727 USD so rounding the user will have to pay 32.83$
Then once the payment is done, we convert the amount again to EUR and we get
541.695 which is rounded to 541.70

As you can see, the user is paying 541.70 instead of 541.65.

This is normal due to the loss of precision, but it is not acceptable because order/invoice will not be perfectly matched.


Al convertir de MXN 541.65 a USD se obtienen 32.83 USD (32.827272727 sin el redondeo). El problema es que al convertir de vuelta de USD a MXN, 32.83 da 541.695, que redondeado da 541.70.

Un ejemplo concreto se puede ver en el pedido: 3123-2/0039886.
Steps To ReproduceConfigure EUR currency
USD -> 0.060606 - 16.5

Configure USD currency
EUR -> 16.5 - 0.060606

Add A Prduct to the ticket
Change price to 541.65
Pay it using USD
Check Created Sales order in the ERP:

   - Payment plan has an outstanding of -0.05
   - Payment details shows 541.70 instead of 541.65
   - Payment in amount is 541.70 instead of 541.65
Proposed SolutionAfter discuss with functional team, we will proceed in the same way that ERP.

When a payment to completely pay the order is done using a foreign currency is done, the system should adjust the quantity to match with the amount which is pending in the "default" currency.
TagsNo tags attached.
Attached Filesdiff file icon multicurrency_rounding.diff [^] (7,502 bytes) 2016-09-05 16:39 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0033059 closedranjith_qualiantech_com rounding problem with multicurrency 
depends on backport 0033983RR16Q3.2 closedguilleaer Rounding issues paying with foreign currency 
depends on backport 0033984RR16Q2.3 closedRetail Rounding issues paying with foreign currency 
related to defect 0034084 newRetail Pending test to be developed 

-  Notes
(0089785)
hgbot (developer)
2016-09-06 16:14

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 9514e62268ee017778da2efab7507122bb8ada57
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Sep 06 16:13:30 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9514e62268ee017778da2efab7507122bb8ada57 [^]

Fixed issue 33898: Last payment in foreign currency is adjusted to expected to avoid differences

When a payment is done, the code will check if this payment satisfy the amount which is pending in foreign amount. If the amount is satisfied then the amount of this payment will be calculated from the pending amount instead of converting the payment to the default currency which can cause differences.

---
M web/org.openbravo.retail.posterminal/js/model/order.js
---
(0089791)
guilleaer (manager)
2016-09-06 19:03

Reopened because tests are missing
(0089793)
hgbot (developer)
2016-09-06 19:11

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: b91a99381341a6d9da4d37d489c286e0ab2fadd9
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Sep 06 19:10:37 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b91a99381341a6d9da4d37d489c286e0ab2fadd9 [^]

Related to issue 33898: reuse value stored in var instead to call function again

---
M web/org.openbravo.retail.posterminal/js/model/order.js
---
(0090278)
guilleaer (manager)
2016-09-26 23:14

Resolved.

Test is pending. Added to the list of tests included in issue https://issues.openbravo.com/view.php?id=34084 [^]
(0105932)
hgbot (developer)
2018-07-24 17:41

Repository: tools/automation/pi-mobile
Changeset: fcef70df296e63e4b01964ed1d79231b68913600
Author: Alejandro <alekosmp86 <at> gmail.com>
Date: Fri Jul 20 15:44:27 2018 -0400
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/fcef70df296e63e4b01964ed1d79231b68913600 [^]

Related to issue 33898: added automated test

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/payment/I33898_VerifyRoundingWhenPayingInForeignCurrency.java
---
(0108846)
hgbot (developer)
2019-01-07 17:45

Repository: tools/automation/pi-mobile
Changeset: 4667e7da417d60eed890afd56a4280877ca2b3f2
Author: Alejandro <alekosmp86 <at> gmail.com>
Date: Thu Dec 20 13:48:05 2018 -0500
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/4667e7da417d60eed890afd56a4280877ca2b3f2 [^]

Related to issue 33898: this test no longer creates its own sampledata.

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/payment/I33898_VerifyRoundingWhenPayingInForeignCurrency.java
---

- Issue History
Date Modified Username Field Change
2016-09-05 16:39 guilleaer New Issue
2016-09-05 16:39 guilleaer Assigned To => guilleaer
2016-09-05 16:39 guilleaer File Added: multicurrency_rounding.diff
2016-09-05 16:39 guilleaer Triggers an Emergency Pack => No
2016-09-06 16:14 hgbot Checkin
2016-09-06 16:14 hgbot Note Added: 0089785
2016-09-06 16:14 hgbot Status new => resolved
2016-09-06 16:14 hgbot Resolution open => fixed
2016-09-06 16:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/9514e62268ee017778da2efab7507122bb8ada57 [^]
2016-09-06 16:21 guilleaer Status resolved => new
2016-09-06 16:21 guilleaer Resolution fixed => open
2016-09-06 16:22 guilleaer Assigned To guilleaer => Retail
2016-09-06 19:03 guilleaer Note Added: 0089791
2016-09-06 19:11 hgbot Checkin
2016-09-06 19:11 hgbot Note Added: 0089793
2016-09-06 23:15 guilleaer Relationship added related to 0033059
2016-09-14 10:17 marvintm Status new => scheduled
2016-09-26 23:13 guilleaer Relationship added related to 0034084
2016-09-26 23:14 guilleaer Note Added: 0090278
2016-09-26 23:14 guilleaer Status scheduled => resolved
2016-09-26 23:14 guilleaer Fixed in Version => RR16Q4
2016-09-26 23:14 guilleaer Resolution open => fixed
2016-09-28 10:38 marvintm Assigned To Retail => guilleaer
2016-09-29 15:58 marvintm Review Assigned To => marvintm
2016-09-29 15:58 marvintm Status resolved => closed
2018-07-24 17:41 hgbot Checkin
2018-07-24 17:41 hgbot Note Added: 0105932
2019-01-07 17:45 hgbot Checkin
2019-01-07 17:45 hgbot Note Added: 0108846


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker