Solved

Report Writer Formatting not working with equations

  • 3 June 2023
  • 2 replies
  • 82 views

Userlevel 3
Badge

Hello all,

Whenever I use an equation (apologies if wrong terminology) in report writer, the formatting field doesn’t seem to affect the actual result. In this case, it will always return 4 decimal points when I try to format it to return 2. 

Take note of ‘Payment Applied’ - you can see it returns 4 decimal points
Whenever I use an equation (for example, the above), it ignores the formatting

I have tried =###,###.00 , =###,###.## , =######.## , =######.00 , all with and without the quotations as seen above. Any insight into this would be great!

icon

Best answer by Laura02 3 June 2023, 12:13

View original

2 replies

Badge +18

Hello,

Here is a screen shot of the Invoice/Memo form that comes with Acumatica. Did you try $#,##0.#0? I think, you won’t need the $ + in the Value field.

Laura

Userlevel 3
Badge

@Laura02 Youre a life saver!! That worked!

Reply


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