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

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

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
11 26-Nov-2021 10:22 3 KB Karen Parrott to previous
10 26-Nov-2021 10:22 3 KB Karen Parrott to previous | to last
9 26-Nov-2021 10:22 3 KB Karen Parrott to previous | to last
8 26-Nov-2021 10:22 2 KB Meg McFarland to previous | to last
7 26-Nov-2021 10:22 2 KB Meg McFarland to previous | to last
6 26-Nov-2021 10:22 2 KB Meg McFarland to previous | to last
5 26-Nov-2021 10:22 2 KB Meg McFarland to previous | to last
4 26-Nov-2021 10:22 2 KB Meg McFarland to previous | to last
3 26-Nov-2021 10:22 2 KB khiggs to previous | to last
2 26-Nov-2021 10:22 2 KB khiggs to previous | to last
1 26-Nov-2021 10:22 2 KB khiggs to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 3 changed 2 lines
The Payroll G/L Distribution Report (RPGLW) report will print a list of payroll G/L distribution. This function generates the report as an Excel spreadsheet. This report has been deprecated as of the 5.04 release. It has been replaced by [RPGLP] (.pdf output) and [RPGLX] (.xlsx output).
\\ \\
The Payroll G/L Distribution Report (RPGLX) prints a list of payroll G/L distributions. This function generates the report as an Excel spreadsheet. This is one of 2 options available to replace the now deprecated RPGLW report (RPGLP is the other option).
!!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.
%%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.%%
\\
At line 6 changed 5 lines
|G/L Company Code|Mandatory,LOV Available\\This field allows you to select a G/L company for the report.
|Entity|Optional,LOV Available\\This field allows you to chose the entity for which the report is being printed.
|Payroll|Optional,LOV Available\\This field allows you to chose the entity for which the report is being printed.
|From/Up To Fiscal Period|Optional, LOV Available\\These fields indicate the fiscal period represented in the report.
|From/To Pay Issue Date|Optional,Date, LOV Available\\These fields indicate the dates represented in the report.
|G/L Company Code|Mandatory, LOV Available\\Limits the report to the defined G/L company code.
|Entity|Optional, LOV Available\\Limits the report to the defined the entity.
|Payroll|Optional, LOV Available\\Limits the report to the defined the payroll.
|From Fiscal Period|Optional, LOV Available\\Limits the report to the defined start date of the fiscal period.
|Up to Fiscal Period|Optional, LOV Available\\Limits the report to the defined end date of the fiscal period.
|From Pay Issue Date|Optional,Date, LOV Available\\Limits the report to the defined Pay Issue start date.
|To Pay Issue Date|Optional,Date, LOV Available\\Limits the report to the defined Pay Issue end date.
|From Execution ID|Optional, LOV Available\\An Execution ID of an updated GL Interface run that generates Journal Entries to the General Ledger system.
At line 13 changed 3 lines
|Print in Detail|Optional,[Yes or No|X_YES_NO], Lexicon available\\If <Yes> then the journal entry details will be displayed on the report, otherwise no details will display on the report.
|Exception Level|Optional,[Trace Level|X_TRACE_LEVEL], Lexicon available.\\This field defines the exception level (report messages) required.
|User Comment|Optional, Text\\This field holds the user-supplied comment which will appear in the header of all pages of the report.
|Print in Detail|Optional,[Yes or No|X_YES_NO], Lexicon available\\When set to YES, the journal entry details are displayed on the report, otherwise no details are displayed.
|Exception Level|Optional,[Trace Level|X_TRACE_LEVEL], Lexicon available.\\Defines the exception level (report messages) required.
|User Comment|Optional, Text\\Users can add a comment that will appear in the header of all pages of the report.
At line 18 changed 6 lines
|Pay Run Number|Optional, Multiple selection and LOV available\\This field limits the report to the specified pay run numbers.
|From Execution ID|Optional, Multiple selection and LOV available\\This field allows you to select an Execution ID of a Payroll GL run or a Labor GL run that generates GL Journal Entries in the Payroll system.
|Journal Type|Optional,[Journal Type|X_JOURNAL_TYPE], Multiple selection and LOV available\\This field limits the report to the specified journal types.
|Journal Source|Optional,[Journal Source|X_JOURNAL_SOURCE],Multiple selection and LOV available\\This field limits the report to the specified journal sources.
|Person|Optional, Multiple selection and LOV available\\This field limits the report to the specified people.
|Pay Number|Optional, Multiple selection and LOV available\\Limits the report to the defined pay numbers. The pay number is the unique number assigned to each pay header that is created for an employee.
|Pay Run Number|Optional, Multiple selection and LOV available\\Limits the report to the defined pay run numbers.
|Journal Source|Optional,[Journal Source|X_JOURNAL_SOURCE],Multiple selection and LOV available\\Limits the report to the defined journal source(s).
|Journal Type|Optional,[Journal Type|X_JOURNAL_TYPE], Multiple selection and LOV available\\Limits the report to the defined journal type(s).
|Person|Optional, Multiple selection and LOV available\\Limits the report to the defined people.