Skip to main content
Solved

How to Spelled int data in report acumatica ?

  • Aug 23, 2021 4:54 AM UTC
  • 9 replies
  • 194 views
  • Translate All

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

9 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Aug 23, 2021 6:36 AM UTC

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

Please provide Decimal and verify

Translate

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.

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Aug 23, 2021 9:33 AM UTC

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

 

Translate

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

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Answer
  • Aug 24, 2021 7:41 AM UTC

@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

Translate

yanuaralfianus37
Jr Varsity II

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

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Aug 24, 2021 3:42 PM UTC

Great :) Thanks for sharing an update.

Translate

wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • Aug 24, 2021 10:47 PM UTC

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

 

Translate

yanuaralfianus37
Jr Varsity II

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

Translate