I’m presenting the following situation in the Aged Receivable Report:
My company’s base currency is Mexican Pesos (MXN), and my invoices are issued in U.S. Dollars (USD).
I have invoice 57031 with a balance of $0.39 USD, but when I run the Aged Receivable Report with Target Currency set to MXN, it shows a very high amount of $22,392.28 MXN, which is incorrect. The exchange rate at the time of running the report is $18.8483.
The report should show a total of $63.896 MXN, which is the result of converting the original amount from USD to MXN:
3.39 * 18.8483 = 63.896
Has anyone experienced a similar issue or can provide any insight into why this value is being displayed?
