REPORT PAYROLL JOURNAL ENTRIES#
This report has been deprecated as of the 5.04 release. It has been replaced by RPGLP (.pdf output) and RPGLX (.xlsx output).
Processing Information#
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.
On the report there may be entries for Fiscal Total and Fiscal Net Total.Fiscal Total is the total includes all movement of money with all DR and CR entries
- contains the totals for each DR and CR columns from the Account Subtotal of all distribution codes
- within the same Distribution code, there may be some DR entries and some CR entries
- the 'Account Subtotal' are the total of all movement of money within that Distribution code
- the 'Account Total' shows the Total DR + Total CR for that distribution code
- this 'Account Total' is the actual money that should affect that distribution code
Fiscal Net Total is the total for the fiscal period by journal type, after DR + CR. This amount contains the ‘Account Total’ totals from all distribution codes.
Report Parameters & Filters#
| 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. |
| 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. |
| Report Filters | |
|---|---|
| Pay Run Number | Optional, LOV Available This field limits the report to the Pay Run Number(s) specified. |
| From Execution ID | Optional, LOV Available This is the Execution ID from the General Ledger Update (UPGLPTR /UPGLPPL / UPLG / UPGL). |
| Journal Type | Optional, LOV Available The journal type may be Financial or Statistical. |
| Journal Source | Optional, LOV Available This field limits the report to the journal source specified. 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. |
| Test Person | Optional, LOV Available You may specify one or more employees to be printed on the RPGL report. This feature is usually used for testing. |
