The supplier specification is a detailed account statement for a single supplier (creditor). The report shows all entries on the supplier in the selected period, sorted by fiscal date, thereby giving a complete overview of the account with the supplier.
For each entry you see voucher number, organizational unit, any alternative voucher number, purchase invoice, fiscal date, due date and the debit and credit amounts. Along the way, a running balance is calculated, so you can follow how the account develops at all times, and at the bottom a total amount is shown.
In addition to the entries themselves, the report contains an aging of the overdue amounts. The amounts are distributed into intervals by how long they have been overdue (under 30 days, 30-60 days, 60-90 days, 90-120 days and over 120 days), so you can quickly see where the debt or receivable is oldest.
The report header also shows your own company and the selected organizational unit.
The supplier specification is started in Financial from the individual supplier card. Find the supplier under the suppliers, open the supplier for editing, and select the report via the report button/report selector on the supplier card. The report runs automatically for the supplier you have opened, so you do not have to select the supplier yourself.
The report is available as a PDF report. There is no separate Excel variant of this report.
When you start the report, you can narrow the content with the following parameters:
Limits the specification to a single organizational unit. If you leave the field empty, entries across the units you have access to are included.
Start date for the period the entries are pulled for. Entries with a fiscal date before this date are excluded.
End date for the period. Entries with a fiscal date after this date are excluded.
Includes only entries with a due date from and including this date. Used when you want to limit by due date rather than fiscal date.
Includes only entries with a due date up to and including this date.
Specifies whether unposted entries (draft entries) should be counted. By default the value is No, so only posted entries are included. Choose Yes if you also want draft entries included in the specification.
Want to know more?
Read more in these related articles:
Specification - Suppliers
Accounts payable statement across suppliers – shows an entry overview for the selected period.
Suppliers
How to use the supplier register and supplier card in Sapera: list view with filters and actions, create and edit a supplier, all tabs on the card (Entries, Purchase orders, Receipts, Purchase invoices, Stock archive, Notes, Attachments, Discounts, Sent emails, Actor info) as well as Supplier setup and SEO setup.