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.
Best answer by aaghaei
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.
+10https://www.acumatica.dev/admin/decimal-amount-into-text-words/
The above link instructions will do the work for you
+13Yes, this is customization territory. Unfortunately, it’s not even a built customization; just code.
Hi
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.
+10I 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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
