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

Summary

This occurs because the S1, S2, S3 or message lines don't have a stock record, therefore they do not appear on the layout in Sage 50 Accounts. Alternatively, message lines may not appear on a despatch note due to the filter applied.

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.

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. 

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Image




Solution Properties

Solution ID
200427112219389
Last Modified Date
Mon Jul 24 15:17:30 UTC 2023
Attributes
Product Details
Modules: Report Writer
Modules: Sales
Modules: Point of Sale
Views
0