Solved

Notification Template : Display only two decimal places

  • 1 December 2020
  • 6 replies
  • 125 views

Userlevel 4
Badge +1

Hello,

Could you please help me, how to display only 2 decimals for below highlighted feilds in default notification templates.

 

icon

Best answer by Irina 2 December 2020, 14:51

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:

 

View original

6 replies

Userlevel 4
Badge +1

Can anyone help me with this query, please..

Userlevel 6
Badge +2

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:

 

Userlevel 4
Badge +1

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

 

Userlevel 6
Badge +2

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 :wink:

Userlevel 4
Badge +1

@Irina  hahah Sure :grinning: . Voted for the above idea. 
 

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.

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved