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

From AutoCount Resource Center
Jump to navigation Jump to search

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?

Rd decimal1.png


Rd decimal2.png


Answer :

1) Go to Report > Design Document Style Report

Rd decimal3.png


2) Select the report and click on Design

Rd decimal4.png


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.

Rd decimal5.png


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

Rd decimal6.png

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.

Rd decimal7.png


By : Ashikin 181112, Lay Swan 181213, P181214



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations