Skip to main content
Solved

How to add the currency symbol to forms.

  • May 25, 2022
  • 4 replies
  • 858 views
A
  • Anonymous

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 ? 

 

Best answer by Naveen Boga

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.

 

 

    4 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+20
    • Naveen Boga
    • Captain II
    • Answer
    • May 25, 2022

    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 - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
      A
      • Anonymous
      • May 25, 2022

      @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
      Jr Varsity I
      Forum|alt.badge.img+1
      • marina25
      • Jr Varsity I
      • February 27, 2023

      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
        Jr Varsity II
        Forum|alt.badge.img
        • Foujan
        • Jr Varsity II
        • March 6, 2023

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

         

         

          Terms & ConditionsAccessibility 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