PAYROLL G/L DISTRIBUTION REPORT#
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 (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. |
