Skip to main content
Solved

Amount In Words for Trillion Number

  • April 18, 2023
  • 11 replies
  • 299 views
  • Translate All

Forum|alt.badge.img

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 ?

 

 

Best answer by Naveen Boga

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/

View original

11 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20

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/

Translate

Forum|alt.badge.img+9
  • Semi-Pro III
  • April 18, 2023

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

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • April 19, 2023

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.

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • April 19, 2023

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.

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

Sure @sd79  I Hope that helps!!

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • May 30, 2023

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.

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

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

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • September 11, 2023

Hi @Naveen Boga 

 

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

 

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

@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.

Translate

Forum|alt.badge.img
  • Author
  • Freshman II
  • September 12, 2023

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

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

@sd79  Oh, okay. Thanks for the clarification.

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

Translate