PAYROLL G/L DISTRIBUTION REPORT#
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.
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 | |
|---|---|
| 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. |
| Posted Execution ID | Optional, LOV Available An Execution ID of an updated GL Interface run that generates Journal Entries to the General Ledger system. |
| Costed Execution ID | Optional, LOV Available An Execution ID of an updated GL Interface run that generates Journal Entries to the Financial Cost Module |
| Print in Detail | Optional,Yes or 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, 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. |
| Report Filters | |
|---|---|
| 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,Multiple selection and LOV available Limits the report to the defined journal source(s). |
| Journal Type | Optional,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. |
