Error Report Designer - Using conditional formatting to stop values appearing against message lines on invoices and orders
Description
Cause
Resolution
If any of the panes mentioned in this section aren’t visible, open the View menu and select the required pane. If the pane doesn't appear, you can reset the Report Designer view to its default. For further information about this, refer to this article.
On the navigation bar click Invoices and credits, Sales orders or Purchase orders as required.
Select an invoice or order then click Print and select the layout you want to amend then click Edit.
On the menu bar, click Report then click Report Properties and enter a new name and description for the document then click OK.
In the first ITEM_NUMBER Footer section below the Details section, select the variables for the values you want to suppress.
This section is also be called ITEM_NUMBER footer 3.
In the Properties pane under Conditional Formatting, click the finder button then click Edit, if a Modify Filter window appears click Use Advanced Filter and enter the required filter as follows:
Layout type
Filter to add
Invoice
INVOICE_ITEM.DESCRIPTION LIKE "* REVERSE CHARGE %" OR INVOICE_ITEM.STOCK_CODE LIKE "M"
Sales Order
SOP_ITEM.STOCK_CODE LIKE "M"
Purchase Order
POP_ITEM.STOCK_CODE LIKE "M"
Click OK once, then click the Properties tab and for Suppress Printing choose True then click OK.
NOTE:
If the properties pane doesn’t show to go to View then Properties.
Click File then click Save As and enter a new file name then click Save.