Wiki: RPGE

REPORT JOURNAL ENTRIES BY EMPLOYEE#

The Journal Entries Report by Employee is an optional report that may be run after the Labor and Payroll G/L Update, to verify the journal entries by employee.

The Execution Id of the General Ledger Update is an important key to producing the report of the process.

Entering in the GL Company and the Execution Id from the UPGL run is all that is needed to execute this function.

Before running RPGE, you need to set up a user defined field in IMUF with the following specifications:

Table - P2K_CM_GL_ACCOUNTS
Name - PRINT ON RPGE
Lexicon - X_YES_NO

You must then set up IDGA to indicate that the G/L accounts are to be reported on RPGE.

Print on RPGE Y-Yes

Report Parameters
GL Company Code	Mandatory, LOV Available GL Company that the pays must be journalized for, as set up in the IDGC form.
Entity	Optional, LOV Available The field limits the process to the entity specified.
Payroll	Optional, LOV Available This field limits the process to the payroll specified.
Journal Source	Optional, LOV Available Journal Source indicates where the entries are originating from Labor G/L, Payroll G/L, Accrual G/L, Trial Labor G/L, Trial Payroll G/L, or Trial Accrual G/L. This field limits the process to the journal source specified.
Journal Type	Optional, LOV Available The Journal Type may be Financial or Statistical.
From Fiscal Period	Optional, LOV Available This field allows the report to print up to and including this fiscal period (according to the IDCL set up).
Up To Fiscal Period	Optional, LOV Available This field allows the report to print up to and including this fiscal period (according to the IDCL set up).
From Pay Issue Date	Optional, LOV Available This field allows the report to print from the selected pay issue date.
To Pay Issue Date	Optional, LOV Available This field allows the report to print up to and including the selected pay issue date.
From Execution ID	Optional, LOV Available This is the Execution ID from the Labor or Payroll General Ledger Update (UPLG or UPGL).
Print in Detail	Optional, Toggle This field allows you to indicate that within each account will be printed.
Column 1 Element	Optional, LOV Available Report can be run for specific elements that have been defined. If the element is not entered, then the DR amounts are printed.
Column 2 Element	Optional, LOV Available Report can be run for specific elements that have been defined. If the element is not entered, then the CR amounts are printed.
Test Person	Optional, LOV Available You may specify one or more employees for processing.
Up To 10 Dist. Mask
Trace Level	Optional, LOV Available You may specify the level of messages that the report should display. This field is used for troubleshooting purposes.