Skip to main content

Attaché Accounts: Set up and manage supplier recurring schedules

Learn how to create, view, and delete recurring schedules for suppliers to control how often invoices and payments are generated.

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

  1. Navigate to Transactions, Suppliers, Recurring Schedules, Enquire.

  2. 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

  1. Navigate to Transactions, Suppliers, Recurring Schedules, Maintain.

  2. 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.

  • If Due Date Options – Cal on Every Invoice is set to No in Supplier Options, the software applies the terms from the supplier masterfile to calculate the due date. If no terms are specified in the supplier masterfile, the default terms in Due Date Options in Supplier Options are applied.

  • If Due Date Options – Cal on Every Invoice is set to Yes in Supplier Options, the software uses the values in Due Date Options to calculate the due date, regardless of the supplier masterfile.

🤓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:

  • S = Standing PO Cost – Prices, discounts, and tax codes are taken from the source standing purchase order.

  • L = Last Cost – Prices, discounts, and tax codes are taken from the product masterfile.

📌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

  1. Navigate to Transactions, Suppliers, Recurring Schedules, Delete.

  2. Use this option to delete a supplier recurring schedule that is no longer required.

Did this answer your question?