Solved

Amount In Words for Trillion Number


Userlevel 2
Badge

We do not have any facility in Acumatica Reports to convert Amount In words for Trillions.

Eg : 5235460235892.85

Amount In words : 

five trillion two hundred thirty-five billion four hundred sixty million two hundred thirty-five thousand eight hundred ninety-two and eighty-five hundredths.

 

Do we have any solution for this In acumatica ?

 

 

icon

Best answer by Naveen Boga 18 April 2023, 05:36

View original

11 replies

Userlevel 7
Badge +18

Hi @sd79  It seems here is the solution, can you please check the below link?

 

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

Userlevel 7
Badge +10

Hi @sd79 ,

I have got another similar blog post of word representation of amount field in report. 

https://stackoverflow.com/questions/38320680/how-to-do-word-representation-of-amount-field-in-acumatica-invoice-report-ar-64

Hope, it helps!

Regards,

Sweta

Userlevel 2
Badge

Hi @sd79 ,

I have got another similar blog post of word representation of amount field in report. 

https://stackoverflow.com/questions/38320680/how-to-do-word-representation-of-amount-field-in-acumatica-invoice-report-ar-64

Hope, it helps!

Regards,

Sweta

Hi @sweta68 thanks for the response, I have already tried this out, unfortunately it does not work for trillions.

Userlevel 2
Badge

Hi @sd79  It seems here is the solution, can you please check the below link?

 

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

Hi Naveen, thanks for the response, I will try this out today and update you.

Userlevel 7
Badge +18

Sure @sd79  I Hope that helps!!

Userlevel 2
Badge

HI @Naveen Boga @sweta68 

 

All the given examples by you people is working perfectly, there was a mistake in my customization, which is fixed now.

 

Thanks all for your responses.

Userlevel 7
Badge +18

@sd79 Glad that we helped you and thanks a lot for sharing the update.

Userlevel 2
Badge

Hi @Naveen Boga 

 

May you please let me know whether we can use UDF with AP.ToWords function to get Amount in words

 

 

Userlevel 7
Badge +18

@sd79  UDF fields are created based on the attributes that are configured in the system.

 

I don’t think we can use UDF fields for this requirement.

Userlevel 2
Badge

H @Naveen Boga
The UDF is not attribute based, it is created on a DAC extension.

Anyways, I managed to figure out my issue, There was an issue in the .rpx file used. Its rectified now.

Its confirmed that we can use UDF in AP.ToWords function.

Thanks Again for your response

Userlevel 7
Badge +18

@sd79  Oh, okay. Thanks for the clarification.

I thought UDF (User Defined Fields) at the screen level.

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