The Open entries (supplier) report shows the open — that is, not yet settled — purchase invoice entries for a supplier as of a selected date. It gives a quick overview of what you owe a specific supplier, and how much of each amount is still outstanding.
The entries are grouped per source and per supplier, and each entry shows, among other things, the supplier's voucher/invoice number, the supplier's own invoice number, the supplier itself, fiscal date, due date and the original amount and the remaining amount. At the bottom, the amounts are totaled, so you can see the total open balance.
The report is suited for reviewing the account with a single supplier — for example before a payment, during reconciliation or when you want to see which invoices remain unsettled as of a specific cut-off date.
The report is started from within the supplier card in Financial: go to Actors, select Suppliers, open (edit) the desired supplier, and select the report in the report selector on the supplier's edit page. Because the report is opened from a specific supplier card, the supplier is already selected, and the report shows the entries for exactly this supplier.
The report is available both as a PDF report and in an Excel variant, so you can choose the format that suits whether you want to print/share the report or work further with the figures in a spreadsheet.
When you open the report, you can adjust the following fields before it is generated.
Limits the report to one or more organizational units. If you leave the field empty, the entries across the units you have access to are included.
Specifies the cut-off date the entries are calculated by. The report shows the entries that are open (unsettled) as of this date. If you choose a date back in time, you see the picture as it appeared then.
In addition to these two fields, the system itself sets a number of technical details — among other things which supplier the report applies to, the current organizational unit and the current user. These fields are hidden and are filled in automatically based on the supplier card and the user you work from, so you normally do not need to deal with them.
Want to know more?
Read more in these related articles:
Open entries (purchase invoice)
The print shows open (unpaid) purchase invoices as of the date.
Accounts payable balance
The report shows what the company owes its suppliers as of a selected fiscal date, aged across due-date intervals.
