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

Reverse From

Fiscal Year

Use this drop-down list to select the fiscal year for which you want to reverse cost pools or revenue. Once you have made your selection, the Fiscal Year in the Post To group box will display the same fiscal year and cannot be edited.

Period

Use this drop-down list to select the period for which you want to reverse cost pools or revenue.

Subperiod

Use this drop-down list to select the subperiod for which you want to reverse cost pools or revenue.

Journal to Reverse

Use this group box to indicate whether you want to reverse a pool journal or a revenue journal. You can click only one option.

Post Sequence to Reverse

Enter, or use to select, the post sequence number of the selected journal you want to reverse. You can enter up to 10 characters.

The post sequence numbers available in are based on the selected Reverse From fiscal year/period/subperiod.  You can select only one post sequence number each time you execute the utility.

Post To

Fiscal Year

This non-editable field displays the fiscal year you selected in the Reverse From group box.

Period

Use this drop-down list to select the period to which you want to post the cost pools or revenue.

Subperiod

Use this drop-down list to select the subperiod to which you want to post the cost pools or revenue.

Select Project

Use this group box to select the projects for which you want to reverse revenue journals. This group box is available only if you have clicked the Revenue Journal option.

Range Option

Enter or select the range of projects to include. Valid options are:

• All

• One

• Range

• From Beginning

• To End

From

Enter, or use to select, the starting project to include. If you select All or From Beginning in the Range Option field, this field will be inactive.

To

Enter, or use to select, the ending project to include. If you select All, One, or To End in the Range Option field, this field will be inactive.

Print Reversals

Click this icon on the toolbar 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 Journals

This icon on the toolbar will be available only if you have printed the report without errors. Click this icon to initiate the reversal process.

Print/Reverse Journals

Click this icon on the toolbar 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 will 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 (Maintain Allocation Journal) table. Since only Allocation Group 1 will post 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 will be posted.

• The system will perform a validation to ensure that there are no rows in ALLOC_BASIS_JNL (Maintain Allocation Journal) for the selected Post To fiscal year, period/subperiod or earlier periods/subperiods.  If rows exist, the application will generate an error message indicating that those rows must be posted before the utility can continue.

• The system will perform a validation on the accounts/orgs to ensure that they are linked and are within the period of performance of the Post To 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 (Maintain Allocation Journal), the application will generate an error report indicating any account/org/(project) errors. This error report will be produced from validations done on Z_PJPPREV_POOL.   Once you print an error report that returns no errors, the Reverse Journals button on the toolbar will be available and the reverse pool journal will be inserted into the ALLOC_BASIS_JNL (Maintain Allocation Journal). To complete the reversal, you must post the pool journal for the reversed pool. 

• The source for the reverse pool journal will be the ALLOC_BASIS_JNL_HS.  The POOL_SIE_SUPPORT table will be 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 JEs) 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 will be posted.  You cannot edit a journal entry created by reversing the revenue journal.

• The system will perform a validation on the project/accounts/orgs for the Post To fiscal year/period/subperiod.  The application will generate an error report indicating any account/org/project errors. This error report will be produced from validations done on Z_PJPPREV_REV. Once you have printed an error-free report, the Reverse Journals button on the toolbar will be available and the reverse revenue journal will be inserted into the JE_HDR and JE_TRN (Enter JEs) tables with a transaction description of REVERSE REVENUE JOURNAL. To complete the reversal, you must post the journal entry.

Table Information

Changes to this screen update the following tables:

ALLOC_BASIS_JNL

JE_HDR

JE_TRN