Solved

Amount in words for calculated number

  • 26 July 2023
  • 6 replies
  • 113 views
M
Rank
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

M
Rank
Userlevel 3
Badge

Still have no solution yet 😞

Laura02
Rank
Badge +18

Hello,

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

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
M
Rank
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

 

Chris Hackett
Rank
Userlevel 7
Badge

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
Rank
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

W
Rank

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


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