Skip to main content
Question

How to format the qty value to exclude the decimal point in Email Template

  • May 29, 2024
  • 3 replies
  • 122 views

Forum|alt.badge.img

Hi All, 

Is there a way to format the quantity to exclude the decimal point in the email template?
for example instead of 1.00 should be presented as 1. 
 

Appreciate any help on this. 

Thank you. 

3 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • May 29, 2024

Hello,

I have one idea that may help.  Can you try once the conversion functions shown here?

 

I think CInt will remove decimals.

Here is one more idea, a programming code snippet that I found here using Google, for converting to Integer:

Laura


Forum|alt.badge.img
  • Author
  • Freshman I
  • May 29, 2024

Hi Laura, 

Thank you for your response. 

I have included the CInt in the email template as below. But when I process the email, the qty did not appear on the email. 
Did I missed something?

 

Thank you. 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • July 10, 2024

Hi @ASamson21 were you able to find a solution? Thank you!