REVERSE POSTED POOL AND REVENUE JOURNALS
Use this utility to reverse posted pool journals and posted revenue journals. Pools compute the amount to post based on the account balances in the general ledger. In addition, the amount of revenue to post is also based on the account balances in the general ledger. Because of this, you cannot use this utility to cross fiscal years. The Reverse From fiscal year must be the same as the Post To fiscal year.
You cannot modify a reverse revenue journal entry, but you can delete it.
Use this utility whenever you need to reverse any cost pools and revenue that you have posted.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. 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 run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Period to Reverse
Option
This field always displays One.
Fiscal Year
Enter, or click 
to select, the fiscal year for which you want to reverse cost pools or revenue. After you have made your selection, the Fiscal Year in the Period to Post group box displays the same fiscal year and cannot be modified.
Period
Enter, or click to select, the period for which you want to reverse cost pools or revenue.
Subperiod
Enter, or click to select, the subperiod for which you want to reverse cost pools or revenue.
Ending Date
This non-editable field displays the selected subperiod end date.
Period to Post
Fiscal Year
This non-editable field displays the fiscal year you selected in the Period to Reverse group box.
Period
Enter, or click to select, the period to which you want to post the cost pools or revenue.
Subperiod
Enter, or click to select, the subperiod to which you want to post the cost pools or revenue.
Projects
Use this group box to select the projects for which you want to reverse revenue journals. This group box is available only if you selected the Revenue Journal option in the Journal Types drop-down list.
Option
Enter or select the range of projects to include. Valid options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
Start
Enter, or click to select, the starting project to include. If you select All or From Beginning in the Option field, this field is inactive.
End
Enter, or click to select, the ending project to include. If you select All, One, or To End in the Option field, this field is inactive.
Options
Journal Types
Use this drop-down list to indicate whether you want to reverse a pool journal or a revenue journal.
Post Sequence No
Enter, or click to select, the post sequence number of the selected journal you want to reverse.
The post sequence numbers available in are based on the selected Period to Reverse fiscal year/period/subperiod. You can select only one post sequence number each time you execute the utility.
Print Reversals
Click 
to print the Reverse Pool Journal or Reverse Revenue Journal. When you click this icon, the application copies the reversal data into a temporary table (Z_PJPPREV_POOL or Z_PJPPREV_REV) and prints the appropriate report. If there are errors on the report, you must correct them before you can continue with the reversal. If the report contains warnings, you can still continue.
Reverse Posted Pool and Revenue Journals
Click the arrow to the right of 
and make a selection from the drop-down list. Valid options are:
-
Reverse Posted Pool and Revenue Journals — Select this option to initiate the reversal process. This option available only if you have printed the report without errors.
-
Print and Reverse Posted Pool and Revenue Journals — Select this option to print the report and initiate the reversal process. The application copies the reversal data into a temporary table (Z_PJPPREV_POOL or Z_PJPPREV_REV) and prints the appropriate report. Then the application begins the reversal process. If errors show on the report, the reversal process does not take place. If this happens, you must correct the errors before continuing.
Processing
Reverse Posted Pool Journal
-
The Reverse Posted Pool Journal utility checks the GL_POST_SUM table to get the post sequence number selected and joins that sequence number to ALLOC_BASIS_JNL_HS and gets the rows to insert into the ALLOC_BASIS_JNL (Manage Allocation Journals) table. Since only Allocation Group 1 posts to the General Ledger, only Allocation Group 1 can be reversed.
-
The entry edit status of PAJ must be open for the Fiscal Year/Period/Subperiod to which the reversal is posted.
-
Costpoint performs a validation to ensure that there are no rows in ALLOC_BASIS_JNL (Manage Allocation Journals) for the selected Period to Post fiscal year, period/subperiod, or earlier periods/subperiods. If rows exist, the application generates an error message indicating that those rows must be posted before the utility can continue.
-
Costpoint performs a validation on the accounts/orgs to ensure that they are linked and are within the period of performance of the Period to Post fiscal year/period/subperiod. If the account is project-required, as in the case of a service center, the account/project must be valid. Before rows can be inserted into the ALLOC_BASIS_JNL (Manage Allocation Journals) table, the application generates an error report indicating any account/org/(project) errors. This error report is produced from validations done on Z_PJPPREV_POOL. After you print an error report that returns no errors, is available and the reverse pool journal is inserted into the ALLOC_BASIS_JNL (Manage Allocation Journals) table. To complete the reversal, you must post the pool journal for the reversed pool.
-
The source for the reverse pool journal is the ALLOC_BASIS_JNL_HS. The POOL_SIE_SUPPORT table is unaffected.
Reverse Revenue Journal
-
The Reverse Revenue Journal utility checks the GL_POST_SUM to get the selected post sequence number and uses the GL_POST_SUM and GL_DETL table to produce the reversal. This reversal is inserted into the JE_HDR and JE_TRN (Enter Journal Entries) tables with a transaction description of REVERSE REVENUE JOURNAL.
-
The entry edit status of AJE must be open for the fiscal year/period/subperiod to which the reversal is posted. You cannot modify a journal entry created by reversing the revenue journal.
-
Costpoint performs a validation on the project/accounts/orgs for the Period to Post fiscal year/period/subperiod. The application generates an error report indicating any account/org/project errors. This error report is produced from validations done on Z_PJPPREV_REV. After you print an error-free report, is available and the reverse revenue journal is inserted into the JE_HDR and JE_TRN (Enter Journal Entries) tables with a transaction description of REVERSE REVENUE JOURNAL. To complete the reversal, you must post the journal entry.