Recurring invoice creation
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
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.
|
Criteria
| All companies (field ALLCPY) |
Enter the company code for which the processing has been started.
The company code:
- must necessarily refer to a legal entity,
- must necessarily be entered if the box "All companies" is not checked.
This field specifies on which legislation the process is carried out. It can only be accessed if the box "All companies" is selected.
Note: If the company code is entered (All companies unselected), the Legislation field can not be accessed and displays the legislation parameters for the selected company.
Select this check box to include all sites. To run this process for a single site, leave clear.
Enter the site code for which the processing has been started.
It is mandatory to enter this field if the box "All sites" is not checked.
Select this check box to include all users. To run this process for a single user group, leave clear.
The current user will be used if the user/group code is blank.
User responsible for the creation of the open items.
Select this check box to include all types. To run this process for a single type, leave clear.
Enter the invoice type to use to generate the invoices.
If this box is selected, the processing is launched for all suppliers/customers (otherwise, they have to be specified).
This field indicates the code identifying the BP.
If this box is selected, the processing is launched for all the recurring invoices (otherwise, they have to be specified).
Enter the recurring invoice record to use to generate the invoices.
Generation
| Simulation (field SIM) |
|
Select this box to skip the invoice creation process. Unselect it to create the invoices. Select this box to view a list of the recurring invoices that can be generated on the date entered in the 'Invoice up to' field. |
| Log file (field TRC) |
|
Select this box to view a log file of all invoices that have been generated (or would have been generated, in Simulation mode). If the Simulation box is selected, the 'Log file' box is automatically selected and grayed out. |
Block number 4
| Invoices until (field INVDAT) |
|
Enter the date that will determine if recurring invoices will be generated. According to the recurrence pattern, several invoices can be generated for a specific recurrence. |
| Accounting date (field ACCDAT) |
|
Enter the accounting date of all generated invoices. |
Specific Buttons
|
Recall |
Click this action to enter a Memo code to load the settings associated with the code. |
|
Delete memo |
Click this action to delete a Memo code. |
Error messages
The only error messages are the generic ones.
Tables used
Refer to documentation Implementation