ReIM - Deal CNR Generated With Wrong Currency
(Doc ID 2955966.1)
Last updated on JUNE 19, 2023
Applies to:
Oracle Retail Invoice Matching - Version 16.0.1 and laterInformation in this document applies to any platform.
Symptoms
The Credit Note Request automatically generated by RMS Complex Deal is with wrong currency.
The Supplier currency is USD
The Deal is created with USD
The information in the tables DEAL_ACTUALS_FORECAST, DEAL_ACTUALS_ITEM_LOC, ITEM_LOC_HIST, STAGE_COMPLEX_DEAL_DETAIL and STAGE_COMPLEX_DEAL_HEAD are in USD
But the Credit Note Request values are in UYU (Uruguay Peso) in IM_DOC_HEAD and IM_COMPLEX_DEAL_DETAIL
Note that the TAX information is in USD in the table IM_COMPLEX_DEAL_DETAIL_TAX
Steps to reproduce:
1 - Create a Complex Deal (based on sales) in USD
2 - Simulate the sales in RMS
3 - Execute all the Complex Deal processes
4 - Notice that the values are in USD in the Complex Deal tables (DEAL_ACTUALS_FORECAST, DEAL_ACTUALS_ITEM_LOC, ITEM_LOC_HIST, STAGE_COMPLEX_DEAL_DETAIL and STAGE_COMPLEX_DEAL_HEAD)
5 - Execute ReIM process batch in order to create the Credit Note Request
6 - Notice that the document is created with the currency USD, but the amounts (header and details) are converted to UYU (the total should be -40000 USD, but it is -1306399,981)
6.1 - Notice that the doc tax information is -40000 USD
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |