Hello,
In our current system (dual currency) Euro is the accounting currency and USD it is the reporting one.
We are using projects and because we want to see the WIP immediately we are using item requirement. This is when we have noticed a very strange behaviour of the system.
If I recieve a Purchase Order in USD on the 31st on March for the 1st of March, (because I forgot to do it earlier), the Product receipt will post with the exchange rate of the 1st, and this is fine until now. Because we have item requirement the system automatically posts a Packing slip and here it is when the issue comes in, this item requirement posts in 31st March currency (the accounting the currency), then also posts the amounts in reporting currency but with 1st of March exchange rate. This leads to wrong balances for both Accounting and Reporting currency for the clearing account used for this purpose and the difference will sit there not sending to 0:
Currency rates:
Product receipt:
Then the system posts automatically the item requirment:
The amount in EUR should be 6,188.52 rather than 6,000.00 So the system is picking up the daily rate as shown on the picture above containing the rates converting from 6,480.00 of the PR to 6,000.00 on the Item requirement: 1.0800 (02/04/2025)- not right.
And in the Item requirement itself conversion from EUR (accounting currency) to USD (reporting currency), is done by the transaction date (31/03/2025) from 6,000.00 to 6,282.60.
This leads to difference in the GL account unbalancing it:
The transaction should pick the transaction rate all the time and not make differences.
Has anyone ever faced something like this before? DO you have any idea how this can be fixed? I have also reached to MS support but I haven't gotten any response yet.
Thank you in advance,
Lira
