CREATE RECURRING JEs

Use this screen to create the recurring Journal Entries (JEs) to be posted. You can select recurring JEs to be created based on the JE cycle, a range of JE numbers, and a range of user IDs.

Use this screen whenever you need to create recurring journal entries to be posted in one or more subperiods. The original recurring journal entries must first have been entered in the Enter JEs screen and posted. Those original recurring entries then become the templates that are used by this program to create the future recurring entries.

Select Cycle

Cycle

From the drop-down box, select the JE cycle for which you want to create recurring JEs. The JE cycles must already have been set up in the JE Cycles screen.

Select Journal Entries

Use the selections in this group box to specify the recurring JEs to be created in the specified subperiods.

Range Option

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

From/To

Enter the starting and/or ending recurring JE numbers for the range of recurring JEs you want to create. One or both of these fields may be disabled, depending on your Range Option selection.

Select User ID

Use this group box to select the ID(s) for the user(s) whose entries should be created. The user ID information was stored when the recurring journal entries were entered or changed in the Enter JEs screen.

Range Option

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

From/To

Enter the starting and/or ending user ID(s) for the user(s) whose recurring JEs you need to create. One or both of these fields may be disabled, depending on your Range Option selection.

Select Destination Subperiods

In this group box, select the fiscal year, period, and subperiod(s) for which recurring JEs will be generated.

Range Option

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

Starting Fiscal Year, Period, Subperiod, Ending Subperiod

Enter the starting fiscal year, period, and subperiod for the range of subperiods in which you need to create recurring JEs. Enter the ending subperiod, if applicable, for the range of subperiods in which you need to create recurring JEs. One or more of these fields may be disabled, depending on your Range Option selection. The subperiod ending date(s) for the selected subperiod(s) will be displayed.

Select Reversal Subperiod

In this group box, you can select the fiscal year, period, and subperiod in which to reverse any recurring JEs marked as "Reversing" in the Enter JEs screen. These drop-down boxes are optional. If you do enter data in these fields, the fiscal year, period, and subperiod entered cannot be earlier than, or the same subperiod as, the subperiod in which the recurring JE will be created.

If you leave these fields empty and the system finds a reversing recurring JE, it will automatically assign the reversal to the next fiscal year/period/subperiod linked to that JE cycle. If there is no future subperiod linked to the JE cycle, you will receive an error message, and the creation process will not proceed.

Note that this process assigns the reversal subperiod for the recurring JE. The Post JEs process actually creates the reversal JE. After the recurring JE is created in this screen, you can edit its reversal subperiod in the Enter JEs screen.

Fiscal Year

Enter the fiscal year in which to reverse any reversing recurring JEs created by this program. The fiscal years available in the drop-down box come from the Fiscal Year table. This is an optional field.

Period

Enter the period in which to reverse any reversing recurring JEs created by this program. The periods shown in the drop-down box come from the Accounting Period table. This is an optional field.

Subperiod

Enter the subperiod in which to reverse any reversing recurring JEs created. The subperiods shown in the drop-down box are taken from the Subperiod table. This is an optional field.

Create Recurring JE

Once you have made your selections, use this button on the toolbar 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. You will receive 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 is made to see if 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 JEs screen. Once the original entry has been posted, it becomes the template from which you will create all future iterations of that recurring entry. Running the Create Recurring JEs program actually creates the new recurring JEs from the original "template" entry.