Accounts payable list

In this procedure you see a list of paid and partially paid supplier invoices. Unpaid invoices that have been ordered for payment at the bank are also displayed. They disappear from the list when they are confirmed from the bank.

Invoices that are fully paid can also be included in the list by checking a box under the Selection tab.

In the list, you can reconcile the accounts payable against the balance for accounts payable (i.e. supplier debts) and preliminary accounts payable in the general ledger. It is possible to perform age analysis by viewing age distribution in the accounts payable. You can also post invoices and payments.

The data in the procedure is based on information from the accounts payable (invoices and payments) with links to suppliers, postings, and vouchers.

The Function menu

By using the Print/Send invoice documents button you can "mass print" images of supplier invoices for many invoices at the same time. You can in this dialog choose if correspondence with the supplier should be included, see how many invoices will be printed/exported, and you can choose if you want to Print, Send by e-mail, or Save as PDF (export to folder).

Ledger – Detailed/Total

This list type displays a detailed/total list of invoices with remaining amounts per a certain ledger date. For on account payments you can edit the supplier’s invoice number.

Payments

This list type shows a detailed list containing invoices and their payment records.

Age analysis – Detailed/Total

This list type shows an age distributed accounts payable list, detailed or total. The list is based on age intervals of Invoice dates or Due dates. An age analysis based on due date shows how the invoices will become overdue according to different time intervals. An age analysis based on invoice dates shows when you registered the invoices according to different time intervals.

Reconciliation

This list type is used to reconcile the balance in the accounts payable with the balance in the general ledger.

Reconciliation/day

This list type is used to reconcile the accounts payable with general ledger transactions on day level.

Bookkeeping

This list type is used to see how invoices and payments have been recorded.

Move voucher date

This list is used if the accounting period is closed/locked and you need to move supplier invoices which have not yet been final recorded, to the new accounting period.

Balance per supplier

This list shows the ledger balance per supplier using a layout that is similar to the general ledger reports. For each supplier you see the period's balance brought forward, transactions (register supplier invoices and payments) and closing balance.

The presentations determine how the selected list should be displayed/presented. For example if it should be presented as grouped or as total. There are some standard presentations included in the program.

In most procedures where you can load lists, it is possible to create your own presentations. This is done under Presentations in the backstage of the procedure in question. If you create your own presentation you can for example choose if it should have a drilldown function and a drilldown filterering.

You can select which columns the list should consist of, and for each of the columns you can configure grouping, sorting, aggregation, and if the column should be shown in chart form and if it should be printed. Additionally you can also make printout settings, chart settings, and settings regarding extra aggregation.

Read more about this in Presentations.

In a list procedure there is always a tab called Selection where you can select data records in different intervals from the database. The data records are then loaded by using the Load button in the toolbar of the procedure.

Under Selection rows in the backstage of the procedure, you can choose which selection rows that each list type should have, under the Selection tab in the procedure. In the List type field you select for which list type you want to customize the selection rows.

One table shows selection rows possible to select and one one table shows the selected selection rows. You can add, delete, or move selection rows by dragging and dropping the selection rows with your mouse pointer.

Using the Save button you save the selected selection rows.

Read more about this in the Selection topic.