Skip to main content
Solved

How to add the currency symbol to forms.

  • 25 May 2022
  • 4 replies
  • 602 views

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 ? 

 

4 replies

Naveen Boga
Rank
Userlevel 7
Badge +19

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