Supplier recurring schedules allow you to control how often and how many times invoices or payments are generated for a supplier. Schedules can be based on start and stop dates, maximum invoice counts, or total amounts.
This article covers:
Viewing a recurring supplier schedule (Enquiry).
Creating and maintaining a recurring supplier schedule.
Deleting a recurring supplier schedule.
View a recurring supplier schedule
Navigate to Transactions, Suppliers, Recurring Schedules, Enquire.
The Recurring Supplier Schedule Enquiry screen displays the details set up in Recurring Supplier Schedule Maintenance.
🤓Tip: Use the toggle icon on the toolbar (or press Ctrl+E) to switch between enquiry and maintenance modes.
Create or maintain a recurring supplier schedule
Navigate to Transactions, Suppliers, Recurring Schedules, Maintain.
The supplier recurring schedule works with a supplier standing order to define the frequency, cost basis, and terms for recurring invoices.
📌Note: Schedule Reference and Standing PO Number are mandatory fields. The schedule reference and the next recurring document number are combined to create the supplier recurring invoice number. This number can be manually changed if required by selecting the Review Invoices Before Posting check box when generating recurring invoices.
Header fields
Field | Description |
Supplier Code | Identifies the supplier. This is an alphanumeric field of up to 8 characters. Note: 0 to 9 sorts before A to Z. |
Name | The supplier name is pre-filled from the details entered in Supplier Maintenance. |
Schedule Reference | Enter a unique reference code for the schedule. This code is used to identify and access the schedule. |
Description | Enter a corresponding description for this schedule. |
Standing PO Number | Choose Find (F2) to select a standing purchase order to associate with the recurring schedule. |
Inactive | Select this check box to mark this supplier recurring schedule as inactive. |
Options tab
Invoice Frequency
The Invoice Frequency area allows you to set when the invoice will be generated:
Option | Description |
On Demand | Select this for a recurring invoice you want to generate regularly without specifying a time schedule. You control when the invoice is generated by selecting Include On Demand Invoices in Generate Supplier Recurring Invoices. |
Weekly Based | Allows you to specify the number of weeks and the day or days of the week for invoice generation. For example: weekly on a Tuesday, fortnightly on a Monday, every third Wednesday. |
Monthly Date Based | Allows you to specify the day of the month and the number of months for invoice generation. For example: 1st of each month, quarterly on the 15th, every three months. |
Monthly Day Based | Allows you to select the first or last day or days in the month. For example: first Tuesday, last Friday of the month. |
Yearly Based | Allows you to select a date each year. For example: 21st September every year. |
Invoice Parameters
Field | Description |
Start Date | Select the start date of the recurring schedule. An invoice will not be generated if the date is before the Start Date. |
Stop Date | Select the stop date of the recurring schedule. An invoice will not be generated if the date is after the Stop Date. If no Stop Date is required, leave the default value of 31/12/2099. |
Maximum Number of Invoices | If required, specify the number of invoices to be produced for this schedule. If no maximum is required, leave the default value of 9999. |
Maximum Total Invoiced | If required, specify the total amount to be invoiced. When the Total Invoiced to Date (on the History tab) equals or exceeds this value, no further invoices will be generated. |
Invoice Details
Use the Invoice Details area to specify the terms for calculating the due date based on the invoice date.
Field | Description |
Normal Supplier Terms | Select this option to apply the terms defined in Supplier Options to the invoices.
🤓Tip: If required, you can manually change the due date later by selecting the Review Invoices Before Posting check box when generating the invoices. |
Number of Days | Alternatively, enter a number of days to calculate the due date based on the invoice date. This supersedes the Supplier Options settings for invoices in this schedule. 🤓Tip: If required, you can manually change the due date later by selecting the Review Invoices Before Posting check box when generating the invoices. |
Cost Basis | Select the Cost Basis for this schedule. This overrides the default buying price set up in Purchasing Options:
📌Note: Any special pricing that has been set up will override either of these selections. |
Invoice Category | Enter a category to apply to all invoices in this schedule. |
Invoice Layout | Select a predefined template for the invoices. |
Print Invoice | Select this to automatically print invoices on your system's default printer. |
Next Recurrence | The next recurrence date is automatically calculated based on your selections. |
Payment tab
Field | Description |
Pay Invoice in Full | Select this check box to pay the total amount of the invoice. |
Amount to Pay | If Pay Invoice in Full is not selected, enter the amount you wish to pay in this field. |
Override G/L Bank Account | Select this check box to set up a different bank account for the payment. |
G/L Bank Account | If Override G/L Bank Account is selected, choose Find (F2) to select the bank account. |
Create Remittance Advice | Select this check box to create a remittance advice for the payment amount. |
History tab
The History tab fields are display only and are updated each time an invoice is generated.
Field | Description |
Last Recurrence | The date the most recent invoice was generated. |
Number of Instalments Invoiced | The total number of invoices generated to date for this schedule. |
Total Invoiced to Date | The cumulative total amount invoiced for this schedule. |
Delete a recurring supplier schedule
Navigate to Transactions, Suppliers, Recurring Schedules, Delete.
Use this option to delete a supplier recurring schedule that is no longer required.
