Report Design: How to set the decimals point for Unit Price in report design

Question : I set the Sales unit price with 3 decimals point but I want the unit price print in Invoice with 2 decimals point only. How to set it?

Version : 1.8 / 1.9 / 2.0

Answer :

1) Go to Report > Design Document Style Report

2) Select the report and click on Design

3) Please find the field of xrUnitPrice and click on the small box to go into Label Tasks and change the Data Binding from SG_UnitPrice to Unit Price.

4) In the Label Tasks, click on Format String, select Number and select for n2 and click on OK.

Note : If the field name starts with SG such as SG_UnitPrice means that this field is system generated for document style report control option. It does not support any format string.

5) Save as new report and now it shows only 2 decimals for unit price when preview.

By : Ashikin 181112, Lay Swan 181213, P181214

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations