TIP: For help locating the layout sections mentioned in the steps below you can view our guide.

Edit your Reverse Charge message

If you have previously deleted the RevChargeMssge variable, you can add the code below as an expression.

1. Click Invoices and Credits, then select an invoice.
2. Click Print, then select the layout you want to change.
3. Click Edit to open Report Designer.
4. In the INVOICE_NUMBER Header section, double click the RevChargeMssge variable.
   
   
   
   TIP: If you've previously deleted the RevChargeMssge variable, to add it as an expression click Toolbox, click Add Expression then click in the INVOICE_NUMBER Header section.
   
   
5. In the Expression editor, click Clear, then paste in the below expression:
   
   sum(TAX_CODE.IS_REVERSECHARGE <> 0 ? INVOICE_ITEM.net_AMOUNT : 0.0) > 0.00 ? "* Indicates REVERSE CHARGE SUPPLY - Customer to pay VAT to HMRC" : sum(TAX_CODE.IS_REVERSECHARGE <> 0 ? INVOICE_ITEM.net_AMOUNT : 0.0) < 0.00 ? "* Indicates REVERSE CHARGE SUPPLY - Customer to reclaim VAT to HMRC" : " "
   
   
6. Click OK.

---

Edit your service charge text

1. In the Details section, double click the Service_Text.
   
   TIP: You may need to move overlapping variables to access the service text variable.  You can do this by selecting the variable and dragging it to the side.
   
   
2. In the Expression editor, click Clear.
3. Copy the expression below, then paste it into the Expression Editor.
   
   INVOICE_ITEM.GENERATED_MESSAGE = 1 AND (INVOICE_ITEM.DESCRIPTION LIKE "REVERSE CHARGE%" OR INVOICE_ITEM.DESCRIPTION LIKE "Customer to pay output tax of %" OR INVOICE_ITEM.DESCRIPTION LIKE "Customer to account for output tax of %") ? INVOICE_ITEM.DESCRIPTION : INVOICE_ITEM.TEXT
   
   
4. Click OK.
5. Single click the Service_Text.
6. In the Properties pane, click Conditional Formatting then click the finder button .
   
   
   
   If you can't see the properties pane, click View, then click Properties.
   
   
7. In the Filter tab, click Edit, then click Advanced Filter, then click Clear
8. Copy the expression below, then paste it into the Expression Editor, replacing the current expression.
   
   INVOICE_ITEM.DESCRIPTION LIKE "*REVERSE CHARGE %" OR INVOICE_ITEM.DESCRIPTION LIKE "Customer to pay output tax of %" OR INVOICE_ITEM.DESCRIPTION LIKE "Customer to account for output tax of %"
   
   
9. Click OK, then click Properties.
10. Click the drop down arrow next to Text Style, then click Bold, then click on the drop down next to False and change to True.
11. Click OK.

---

Edit your description variable

1. In the ITEM_NUMBER footer section, single click the variable being used for the description. For example DESCRIPTION.
2. In the Properties pane, click Conditional Formatting then click the finder button .
   
   
   
   
3. In the Filter tab, click Edit,then click Advanced Filter, then click Clear.
4. Copy the expression below, then paste it into the Expression Editor, replacing the current expression:
   
   INVOICE_ITEM.DESCRIPTION LIKE "* REVERSE CHARGE %" OR INVOICE_ITEM.DESCRIPTION LIKE "Customer to pay output tax of %" OR INVOICE_ITEM.DESCRIPTION LIKE "Customer to account for output tax of %"
   
   
5. Click OK, then click Properties.
6. Change the Suppress Printing selection to True.
7. Click OK.
8. Save your changes.

Once you've added or amended your report filter you should save the changes to your document.