How to Configure the Quantity and Pricing Decimal in Customized Sales Invoice Format

Overview:

Configuring decimal places for quantity and pricing in reports ensures accurate and consistent data presentation based on business needs. 

Scenario:

1. Access Report format you wanted to configure the decimal display.

   1. Go to Reporting > Report Designer

2. Filter Report Types to Sales Invoice

3. Click on Design to modify the Customized Sales Invoice format.

2. Modify the Qty Decimal

   1. At the selected Report Designer view, click on the [Qty] cell to select the field.

2. At the Properties on the right, at the Text Format String, replace the field according to how many decimal points you want the system to display.

3. Please refer to the samples below, keep adding ‘0’ (Zeros) based on your requirements.

3. Modify the Pricing Decimal

   1. At the selected Report Designer view, click [UnitPrice] cell to select the field.

2. Unit Price will display in 2 decimal places by default.

3. To amend, at the Properties on the right, at the Text Format String, replace the field according to how many decimal points you want the system to display.

Keep adding ‘0’ (Zeros) based on your requirements.