Skip to main content
Solved

Amount In Words for Trillion Number


Forum|alt.badge.img
  • Freshman II
  • 28 replies

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
Did this topic help you find an answer to your question?

11 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • April 18, 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/


Forum|alt.badge.img+10
  • Semi-Pro III
  • 229 replies
  • 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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 28 replies
  • April 19, 2023
sweta68 wrote:

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.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 28 replies
  • April 19, 2023
Naveen Boga wrote:

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.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • April 19, 2023

Sure @sd79  I Hope that helps!!


Forum|alt.badge.img
  • Author
  • Freshman II
  • 28 replies
  • 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.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • May 30, 2023

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 28 replies
  • 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

 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • September 11, 2023

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 28 replies
  • 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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • September 12, 2023

@sd79  Oh, okay. Thanks for the clarification.

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings