Language:


Overview of Instalments

Purchase Invoices will be payable in instalments if they have Payment Terms that are connected to records in the Instalments setting. This report lists the unpaid instalments owed by your company. Paid instalments are not shown.

Period
Paste Special    Reporting Periods setting, System module
Enter the report period. The first row of the Reporting Periods setting is used as default. Instalments that become due in the report period will be shown.

Supplier
Paste Special    Suppliers in Contact register
Enter a Supplier Number here to list the instalments owed to that Supplier.

Supplier Category
Paste Special    Supplier Categories setting, Purchase Ledger
Range Reporting    Alpha
If you want the report to list outstanding Purchase Invoices received from Suppliers belonging to a particular Supplier Category, specify that Category here.

You can also enter a range of Supplier Categories separated by a colon (:). Note however that the field will only accept five characters so you may prefer to specify the range using only the first characters (e.g. "A:M").

Supplier Class.
Paste Special    Contact Classifications setting, CRM module
Enter a Classification Code in this field if you want to list instalments owed to Suppliers with a certain Classification. If you leave the field blank, instalments owed to all Suppliers, with and without Classification, will be included. If you enter a number of Classifications separated by commas, only instalments owed to those Suppliers featuring all the Classifications listed will be included. If you enter a number of Classifications separated by plus signs (+), instalments owed to all Suppliers featuring at least one of the Classifications listed will be included. If you enter a Classification preceded by an exclamation mark (!), instalments owed to all Suppliers featuring any Classification except the one listed will be included.

For example:
1,2
Lists instalments owed to Suppliers with Classifications 1 and 2 (including instalments owed to Suppliers with Classifications 1, 2 and 3).

1+2
Lists instalments owed to Suppliers with Classifications 1 or 2.

!2
Lists instalments owed to all Suppliers except those with Classification 2.

1,!2
Lists instalments owed to Suppliers with Classification 1 but excludes those to Suppliers with Classification 2 (i.e. instalments owed to Suppliers with Classifications 1 and 2 are not shown). Note the comma before the exclamation mark in this example.

!1,!2
Lists instalments owed to all Suppliers except those with Classification 1 or 2 or both. Again, note the comma.

!(1,2)
Lists instalments owed to all Suppliers except those with Classifications 1 and 2 (instalments owed to Suppliers with Classifications 1, 2 and 3 will not be listed).

!1+2
Lists instalments owed to Suppliers without Classification 1 and to those with Classification 2 (instalments owed to Suppliers with Classifications 1 and 2 will be listed).

(1,2)+(3,4)
Lists instalments owed to Suppliers with Classifications 1 and 2, and to those with Classifications 3 and 4.

1*
Lists instalments owed to Suppliers with Classifications beginning with 1 (e.g. 1, 10, 100).

1*,!1
Lists instalments owed to Suppliers with Classifications beginning with 1 but not 1 itself.

*1
Lists instalments owed to Suppliers with Classifications ending with 1 (e.g. 1, 01, 001).

1*,*1
Lists instalments owed to Suppliers with Classifications beginning and ending with 1.
Currency
Paste Special    Currency register, System module
Enter a Currency here to list the instalments owed on Invoices that were received in that Currency.

Values in Currency
This option will add an extra column to the report, showing the Currency of each instalment (i.e. the Currency of each originating Purchase Invoice). Instalment amounts will also be displayed in Currency (if you do not select this option, all instalment amounts will be displayed in your home Currency i.e. Base Currency 1).

Sorting
The report can be sorted by Invoice Number, Due Date or by Supplier. In the last case, the instalments for each Supplier can be sorted by Invoice Number or Due Date.
---

Reports in the Purchase Ledger:

Go back to: