How to customize Sales invoice format empty unit price to ‘wording’ [Free of charge]

Created by Cheng Kah Poh, Modified on Fri, 23 Oct 2020 at 09:02 AM by Cheng Kah Poh



In Standard format unit price will display blank, If user did not insert any of unit price. Maybe this 2 item are free of charge.

But it also can be customize as above picture, to know how to customize please check solution:



Step 1 – Open a sample invoice à Click Task.


Step 2 – Click Design.

Step 3 – Once Click Design , report  format list will appear, double click any of the invoice format.

Once double click to invoice format, please give a format display name and format code.

Any name and any code.

Step 4 – once go in to the format, Click on unit price, right click the unit price à Click Add calculated field.


Step 5 – once click Add Calculated field à a ‘calculated field 1’ will appear à Right Click it and Click edit calculated field 




Step 6 – insert a name, and expression please insert as below:

Iif(IsNullOrEmpty([Unit Price])||[Unit Price]=0,'Free of charge' ,[Unit Price] )

Click OK.

Then Click Save.





Last Check the result.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article