Purchase Ledger
The Purchase Ledger report is a summary of your account position with each Supplier. Together with the
Periodic Supplier Statement report, it is a very useful tool for payment scheduling purposes. You can limit the selection to a specified period or to a certain Supplier. The type of Purchase Invoice shown can also be specified.
In its basic form, the report shows Supplier Name and Telephone Number and, for each Purchase Invoice, the amount outstanding, the Due Date or Discount Date and the age or number of days overdue. However, it can be reformatted in many different ways, and you can specify any selection you want, as described below. Invoices whose Hold box has been checked are marked with an asterisk (*).
When printed to screen, the Overview option of this report has FirstOffice's Drill-down feature. Click on any Purchase Invoice Number to open an individual Purchase Invoice record.
- Supplier
- Paste Special
Suppliers in Customer register
- Range Reporting Alpha
- To limit the report to a single Supplier (or range of Suppliers), enter the Supplier Number here.
- Category
- Paste Special
Supplier Categories setting, Purchase Ledger
- If you want to restrict the report to Suppliers of a particular Category, specify that Category here.
- Date
- Enter a date to show the status of the Purchase Ledger on that date. If the field is left blank, the current date will be used.
- Function
- Use these options to control the level of detail shown in the report.
- Detailed
- This option produces a report listing for each open Invoice any Payments, Credits and Payments on account.
- Overview
- This option is a summary showing an outstanding balance, due date and age for each open Purchase Invoice.
- Aged
- This gives a report showing the balances payable to each Supplier, broken down into ageing periods. The age groups are defined in the Age Limits setting in the Sales Ledger module.
- Balance
- This option simply prints the total balance payable to each Supplier.
- Status
- Use these options to determine which Purchase Invoices are included in the report.
- Open
- When this option is selected the report will contain all unpaid Purchase Invoices.
- Due
- When this option is selected the report is limited to those Invoices that are due for payment.
- Sorting
- The report can be sorted by Supplier Number or Name.
- Include Prel. Book
- Use this check box to include Purchase Invoices marked as preliminary in the report.