TRAN_DATA.TOTAL_COST_EXCL_ELC Is Calculated Using Posted Date Exchange Rate Instead Of Transaction Date Exchange Rate
(Doc ID 2664354.1)
Last updated on AUGUST 16, 2022
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.
For Import Order when Receiver Unit Adjustment (RUA) is performed TOTAL_COST_EXCL_ELC in TRAN_DATA is calculated based on the posted exchange rate.
Steps To Recreate:
- Create an Import Purchase Order(PO).
- Receive it fully.
- Perform on RUA on the date where the effective currency rate is different than the one used when the original receipt happened.
|Exchange rate on Transaction date (31-Jan-2020)||106.00|
|Exchange rate on Posted date (2nd-FEB-2020)||104.00|
|Unit cost in USD||2.12|
|TRAN_DATA.TOTAL_COST||16*2.12*106 = 71012|
|TRAN_DATA.TOTAL_COST_EXCL_ELC||316*2.12*104 = 69672|
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document