Solved

How to convert amount into word when the amount is more than ten thousand

  • 25 April 2023
  • 7 replies
  • 194 views

Userlevel 3
Badge

Hi,

 

I need to show the amount from the word in my custom report. I found some reference for that

http://blog.acumatica.com.sg/2017/09/amount-to-words-conversion-at-acumatica.html

But,like that we can’t do the convert more than 10k numbers into word.

Do we any alternative way do that from the report designer.

 

icon

Best answer by aaghaei 27 April 2023, 16:25

View original

7 replies

Userlevel 7
Badge +8

https://www.acumatica.dev/admin/decimal-amount-into-text-words/

 

The above link instructions will do the work for you 

Userlevel 3
Badge

H @aaghaei ,

Do we need to do some customization for that.

 

Badge +11

Yes, this is customization territory. Unfortunately, it’s not even a built customization; just code.

Userlevel 3
Badge

Hi @aaghaei ,

I added this dac extension and amount is converted to word.

When the amount has decimal values it show like 22/100.We need to replace it as 22 cents or twenty two cents.

 

Can u suggest any workaround for that.

Userlevel 7
Badge +8

I don’t really see an issue with that and even in check writing people do so for cents.

But if you insist on all in word version, then this is what you can do. Pass the whole number only to the existing ToWord custom field and add a new ToWord custom field and pass the decimal part of the amount then in the report designer concat these 2 new custom fields. It will do the work for you.

Userlevel 2
Badge

https://www.acumatica.dev/admin/decimal-amount-into-text-words/

 

The above link instructions will do the work for you 

Instructions in the above link is not showing any output for UDF used in AP.ToWords function.
any suggestions are welcome

Userlevel 2
Badge

Hi @aaghaei ,

I added this dac extension and amount is converted to word.

When the amount has decimal values it show like 22/100.We need to replace it as 22 cents or twenty two cents.

 

Can u suggest any workaround for that.

Does it work for UDF as shown below ?
 

 

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