Solved

How to add the currency symbol to forms.

A
  • Anonymous
  • 0 replies

Hi, 
I am trying to add the currency symbol $ in front of the dollar numbers on forms. 
Is there an easier way of doing this rather than going to every dollar field & adding the format of $###,###.00 ? 

 

icon

Best answer by Naveen Boga 25 May 2022, 16:17

View original

4 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @bfilipiak  I don’t think we can add the $ symbol at the screen level, but we can add this $ symbol in the reports like below.

 

 

Naveen B
A

@Naveen Boga , Thank you. I had already figured that out I was hoping for a generic way or a parameter to have the currency symbol added as part of the formatting. 

The help states that:

Currency Symbol The currency symbol to be used in reports according to the ISO 4217 standard.

But I do not see how that is implemented.

 

M
Rank
Userlevel 4
Badge +1

The formatting should be $###"###.00 in single quotes, ‘$###,###.00 ‘ Also, that that might not allow to print great than 999k. ='$###,###,###.00' is the proper format. 

Foujan
Rank
Userlevel 3
Badge

@marina25 correct, that works well for AUD and USD customers. but if we print same report for different currency symbols like EURO(€), there a way to add currency symbol to the report which will get the symbol from the document’s currency set up.

I added Currency table and joined it to my sales order table (in my case, your report might use a different table).
So if the currency changes on document, the report will automatically pick up the correct symbol.

 

 

Reply


Terms & ConditionsCookie settings
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