S1, S2, S3 and message lines do not appear on printed layouts
Description

There may be times when S1, S2, S3 and message lines don't appear on your layouts.

To resolve this you must edit the layout, change the Join and if required, change the despatch note filter.

Cause
Resolution

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.

  1. Select the document you want to amend, then click Edit.
  2. Click Report, then click Joins.
  3. Select the join between the INVOICE_ITEM and STOCK tables.
  4. Set the Join Type and Conditional Join Type to Parent Outer.
  5. Click OK.
  6. On the menu bar click File, then click Save As.
  7. Enter a new file name then click Save.
  8. 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.

  1. Select the despatch note layout you want to amend, then click Edit.
  2. Click Report, then click Filter. If a Modify Filter window appears, click Use Advanced Filter.
  3. 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"

  4. Click OK.
  5. On the menu bar click File, then click Save As.
  6. Enter a new file name then click Save.
  7. On the menu bar click File, then click Exit.

 TIP: Ensure no additional cells are copied over as may cause issues. 

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




Steps to duplicate
Related Solutions