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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article