This function is used to generate invoices from recurring invoice records. It is possible to generate automatically an invoice or a group of invoices according to the selection criteria. With this function you can:

  • Automatically generate invoices from a recurring invoice recording.
  • Produce customer invoices as well as supplier invoices.
  • Run the generation in Simulation mode to see which recurring invoices qualify for generation as of the entered 'Invoice up to' date.
  • Set a recurring record to Completed after the end date has been reached, or when all recurrences have been generated.
  • Generate a log file indicating the invoices that were created and the recurring invoice record that was used to create the invoices.

The status of the recurring invoice must be In Process to create invoices.

Prerequisites

See also Refer to documentation Implementation

Screen management

Recurring invoice creation

Example 1:
This invoice is to be generated weekly on Fridays for the month of June starting 6/01/13 and ending 6/30/13. This pattern should generate invoices for 6/7, 6/14, 6/21, and 6/28.

  • The first iteration is run with an 'invoice up to' date of 6/10 and an accounting date of 6/11. After the generation is executed, there will be one invoice (Inv1) generated with an accounting date of 6/11 and a recurrence date of 6/7.
  • The second iteration is run with an invoice up to date of 6/17 and an accounting date of 6/18. After the generation is executed, there will be one invoice (Inv2) generated with an accounting date of 6/18 and a recurrence date of 6/14.

1. If the user decides to run the generation with an 'invoice up to' date <= 6/14, no invoice will be generated.
2. If the user decides to delete Inv1, keep Inv2, and then decides to run the generation with an 'invoice up to' date <= 6/14, no invoice will be generated.
3. If the user decides to delete Inv2, keep Inv1, and then decides to run the generation with an 'invoice up to' date of 6/14, there will be one invoice generated with a recurrence date of 6/14.
4. If the user decides to delete Inv1, delete Inv2, and then decides to run the generation with an 'invoice up to date' of 6/14, there will be two invoices generated with a recurrence date of 6/7 and 6/14.

Example 2:
It is considered that the week begins on Mondays and ends on Sundays. The reference invoice is considered to be the first recurring invoice. For example:

  • Weekday = Friday,
  • Weekly interval = 1,
  • Accounting date of the reference invoice = Monday,

The next invoice will be generated Friday of the next week.

Example 3:
To enter the day in which the monthly invoice will be generated, the Day of the month field and the Month interval field are used to determine the actual recurrence. For example:

  • Day of the month = 15,
  • Monthly interval = 1,
  • Accounting date of the reference invoice = January, 1st,

The next generated invoice falls on February 15.

Entry screen

Recurring

Invoice type (field RCRTYP)

Select the desired option for invoice generation.

  • Supplier: Invoices are generated only for suppliers.
  • Customer: Invoices are generated only for customers.

Criteria

Select this checkbox to include all companies. To run this process for a single company, do not select this checkbox.

All companies (field ALLCPY)