Incorrect Currency Totals Being Displayed in Till Summary Report (Doc ID 2005251.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Retail Point-of-Service - Version 14.0.1 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.

Symptoms

Till Summary Report shows incorrect data after performing Post Void transaction, when the post voided transaction is tendered with foreign currency.

Steps To Recreate:
1) Open Store, Register and Till.
2) Perform a Sale transaction tendering with base currency (Ex:USD)
3) Check Till Summary Report.
4) Perform a Sale and Tender with CAD ( foreign currency).
5) Check Till Summary Report .
6) Post Void the transaction done at step (4).
7) Check Till Summary Report. This report displays wrong data.


 
Eg:
Done sale using USD as tender
i.e

Subtotal 50.95
Total Sales Tax 4.20

Total Tender 55.15

=====================================================
Done sale using CAD as tender

Subtotal 50.95
Total Sales Tax 4.20

Total 55.15

  Cash 55.15
  CAD Amt. Rec'd: 57.37
  Exchange Rate: 0.961317

Total Tender 55.15

=======================================================

Perform post void for the sale transaction whose tender is done using CAD:

Subtotal (50.95)
Total Sales Tax (4.20)

Total (55.15)

  Cash (55.15)
  CAD Amt. Rec'd: (57.37)
  Exchange Rate: 0.961317

Total Tender Reversed (55.15)


=======================================================

Now check Till summary report for the post void transaction:

Cash
In 0 (2.22)
Out 0 0.00
Net (2.22)
Counted 0.00

Over/Short (99,997.78)

Observed : (2.22) is shown in USD total which should be 0.00 in this case.

Since while performing post-void transaction should be in base currency i.e USD but here this is done in CAD.

i.e 55.15 ( 1st sale transaction value) - (minus) 57.37 (i.e Post void transaction value in CAD but should be in USD) == (2.22) Which is wrong.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms