Skip to main content
Answer

Amount in words for calculated number

  • July 26, 2023
  • 6 replies
  • 365 views
M
Jr Varsity II
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

Laura03

6 replies

M
Jr Varsity II
Forum|alt.badge.img
  • mrthanhkhoi
  • Author
  • Jr Varsity II
  • August 26, 2023

Still have no solution yet 😞

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

Hello,

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

Laura

~ Laura Barber, WM Synergy
Chris Hackett
M
Jr Varsity II
Forum|alt.badge.img
  • mrthanhkhoi
  • Author
  • Jr Varsity II
  • August 26, 2023

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
  • Chris Hackett
  • Acumatica Community Manager
  • September 18, 2023

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
M
Jr Varsity II
Forum|alt.badge.img
  • mrthanhkhoi
  • Author
  • Jr Varsity II
  • Answer
  • September 19, 2023

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

Chris Hackett
W
Freshman II
Forum|alt.badge.img
  • wanizaidi27
  • Freshman II
  • January 16, 2024

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

Terms & ConditionsCookie settingsAccessibility 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