Hello,
Could you please help me, how to display only 2 decimals for below highlighted feilds in default notification templates.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3ec386fb-4b9e-4862-8035-69aca296527c.png)
Hello,
Could you please help me, how to display only 2 decimals for below highlighted feilds in default notification templates.
It is not possible to do in Notification Templates itself as they do not support formulas with which you could modify that. We had a product suggestion for this:
As a workaround, you can build custom generic inquiry and expose values you need to use in the notification template in Results Grid, and re-use this GI in your template.
Also you will need to add a table with the field having decimal precision you need. For example, I have 4 presicion for invoices Amount.
I’m finding some field in my system which has preciosion 2, for example, Ordred Qty on sales order:
To Invoices and Memos GI, I’m adding PX.Objects.SO.SOOrder table, without any relations.
On the Results Grid tab, for the Amount row, which should have decimal precision 2, I’m setting Schema to the SOOrder.OrderQty field (which has decimal precision 2):
And receiving the result as follows:
Hi
Thanks a lot for the reply and for providing the workaround solution.
This will be a big change for us, will see the feasibility and take it forward.
This was reported as an enhancement to our platform here
By the way, it is really very easy to create a template the way it was suggested in my previous comment. Do not be afraid of customization flexibility of Acumatica ERP
I had same issue, I had to create a very long Switch formula converting the value to a String, then formatting based upon Length and sub string. It took me 2 hours to write and test.
Very poor design. I voted twice for the suggestion.
Hello, Thank you for sharing with us.
I’d like to add my findings.
1, I set the schema filed to “salesorder.orderqty” in the GI for my field. However it does NOT make any difference, it still display more than 2 decimals.
2, The “Round” function can help me achieve my need.
3,After you have set functions on the “field”, you have to manually update your Notification template.
The same field with or without functions are different to email template.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.