The GL Preload Commitment Report allows the values generated from the Payroll Projection Run to be reviewed. The Preload report is shown as three sections. The first portion shows the details per GL. The second portion is a GL summary and the third portion list a summary by pay code, storage bank code and deduction code. These values would all related to the range of GL's selected for the report.
This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The CSV file is generated in the work directory of the payroll, pointed to by the logical SRB$OPSWRK. The CSV file can be opened directly in Excel or emailed from the Email process on the main menu.
The export file includes the following fields:
-
GL Code
-
GL Description
-
Employee Number
-
Employee Name Code Type
-
Pay Code
-
Pay Code Description
-
Deduction Code
-
Deduction Code Description
-
Bank Code
-
Bank Code Description
-
Position when applicable
-
Committed Hours
-
Committed Amount
Enter Start G/L Account
-
Enter the first GL to be reported on to start at the first GL found.
Enter End G/L Account
-
Enter the ending GL for a range of GL's to include all following GL's.
Report Full or Summary Only
-
Enter 'F' f to produce all three phases of the projection report.
-
Enter 'S' to only produce the GL summary and summary by pay and deduction code. This option will bypass the printing of the cost break down per employee.
When 'F'ull report was selected:
Suppress Zero Details
-
Enter 'Y' to suppress printing of detail entries with zero hours and earnings.
-
Enter 'N' to print all detail entries.
The GL Level Sort is only available when the Finance location profile, field 4 in the GL Account Format, has been defined.
Summary Sort by GL or GL Level
-
Enter 'G' to have the GL summary report sorted by the full GL code.
-
Enter 'L' to have the GL summary report sorted and subtotaled based on a specific GL level.
Select GL Level to Sort On
The levels of your GL account will be displayed.
-
Enter the GL level use for sorting and subtotaling on the GL summary report.
When 'F'ull report was selected:
Suppress Zero Details
-
Enter 'Y' to suppress printing of detail entries with zero hours and earnings.
-
Enter 'N' to print all detail entries.
Include Generation of CSV Export File
-
Enter 'N' to omit the generation of the export file.
-
Enter 'Y' to include the generation of the export file.
The report lists the following:
-
GL number, employee number and employee name
-
The code followed by a P, B, or D meanings Pay, Bank, or Deduction Code
-
Position code when applicable
-
The committed hours calculated for the range of periods
-
The committed amount calculated for the range of period
The second portion of the report lists:
-
The GL number and a total of committed hours and committed amount for that GL.
The third portion of the report lists:
-
The code type header (pay, bank or deduction)
-
The code followed by the code description
-
The total committed hours applied to that code
-
The total committed amount applied to that code