Scenario
When preview Sales Invoices as below, the price of an item is zero instead of blank
Therefore, the requirement is to change the selling price from 0.00 into a blank column
Solution
- In navigation panel, Go to Sales module and Sales Invoices.
- Select one of the sales invoices with zero-priced item or create a new one.
- Go to Task and select Design
- System will bring you to reports page. Select the default report and click on Amend
- Then system will prompt as below, click Create
- System will create a user defined report and it is set as default.
- After creating, system will bring you to a new page, Report Designer
- Go to [Unit Price] and [Net]
- Click on the [Unit Price] and > box above
- Go to Format String in the Table Cell Tasks
- Edit the Format String from {0:n2} to {0:#,#0.00;;""}
- Repeat the Step 8-11 to do the same for [Net]
- Click on the Preview located below
- As you can see, the price with zero becomes blank
- Click on the icon or control + S to save the changes. Close the report designer.