Skip to main content
Solved

Amount in words for calculated number


Forum|alt.badge.img

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

Best answer by mrthanhkhoi

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

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

Forum|alt.badge.img

Still have no solution yet 😞


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • August 26, 2023

Hello,

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

Laura


Forum|alt.badge.img

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

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • September 18, 2023

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


Forum|alt.badge.img

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


Forum|alt.badge.img

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


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