Wiki: RPGLX

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.

Notes #

Click to create a new notes page