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 9:02 AM by Cheng Kah Poh

Scenario 

Example:

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:

 

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article