Skip to main content
Solved

How to Spelled int data in report acumatica ?


yanuaralfianus37
Jr Varsity II

hai, anyone know how to spelled int data in report acumatica ?

example:

i have int data in [SOOrder.CuryOrderTotal], i want to spell that number like one hundred fifty two dollar and that would be show in report.

Best answer by Naveen Boga

@yanuaralfianus37  Okay. I understood other way round. 

For this requirement hoping that below article will help you.

http://blog.acumatica.com.sg/2017/09/amount-to-words-conversion-at-acumatica.html

View original
Did this topic help you find an answer to your question?

9 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • August 23, 2021

Hi @yanuaralfianus37 Actually “[SOOrder.CuryOrderTotal]” is a Decimal type of field but NOT integer type.

Please provide Decimal and verify


yanuaralfianus37
Jr Varsity II

Hi @Naveen B thanks for reply, yeah that is true, [SOOrder.CuryOrderTotal] is a decimal type, im sorry if im wrong. Btw do you knowhow to spelled int or decimal type in report acumatica ? thanks.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • August 23, 2021

Hi @yanuaralfianus37  For the decimal type, you can give “Float”, please find the screenshot for reference.

 


yanuaralfianus37
Jr Varsity II

Hi @Naveen B thanks for reply, im sorry if im not good to explain my problem. my problem isn’t about parameter in report but logic in report acumatica. my problem is how to make logic to spelled number.

example: i have field with value “100”, i want to get data in report to this “One Hundred”.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • Answer
  • August 24, 2021

@yanuaralfianus37  Okay. I understood other way round. 

For this requirement hoping that below article will help you.

http://blog.acumatica.com.sg/2017/09/amount-to-words-conversion-at-acumatica.html


yanuaralfianus37
Jr Varsity II

@Naveen B thanks for the article, that is very helpful!


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • August 24, 2021

Great :) Thanks for sharing an update.


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 100 replies
  • August 24, 2021

@yanuaralfianus37 , @Naveen B , I received this attachment from Acumatica Support regarding a different issue. 
It describes creating a User Defined Function to print the Sales Order Amount in words.

*This is a nonstandard customization & requires some programming skills. 

 


yanuaralfianus37
Jr Varsity II

Hi @wfilipiak67 Thanks for sharing, this is very helpful because I have many references to improvisation logic for my problems 🙂.


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