Incorrect conversion date on the Secondary ledger
Dear Gurus,
Please help us on the following matter!
Recently our company has started using the Secondary ledger in USD. But the problem is that sometimes, when we create accounting for payable, we noticed that some invoices (had a different currency from the primary & secondary ledger) use incorrect currency conversion date.
For example, the invoice date is JUN-25 and the amount was 20K CNY. The primary ledger currency is MNT, secondary ledger currency is USD, and the Invoice currency is CNY.
On the Journal entry, in the secondary ledger:
It should be: 3022.45USD
Sec.ledger (USD) invoice amount = 20000CNY x 292.99MNT (Rate Jun-25, CNY – MNT) / 1938.76MNT (