The Global GL Email Report generates individual GL reports per selected GL account level for one or all selected payroll IDs. The report allows for either a range of GL accounts or GL Selection Criteria to be defined and a unique range of pay periods per payroll ID selected. One report per GL account level is created with sorting within the GL account level based on payroll ID, pay period and then employee name. Subtotal per payroll ID and pay period are so included.
These individual GL reports are converted to a PDF format and emailed (when applicable) to the email address as defined under the General Ledger Account Dictionary definition per GL account level.
The individual GL reports are named SRB$OPSPDF:GGL_ccccc_###.LSTandSRB$OPSPDF:GGL_ccccc_###.PDF, where ccccc is the description of the GL account level selected (e.g.: Location), and ### is the numeric level value. The LST version of these files may be viewed using the LOOK utility.
Generating PDF reports under Payroll is controlled through the 'Report' record under the Global Email Profile per payroll ID code. Access to the Global Email Profile option is licensed per site. For details on purchasing that option please contact TSC. The Global Email Profile record controls when a payroll is enabled as well as the default settings and formatting parameters. Refer to the Global Email Profile documentation for details.
Email Selected Report Sections
-
Enter 'Y' to email the individual report sections based on the email address defined per select GL account level.
-
Enter 'N' to omit emailing the GL reports.
Reporting per Payroll ID
-
Enter one or multiple payroll ID's along with the pay periods and per payroll to be reported.
Enter GL Account Level for Report Selection
-
Enter the GL account level number for GL account selection. This GL account level will determine the individual report segregation.
Enter Code to be Reported for All
-
Leave this prompt empty to include all GL Levels for the range of GL accounts selected.
-
Enter a list of the GL account levels to be reported, separated by a comma. For the range of GL accounts selected, only those GL accounts with the selected GL level will be reported.
Selection by GL Criteria or GL Account Range
-
Enter 'C' to select a GL Criteria selection code to define the GL accounts to be included.
-
Enter 'G' to enter a range of GL accounts to be used for reporting.
When selection by a GL Criteria segment was chosen:
Enter GL Selection Criteria Code
-
Enter a predefined GL selection criteria code. Use look-up for access to all available GL criteria code definitions. For complete documentation on the use of GL selection criteria codes please refer to Appendix AK in the Finance manual. NOTE: Payroll does not utilize the Alias code, therefore GL selection criteria used in payroll should not include Alias code definitions.
When selection by a 'G'L range was chosen:
Enter Starting G/L Account
-
Enter the first GL number to be included on the report.
Enter Ending G/L Account
-
Enter the last GL number to be included on the report.
This report summarizes the GL reports created:
-
Report header includes GL account levels select and exact directory location of GL report files and report file name.
-
GL account level and description
-
Total hours and amount for account level
-
Indication of when the report was emailed.
-
The email address, as defined by the Finance GL account dictionary.
-
The GL report per GL account level lists the following:
-
Employee number and name
-
Pay period.
-
Transaction type.
-
Code type followed by pay or deduction code.
-
Cost center or costing distribution.
-
GL account code
-
Hours and amount.
-
Subtotals per pay period and payroll ID.