Skip to main content
Solved

Amount In Words for Trillion Number

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 ?

 

 

11 replies

Naveen Boga
Rank
Userlevel 7
Badge +19

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/

Naveen B
S
Rank
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

S
Rank
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.

S
Rank
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.

Naveen Boga
Rank
Userlevel 7
Badge +19

Sure @sd79  I Hope that helps!!

Naveen B
S
Rank
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.

Naveen Boga
Rank
Userlevel 7
Badge +19

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

Naveen B
S
Rank
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

 

 

Naveen Boga
Rank
Userlevel 7
Badge +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.

Naveen B
S
Rank
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

Naveen Boga
Rank
Userlevel 7
Badge +19

@sd79  Oh, okay. Thanks for the clarification.

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

Naveen B

Reply


Terms & ConditionsCookie settings