Templates - Purchase Invoice (Table Based)

Open Excel, select the Access tab.

Click Templates, Setup Update Template. The Choose your data connection page appears.
​Note: With AOI v5.14.9 or earlier just click Setup Update Template.

Check the Data Connection field shows the required database, if not, use the drop-down to select the required database. Click Next.

Expand Purchase Ledger and select Purchase Invoices (Table Based). Click Next.

Drag Supplier Code from Available Fields into Column Fields.

Select the Supplier Code and click Set Range. A box will appear Choose Column range for Supplier Code.

In Excel, select a cell and then drag down to create a small column, e.g. cells B3 to B10.

In the Choose Column range for Supplier Code window, click the red down arrow icon. The Cell Range appears on the template and the remaining available fields become active.

Drag the other fields required, like Trans Reference, Date, Do Not Batch, Net Value, Description, VAT Amount and Transaction User Key 2 into the column fields box in the order required. Click Next. The Choose your template settings page appears.

Enable changes to be written back to Access Accounts is ticked by default and cannot be changed. Leave the colours as the default. The Add column totals and Add row totals do not work with this template.

To save the template, select the Save Template check box and add the name required. This name will then appear in the Existing Templates drop-down on the first page of the setup wizard.

Click Insert. The template is simply column headers.