Solved

How to show field Currency rate on report designer ?

  • 15 December 2022
  • 2 replies
  • 74 views

Userlevel 4
Badge

Hi everyone,

I want to show field currency rate in report designer but I dont know how to do that?

 

If you have any idea, pls advice me.

Thanks in advanced.

icon

Best answer by YasasWithanage76 15 December 2022, 08:54

View original

2 replies

Userlevel 5
Badge +2

@hthuy24 

To achieve this requirement you can try a calculated field in the report.

For example, I added a calculated field to invoice print (AR641000)

=[ARInvoice.DocBal]/[ARInvoice.CuryOrigDocAmt]

 

 

​​​​

 

Userlevel 4
Badge

@hthuy24

To achieve this requirement you can try a calculated field in the report.

For example, I added a calculated field to invoice print (AR641000)

=[ARInvoice.DocBal]/[ARInvoice.CuryOrigDocAmt]

 

 

​​​​

 

Thanks @YasasWithanage76 , I will try 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved