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 are not 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, please refer to article .

  1. On the navigation bar click Invoices and credits, Sales orders or Purchase orders as required.
  2. Select an invoice or order then click Print and select the layout you want to amend then click Edit.
  3. On the menu bar click Report then click Report Properties and enter a new name and description for the document then click OK.
  4. In the first ITEM_NUMBER Footer section below the Details section, select the variables for the values you want to suppress.

    This section may also be called ITEM_NUMBER footer 3.
  5. 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"
  6. Click OK once, then click the Properties tab and for Suppress Printing choose True then click OK.

  7. Click File then click Save As and enter a new file name then click Save.

 

[BCB:19:UK - Sales message :ECB]

 

Steps to duplicate
Related Solutions