Skip to main content
Solved

Formattig issue

  • January 22, 2025
  • 5 replies
  • 121 views
  • Translate All
Freshman I

Hi community,

I need some help with a formatting issue. In a Sales Order report, I am using a subreport to fetch VAT and SVAT values, and the values are being retrieved correctly. However, there is a formatting issue. The numbers are displayed like 1669.18, but I want them to be formatted with thousand separators, like 1,669.18.
 

I tried using ‘#,##0.00’ and ‘SOLine.OrderQty.Format’ to change the value format, but it didn’t work. Does anyone have a solution to fix this.
 

 

Best answer by nhatnghetinh

Hi ​@kviranga38 

Please try using Format    #,##.00

 

Best Regards,

NNT

View original

5 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@kviranga38 

Please try using Format =[SOOrder.CuryLineTotal.Format]

 

Best Regards,

NNT

Translate
I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
Freshman I
  • kviranga38
  • Author
  • Freshman I
  • January 22, 2025

Hi ​@nhatnghetinh 

Thanks for the suggestion. I tried that, but it didn’t work. Do you have any other ideas or suggestions that might help.
 

Best Regards

Translate
nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@kviranga38 

I tested and the report worked fine. 

 

Please send your .rpx report file.

 

Best Regards,

NNT

Translate
I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
    nhatnghetinh
    Captain II
    Forum|alt.badge.img+14

    Hi ​@kviranga38 

    Please try using Format    #,##.00

     

    Best Regards,

    NNT

    Translate
    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      Jr Varsity I
      Forum|alt.badge.img+6

      Hi @kviranga38,

      please try to use the format  #,##.00

      Translate
        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