I need to make the base currency to MYR currency, but the problem is I cannot make the MYR currency rate equal to GL date. As you can see. the cury effective rate is in 2021 while the GL is on 2026.
Question
How to make CurrencyEffective MYR Rate tally with The GL Tran Date
+20Hello,
To answer your report question, first verify current exchange rates exist in your tenant *for every day* you are trying to report.
Then try joining transaction tables to currency tables by Date and Currency ID, such as GLTran.TranDate = CurrencyInfo.Currency Effective Date.
I’d like to understand your goal with the above report. If you are translating GL account balances, I recommend using Translation Definition and Translation Worksheets features of Acumatica.
Transaction details s may easily be viewed in original vs. base currencies in Finance → GL Details screen:
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.