This page (revision-6) was last changed on 26-Nov-2021 10:22 by Karen Parrott

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
6 26-Nov-2021 10:22 4 KB Karen Parrott to previous
5 26-Nov-2021 10:22 4 KB JMyers to previous | to last
4 26-Nov-2021 10:22 3 KB JEscott to previous | to last
3 26-Nov-2021 10:22 3 KB JEscott to previous | to last
2 26-Nov-2021 10:22 3 KB JEscott to previous | to last
1 26-Nov-2021 10:22 3 KB JEscott to last

Page References

Incoming links Outgoing links
RPGL
RPGL

Version management

Difference between version and

At line 2 added 4 lines
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
At line 12 added 15 lines
%%information 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
At line 9 changed 16 lines
|__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.
|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.
----
![Notes|Edit:Internal.RPGL]
[{InsertPage page='Internal.RPGL' default='Click to create a new notes page'}]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by Karen ParrottTop