Skip to main content
Answer

How to show field Currency rate on report designer ?

  • December 15, 2022
  • 2 replies
  • 135 views
H
Jr Varsity II
Forum|alt.badge.img

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.

Best answer by YasasWithanage76

@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]

 

 

​​​​

 

2 replies

YasasWithanage76
Acumatica Employee
Forum|alt.badge.img+4
  • YasasWithanage76
  • Acumatica Employee
  • Answer
  • December 15, 2022

@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]

 

 

​​​​

 

BenjaminCrisman
robk20
H
H
Jr Varsity II
Forum|alt.badge.img
  • hthuy24
  • Author
  • Jr Varsity II
  • December 15, 2022

@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 

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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