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.
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