Change the join type
TIP: The INVOICE_ITEM table is used in this example, to follow this procedure on a Sales or Purchase Order replace this table with SOP_ITEM or POP_ITEM respectively.
- Select the document you want to amend, then click Edit.
- Click Report, then click Joins.
- Select the join between the INVOICE_ITEM and STOCK tables.
- Set the Join Type and Conditional Join Type to Parent Outer.
- Click OK.
- On the menu bar click File, then click Save As.
- Enter a new file name then click Save.
- On the menu bar click File, then click Exit.
Edit the despatch note to print message lines
By default, despatch notes only print item lines that have an amount being despatched. To show message lines you must change this filter.
- Select the despatch note layout you want to amend, then click Edit.
- Click Report, then click Filter. If a Modify Filter window appears, click Use Advanced Filter.
- Click Clear, then enter the following filter:
(SOP_ITEM.QTY_DESPATCH <> 0 AND LETTER_TYPE.LETTER_TYPE = 7) OR SOP_ITEM.STOCK_CODE LIKE "M"
- Click OK.
- On the menu bar click File, then click Save As.
- Enter a new file name then click Save.
- On the menu bar click File, then click Exit.