Report Designer - invoice and credit note sections
Description

When you edit a Sage 50 Accounts invoice or credit note in Report Designer, the document is split into several sections. These sections contain filters which determine when they print.

Every item on a layout is placed in one of the sections and this affects its position on the page, whether or not it appears at all, and how many times it shows on a page when you generate the layout.

Example invoice layout

The image below is an example of the standard Invoice layout.  It is split into different sections.


Section guide

SectionDescriptionFilter
1. INVOICE_NUMBER HeaderShows the main invoice header details, for example, the customer's name and address, the invoice number, the invoice date, order number and the column headings for the items. By default, the Invoice Number header section prints on every page.None
2. INVOICE_NUMBER headerThis section only appears when printing proformas and quotations. It contains a note to say the document isn't a VAT invoice.INVOICE.INVOICE_TYPE_CODE >= 5
3. ITEM_NUMBER header

By default, this section doesn't print.

If required, you can use it to show service item and S3 product descriptions. To do this, change the section filter to:

INVOICE_ITEM.DESCRIPTION NOT LIKE "" AND INVOICE_ITEM.SERVICE_FLAG <> 0

False
4. Details

This section is used for service item lines.

It shows the main text for each item on a service invoice, and the details of S3 codes on a product invoice. It also shows the service item prices.

INVOICE_ITEM.SERVICE_FLAG <> 0
5. ITEM_NUMBER footer

This section is used for stock and non-stock item lines, including S1 and S2 product codes.

It shows the item quantities, descriptions and prices.

INVOICE_ITEM.SERVICE_FLAG = 0
6. ITEM_NUMBER footer

This section is used for stock and non-stock item lines, including S1 and S2 product codes.

It shows the information in the Comment 1 field for each item. If Comment 1 is blank, the section is suppressed.

INVOICE_ITEM.SERVICE_FLAG = 0 AND INVOICE_ITEM.COMMENT_1 <> ""
7. ITEM_NUMBER footer

This section is used for stock and non-stock item lines, including S1 and S2 product codes.

It shows the information in the Comment 2 field for each item. If Comment 2 is blank, the section is suppressed.

 INVOICE_ITEM.SERVICE_FLAG = 0 AND INVOICE_ITEM.COMMENT_2 <> ""
8. INVOICE_ITEM.​ITEM_NUMBER Footer

This section only appears on the EC VAT Description invoice layouts.

It shows the EC VAT Description entered in the item line of the invoice and only prints if the item line has an EC sales tax code.

TAX_CODE.EURO_SALES != 0
9. INVOICE.​INVOICE_NUMBER Footer

This section shows the description, % and value of any net value discount on this invoice.

If no net net value discount is entered, this section is suppressed. The Net Value Discount feature isn't available in Sage Instant Accounts.

INVOICE.NET_VALUE_​DISCOUNT_NET <> 0
10. INVOICE.​INVOICE_NUMBER Footer

Shows information entered in the Comment 1 box in the Net Value Discount section of the invoice.

If no net net value discount or comment 1 is entered, this section is suppressed. The Net Value Discount feature isn't available in Sage Instant Accounts.

INVOICE.NET_VALUE_​DISCOUNT_NET <> 0 and INVOICE.NET_VALUE_​DISCOUNT_COMMENT_1 Not Like ""
11. INVOICE.​INVOICE_NUMBER Footer

Shows information entered in the Comment 1 box in the Net Value Discount section of the invoice.

If no net net value discount or comment 1 is entered, this section is suppressed. The Net Value Discount feature isn't available in Sage Instant Accounts.

INVOICE.NET_VALUE_​DISCOUNT_NET <> 0 and INVOICE.NET_VALUE_​DISCOUNT_COMMENT_2 Not Like ""
12. INVOICE_NUMBER footer

This section shows any prepayment made and the amount remaining to pay.

If there's no prepayment on the invoice, this section is suppressed.

INVOICE.​FOREIGN_AMOUNT_PREPAID <> 0
13. INVOICE_NUMBER Footer

Shows the main invoice footer details, for example, the net, VAT and gross totals, carriage and delivery addresses.

By default, the Invoice Number header section prints at the end of each invoice.

None
 


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