This report gives you an overview of the purchase invoices that are still open (not fully paid) on a specific date. For each invoice you can see the supplier, the supplier's invoice number/reference, the due date and the original amount and the remaining amount that still remains to be paid. At the bottom, both the total amount and the total remaining amount are summed, so you can quickly see your total debt to the suppliers as of the selected date.
The report is typically used to follow up on supplier payments — for example at month-end, for payment planning or for reconciling creditors. You can choose to have the list grouped and sorted either per invoice or per supplier, depending on whether you want to work by invoice or gather all open entries under each supplier.
The report is opened in Financial via the report selector. It is available both under the supplier reports (Suppliers) and in the accounting report menu. Select the Open entries (purchase invoice) report, fill in the desired parameters and run the print.
When you start the report, you can set the following parameters, which limit and control the print.
The date the outstanding amount is calculated on. The report shows the purchase invoices that were open (unpaid) as of this date. If you leave the date empty, no limit by date is applied.
Selects which type of entries are included. The default value is Purchase invoice, but you can also choose All or Invoice, so you decide which basis the outstanding amount is calculated on yourself.
Limits the list to a single organizational unit. If you leave the field empty, all the organizational units you have access to are included.
Limits the print to one specific supplier by entering the supplier number. If the field is empty, open entries for all suppliers are shown.
Determines both the grouping and the sorting of the result. If you choose Invoice, the entries are listed per invoice number; if you choose Supplier, the entries are gathered and sorted per supplier number. This is a mandatory parameter, and the default selection is invoice sorting.
The report is available in a PDF variant for printing and viewing on screen.
Want to know more?
Read more in these related articles:
Open entries (supplier)
Report of open, unsettled purchase invoice entries for a supplier as of a selected date — started from the supplier card in Financial.
Purchase invoices
Complete guide to Purchase invoices in Financial: list view, creation, the document editor with all header fields, line grid, toolbar actions, the Lines/Attachments/Supplier history tabs and the state flow from draft to paid.
