Openbravo Issue Tracking System - Retail Modules
View Issue Details
0038889Retail ModulesCash uppublic2018-07-04 15:112018-07-26 11:36
lmonreal 
ranjith_qualiantech_com 
highmajoralways
closedfixed 
5
 
RR18Q4 
marvintm
No
0038889: Cash up report- Withdrawal section is wrongly calculated because System is applying conversion rate twice.
Cash up report- Withdrawal section is wrongly calculated because System is applying conversion rate twice.
Pre requisites

1. Have cash available in USD and EUR to return
2.Conversion rate is set to
USD-EUR divided by 1.314371 and multiply by 0.76082


Steps:
1. Pay a return with EUR (Avalanche transceiver, -150.50 eur)
2. Pay a return with USD (Avalanche transceiver, -197.81 usd)
3. Do a cash up
4. In back office download cash up report from the terminal
5. Check withdrawal section and it shows:

Cash EUR 150.50
Cash USD 150.50 (197.81 USD)
Total: 265

This is wrong 150.5 + 150.5 is 301. This is happening for the following reason:
The report shows the values already converted in EUROS (197.81 usd= 150.5 eur).However for CASH USD it is applying the conversion rate again to 150.50.

150.50 divided by conversion rate 1.314371 is 114.50.

Hence if I sum CASH EUR 150.50+ CASH USD 114.5= 265

So system is applying the conversion rate wrongly twice and this is why the sum is wrong.

Apply conversion rate once.
No tags attached.
png withdr.png (17,955) 2018-07-04 15:11
https://issues.openbravo.com/file_download.php?file_id=11932&type=bug
png
Issue History
2018-07-04 15:11lmonrealNew Issue
2018-07-04 15:11lmonrealAssigned To => Retail
2018-07-04 15:11lmonrealFile Added: withdr.png
2018-07-04 15:11lmonrealResolution time => 1532469600
2018-07-04 15:11lmonrealTriggers an Emergency Pack => No
2018-07-05 14:05ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2018-07-05 14:05ranjith_qualiantech_comStatusnew => scheduled
2018-07-10 09:03hgbotCheckin
2018-07-10 09:03hgbotNote Added: 0105689
2018-07-10 09:03hgbotStatusscheduled => resolved
2018-07-10 09:03hgbotResolutionopen => fixed
2018-07-10 09:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/6813dfe07421c7f6ceea5dc7d1c930088de2ebee [^]
2018-07-26 11:36marvintmReview Assigned To => marvintm
2018-07-26 11:36marvintmStatusresolved => closed
2018-07-26 11:36marvintmFixed in Version => RR18Q4

Notes
(0105689)
hgbot   
2018-07-10 09:03   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 6813dfe07421c7f6ceea5dc7d1c930088de2ebee
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jul 10 12:32:51 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/6813dfe07421c7f6ceea5dc7d1c930088de2ebee [^]

Fixed issue 38889 : Removed Additional Currency conversion for Withdrawals in Cashup Report

---
M src/org/openbravo/retail/posterminal/ad_reports/CashUpReport.java
---