Language:


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.