Solved

Amount in words for calculated number

  • 26 July 2023
  • 6 replies
  • 145 views

Userlevel 3
Badge

Hello

I have a number in Acumatica Report which is calculated from following expression:

How to display this result from Decimal in words?

I found  a few articles but it isn’t what I need:

Do you have any solution?

Cheers

icon

Best answer by mrthanhkhoi 19 September 2023, 05:32

View original

6 replies

Userlevel 3
Badge

Still have no solution yet 😞

Badge +18

Hello,

Did you try to mimic the solution used on AP Checks?

Laura

Userlevel 3
Badge

Hello @Laura02, it is ok if I display an Amount field by text in Report for example:

I have field Cost to Words which represent amount Balance in text

and I could display this field in report:

 

However, My requirement is a bit more complex. I want to summary all Invoices by Customer (by a expression) and display the result by text.

Example:  

  • Expression to calculate summary all Invoice: = Sum(ARInvoice.CuryDocBal)
  • Result number: 1,000,000
  • Expected displaying: one milion

 

Userlevel 7
Badge

Hi @mrthanhkhoi were you able to find a solution? Thank you!

Userlevel 3
Badge

Hello @Chris Hackett,

Unfortunately, I was not able to find a “Smart and lazy” solution.

I went with “hard-working” solution as work-around which is described in description (https://acumatica12.rssing.com/chan-6994821/article91.html)

But I still wait for truly solution

Hi @mrthanhkhoi , have you found any other solution because I also having the same issue now but since the sample given only works up to 10k, so i am trying to find if we can try to convert till million

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