Lost here, but we have Currency Evaluations happening against payments after they have been applied to invoices. Then invoices gets marked paid in full, but then the currency evaluations make the invoice have a balance of a penny. Any idea where to start to try and understand what is happening?
m
Marc
01/15/2024, 10:29 PM
"Are the transactions in a foreign currency? If yes, do you have an exchange rate for these transactions and a different exchange rate for your payments? In such cases, the system creates a realized gain/loss currency revaluation. Sometimes, the system uses a system account to log rounding issues.
n
Noel B
01/15/2024, 10:34 PM
Yes it is a foreign currency. But the exchange rates on the invoice and payment are the same. It looks like the payment is from a CSV upload so I might gleam some more information if I can find that upload file and see what is being uploaded.
Thank you for this link I will pass it on. Do you know if there is any "default" way to close the invoice without have a penny balance? What you linked is the perfect example of what is happening.
m
Marc
01/15/2024, 11:20 PM
The GL impact between the transaction and the payment is different by a penny so maybe try to readjust the exchange rate of the payment that it is exactly the same GL Impact
i.e : invoice 100€ -> gl impact 110 USD
payment 100€ with the same exchange rate -> 109,99 USD
Edit the exchange rate manually until you have the same GL Impact