Create Additional Footer Lines

You can create as many line definitions as required for each line type (data line, footer). The different line definitions are shown in the object dialog as a tree structure.

For our example, now create two more footers for the VAT and the grand total.

Figure 2.61: Preview 3 footers

1.  To add more lines in the object dialog, first select an existing line definition. You can then create a new line definition with the "Append line definition" button.

Figure 2.62: Object dialog with 3 columns

Alternatively, you can add a new line in the workspace via the context menu or with the mini toolbar.

2.  A dialog will appear asking you whether you want to use an existing line definition. It saves some time if you use the footer that you have already created as you will not have to configure the left margin, alignment or background colors. Therefore, choose the "Line definition 1" entry from the "Footer" area.

3.  The line will now be inserted. Click the "Subtotal" field so that you can then change the content to "VAT 19%" with the formula wizard. Don't forget to enclose the text in quotation marks.

4.  Once you have created the column, click in the column to enter the aggregation. Instead of the total net amount, the 19% VAT is to be output here. Therefore, you simply multiply the amount by 0.19.

Sum(Item.Quantity * Item.UnitPrice * 0.19)

5.  Proceed in the same way with the third footer. Copy the existing footer, change the content and, in the formula, add the VAT to the total, like this:

Sum(Item.Quantity * Item.UnitPrice * 1.19)

6.  You have now defined the first footer and the invoice looks like this:

Figure 2.63: Invoice with 3 footers