Create Recurring Journal Entries

Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters.  You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”  

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections.  Once the default selections display in the screen, you can override the defaults as necessary.

Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.

This non-editable field displays a value of "One."

Enter, or use Lookup to select, the JE cycle for which you want to create recurring JEs. You must have already set up the JE cycles in the Journal Entry Cycles screen.

From the drop-down box, select the range of recurring JEs you want to create. The available selections are "All," "One," "Range," "From Beginning," and "To End."

Enter, or use Lookup to select,  the starting recurring JE number for the range of recurring JEs you want to create. This field may be disabled, depending on the Option selected.

Enter, or use Lookup to select, the ending recurring JE number for the range of recurring JEs you want to create. This field may be disabled, depending on the Option selected.

From the drop-down box, select the range option for the user ID(s) whose entries you need to create. The available selections are "All," "One," "Range," "From Beginning," and "To End."

Enter, or use Lookup to select, the starting user ID for the user whose recurring JEs you need to create. This field may be disabled, depending on your Option selection.

Enter the ending user ID for the user whose recurring JE you need to create. This field may be disabled, depending on your Option selection.

From the drop-down box, select the range option for the subperiods for which you want to create recurring JEs. The available selections are "All," "One," "Range," "From Beginning," and "To End."

Enter, or use Lookup to select, the starting fiscal year for the range of subperiods in which you need to create recurring JEs.

Enter, or use Lookup to select, the starting period for the range of subperiods in which you need to create recurring JEs.  

Enter, or use Lookup to select, the starting subperiod for the range of subperiods in which you need to create recurring JEs. This field may be disabled, depending on the Option selected.

The starting destination subperiod date will display in the field to the right.

Enter the ending subperiod, if applicable, for the range of subperiods in which you need to create recurring JEs. This field may be disabled, depending on the Option selected.

The ending destination subperiod date will display in the field to the right.

This non-editable field displays a value of "One."

Enter, or use Lookup to select, the fiscal year in which to reverse any reversing recurring JEs created by this program.

The fiscal years available in Lookup come from the Fiscal Year table.

Enter the period in which to reverse any reversing recurring JEs created by this program. The periods shown in Lookup come from the Accounting Period table.

Enter the subperiod in which to reverse any reversing recurring JEs created. The subperiods shown in Lookup are taken from the Subperiod table.

Once you have made your selections, select the Action icon on the toolbar and choose this selection to create the recurring JEs.

The system will first verify that the same recurring JE number will not be created more than once in the selected accounting period. Similarly, the system will verify that the combination of the selected cycle and subperiod range will not create the same JE more than once. The system will display an error message if your selections fail either of these validations.

The system will also check to see that the subperiod selected is open for journal type "RJE" (Recurring Journal Entries). However, if the recurring journal entries selected will be reversing recurring entries, no check will be made to see whether the reversal subperiod is open.

Note:  The first time you need to create an entry that will be a recurring entry, enter it as a recurring entry in the Enter Journal Entries (Accounting\Transactions\Journal Entries) screen. Once the original entry has been posted, it becomes the template from which you will create all future iterations of that recurring entry. Use the Create Recurring Journal Entries program to create the new recurring Journal Entries from the original "template" entry.