JERollover
If your application uses journal entries, use this Longview Application Framework function as part of a period-end or year-end rollover.
At the end of a period or year, you can use the application to transfer values to the new time period.
- The period-end rollover occurs at the end of each period.
- The year-end rollover occurs at the end of each fiscal year.
To prepare for a rollover, you need to use the JERollover function. For a period-end rollover, JERollover:
- changes the current period to the next period (uses the SGPCurrentPeriod system attribute)
- duplicates all recurring journal entries for the current period and marks them as Validated
For a year-end rollover, JERollover:
- changes the current period to the first period of the next year (uses the SGPCurrentPeriod system attribute)
- changes the current year to the next year (uses the SGPCurrentYear system attribute)
- duplicates all recurring journal entries for the current period and marks them as Validated
For more information on attributes, see the Longview Application Administrator Guide.
Before using this function, you must ensure that Longview Journal Entries is not open on the desktop and that all journal entries have been posted.
The period-end and year-end rollover are exclusive from each other. If the current period-end is also a year-end, you cannot perform a period-end rollover.
Syntax
SET VARIABLE VarName = JEROLLOVER ("RollPeriod", "ExecuteMode")
where:
RollPeriod can be one of the following:
Value Description PERIODEND
To specify a period-end rollover.
YEAREND
To specify a year-end rollover.
- ExecuteMode can be one of the following:
Value Description FALSE
This is the default setting and specifies that the rollover runs in test mode. You do not need to turn maintenance on to run a rollover test.
TRUE
This setting specifies that the rollover runs in execute mode. To use this mode, you must turn maintenance on.
The application creates a code in the active worksheet to indicate the results of the rollover:
| Value | Description |
|---|---|
0 | Rollover was successful. |
3 | Rollover failed because the user is not authorized to perform a journal entry rollover. A user requires authorization to create current period journal entries and modify system attributes to perform a journal entry rollover. |
2 | Rollover failed because there were outstanding or unposted journal entries for the current period. |
1 | Period-end rollover failed because the current period requires a year-end rollover. |
-1 | Rollover failed for some other reason. |
Syntax example
CREATE VARIABLE jeRollStatus AS NUM
MAINTENANCE ON
SET VARIABLE jeRollStatus = JERollover("YEAREND", "TRUE")
MAINTENANCE OFF