IMCS Exchange Rate Diferences Calculation Is Incorrect
(Doc ID 3000882.1)
Last updated on JANUARY 29, 2024
Applies to:
Oracle Retail Invoice Matching Cloud Service - Version 23.1 to 23.1 [Release 23.1]Information in this document applies to any platform.
Symptoms
During testing of the new functionality of "Calculate Exchange Rate Variance" released in version 23.1.301.
All tested results resulted in a posting of values and cannot find how they were calculated. So, for the simplest test:
A order in USD with a cost of $ 6139.84 , received when FX rate was 4.2 to PLN which resulted in TRAN_DATA a total cost of 25787.328
Created a Invoice for exactly $ 6139.84 merch cost, using a exchange rate of 4.4 (due to document date).
If you do the math, the invoice has a PLN value of 27015.296. Expecting a posting in transaction EXVAR of the difference which is PLN of 1227,968 (PLN)
Instead in IM_FINANCIALS_STAGE :
AMOUNT: 3683,9 (USD ?)
INCOME_LOCAL_CURRENCY: 16209,16 (PLN ?)
TRANS_AMOUNT: -3683,9
PRIM_TRANS_AMOUNT: -837,25
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Receive a PO of a different currency
2. Create an invoice for the receipt with a different exchange rate assigned
3. Match and Post invoice
4. Analyze posting results
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 |