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 CodeMandatory, LOV Available
Limits the report to the defined G/L company code.
EntityOptional, LOV Available
Limits the report to the defined the entity.
PayrollOptional, LOV Available
Limits the report to the defined the payroll.
From Fiscal PeriodOptional, LOV Available
Limits the report to the defined start date of the fiscal period.
Up to Fiscal PeriodOptional, LOV Available
Limits the report to the defined end date of the fiscal period.
From Pay Issue DateOptional,Date, LOV Available
Limits the report to the defined Pay Issue start date.
To Pay Issue DateOptional,Date, LOV Available
Limits the report to the defined Pay Issue end date.
From Execution IDOptional, LOV Available
An Execution ID of an updated GL Interface run that generates Journal Entries to the General Ledger system.
Posted Execution IDOptional, LOV Available
An Execution ID of an updated GL Interface run that generates Journal Entries to the General Ledger system.
Costed Execution IDOptional, LOV Available
An Execution ID of an updated GL Interface run that generates Journal Entries to the Financial Cost Module
Print in DetailOptional,Yes or No, Lexicon available
When set to YES, the journal entry details are displayed on the report, otherwise no details are displayed.
Exception LevelOptional,Trace Level, Lexicon available.
Defines the exception level (report messages) required.
User CommentOptional, Text
Users can add a comment that will appear in the header of all pages of the report.

Report Filters
Pay NumberOptional, 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 NumberOptional, Multiple selection and LOV available
Limits the report to the defined pay run numbers.
Journal SourceOptional,Journal Source,Multiple selection and LOV available
Limits the report to the defined journal source(s).
Journal TypeOptional,Journal Type, Multiple selection and LOV available
Limits the report to the defined journal type(s).
PersonOptional, Multiple selection and LOV available
Limits the report to the defined people.

Notes #

This report is now deprecated