Solved

# Amount In Words for Trillion Number

Userlevel 2
• Freshman II
• 27 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 ?

icon

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

View original

### 11 replies

Userlevel 7
+19

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

Userlevel 7
+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

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

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

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

Userlevel 7
+19

Sure @sd79  I Hope that helps!!

Userlevel 2

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.

Userlevel 7
+19

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

Userlevel 2

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
+19

@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

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.

Userlevel 7
+19

@sd79  Oh, okay. Thanks for the clarification.

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