This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

REPORT PAYROLL JOURNAL ENTRIES#

The Payroll Journal Entries Report (RPGL) should be run after the Labor and Payroll G/L Update, to verify the journal entries.

The Execution ID of the General Ledger Update (UPLG/UPGL) 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.

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 This field limits the report to the entity specified.
Payroll	Optional, LOV Available This field limits the report to the payroll specified.
Pay Run Number	Optional, LOV Available This field limits the report to the Pay Run Number(s) specified.
From Fiscal Period	Optional, LOV Available This field allows the report to print from the selected pay period (according to the IDCL setup).
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.
Posted Execution ID	Optional, LOV Available This is the Execution ID from a previously posted G/L Interface (UPGLF).
Costed Execution ID	Optional, LOV Available This is the Execution ID from the Financial Cost Control Interface.
Up to 10 Dist. Mask
Create RPGL File	Optional, Toggle If ON, RPGL will generate a comma delimited file that contains all journal entries printed. You may take this file to an Excel spreadsheet for auditing purpose and perform calculations or totalling. If OFF, RPGL will not create a file.
Directory Name	Optional, Text If Create RPGL file is ‘ON’ then a directory name is required. Must be a directory on the server for which the current user (as signed onto the client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the ‘TEMP’ directory on the server, not the local directory for the computer terminal being used.
RPGL File Name	Optional, Text If Create RPGL file is ‘ON’ then a file name is required. e.g. RPGL_mex.csv Where ‘mex’ is the current run MEX_ID and ‘.csv’ will automatically open the file with an Excel spreadsheet.
# of Records per File	Optional, Text When running a large number of journal entries, you may split them into multiple files each containing a defined number of records. You may define the number of records to be contained in each file here. The file names will be numbered in sequential order.
Trace Level	Optional, LOV Available You may specify the level of messages that the report should display. This field is used for troubleshooting purposes.