I want to display the above highlighted field in my report .
Answer
How to display currency rate of Invoice screen in report?
Best answer by Laura03
Hello,
When I clicked Customization → Inspect Element in Invoices & Memos screen, Acumatica didn’t show me the field name that holds the currency rate.
Next I created a simple GI to show every field of ARInvoice table: I cannot see the currency rate 0.91605039 in any field of ARInvoice table.
I think it will be tricky to find a proper rate stored in a table; it looks to me like you’ll need to join your Invoice Report to Currency Rate table and use the Invoice Date + Invoice Currency to find a proper rate.
Exchange Rate field in the above report is RowCurrencyRate.CuryRate.
Hope this helps you.
Laura
Steve - Klear Systems
+4
+19Hello,
When I clicked Customization → Inspect Element in Invoices & Memos screen, Acumatica didn’t show me the field name that holds the currency rate.
Next I created a simple GI to show every field of ARInvoice table: I cannot see the currency rate 0.91605039 in any field of ARInvoice table.
I think it will be tricky to find a proper rate stored in a table; it looks to me like you’ll need to join your Invoice Report to Currency Rate table and use the Invoice Date + Invoice Currency to find a proper rate.
Exchange Rate field in the above report is RowCurrencyRate.CuryRate.
Hope this helps you.
Laura
~ Laura Barber, WM Synergy
This is the correct way to find the general currency rate on a specific date, but it is not necessarily correct for this specific document, because the user can override the currency rate on the document.
You need to use the CurrencyInfo table for this.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.