How to Customize Transaction report text format string to show 0.00 or -

Overview:

This guide is designed to assist users in handling the “Unit Price” and “Amount” fields in reports. When these fields are left empty, they may appear as blank, which can affect the clarity and analysis of the report. To address this issue, this guide provides methods for ensuring that these fields display a default value (such as 0.00 or “-”) instead of remaining blank when no data is provided. This approach enhances the readability of the report and prevents issues caused by missing data. 

Scenario:

Solution:

Step 1 - Learn How to Access Report Designer.

Step 2 - After Access to the Sales invoice report design, Press the Unit Price Field, User will notice the 'Text Format String' field.

Step 3 - User can either add 0.00, or add - , in between "" .

Before

After add 0.00

or After add -

Step 3 - Please follow Step 2, proceed at Amount column

Step 4 - Press Menu Button.

Step 5 - Press Save.

Step 6 - Result

Step 7 - Learn How to Default a format.

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software