This is version 1 2 3 4 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

PAYROLL G/L DISTRIBUTION REPORT#

NOTE - This report is no long supported. It has been replaced with the RPGLW and the RPGLX

The Payroll G/L Distribution Report (RPGLW_DB) report will print a list of payroll G/L distribution. This function generates the report as an Excel spreadsheet.

This function RPGLW_DB has been created using direct DB instead of HL custom data source. The Excel report (RPGLW_DB.xlsx) splits the Fiscal periods but now reports them on the same Financial tab with the totals at the end of this tab.

Report Parameters
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.
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 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, 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.

Report Filters
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, Multiple selection and LOV available This field limits the report to the specified journal types.
Journal Source	Optional,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.

---

Notes #

Click to create a new notes page