Skip to main content
Solved

Report Writer Formatting not working with equations


Forum|alt.badge.img

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!

Best answer by Laura02

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

View original
Did this topic help you find an answer to your question?

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • June 3, 2023

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


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • June 4, 2023

@Laura02 Youre a life saver!! That worked!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings