Skip to main content
Answer

How to Spelled int data in report acumatica ?

  • August 23, 2021
  • 9 replies
  • 146 views

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

9 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 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
  • 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
  • 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
  • August 24, 2021

Great :) Thanks for sharing an update.


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 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 🙂.