!!!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|X_YES_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|X_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|X_JOURNAL_TYPE], Multiple selection and LOV available\\This field limits the report to the specified journal types. |Journal Source|Optional,[Journal Source|X_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|Edit:Internal.RPGLWP_DB] [{InsertPage page='Internal.RPGLW_DB' default='Click to create a new notes page'}]