The Public Bodies Report option allows you to print the Public Bodies Detail Report and the Public Bodies Summary Report using the data collected in Options 2 and 3.
You will be prompted for the following information:
Minimum Supplier Amount
The report will list all suppliers above the miscellaneous limit entered. (Enter <Enter> if you wish to use the $10,000 default amount.) Those suppliers under the miscellaneous limit are grouped into one total as "miscellaneous" and are printed in the second part of the report.
Minimum Employee Salary
The report will calculate the total for all employees with salaries above the limit entered. (benefits are excluded).
-
Accept the default, if you wish to use the $50,000 default amount.
Employees earning less than the limit are also totaled but not reported in detail by payroll.
Sort by Name or Salary
-
Enter 'N' to sort the report by name with no salary control breaks. (BC format)
-
Enter 'S' to have the report broken down into salary levels. (Saskatchewan format)
If 'S' is selected, the following prompt will appear:
Salary Increment
For reports sorted by 'S'alary, enter the salary ranges. (Default is $10,000 - i.e.., $0 - $9,999 $10,000 - $YYYY9, etc.).
Create Delimited Export File
-
Enter 'N' if you don't wish to create an export file.
-
Enter 'Y' to create a file which can be exported to a spreadsheet program.
Note: This feature can only be used if you are running OPS.
The use of this option requires that the logical SRB$Export is setup in your logicals.com file. There will be two files created by this process that will reside under the SRB$Export directory:
These files are: ######.SUP supplier export file
######.EMP employee export file
where ###### represents the job number created at the time the Public Bodies Report was run.
If 'Y' is selected, the following prompt will appear:
Enter Delimiting Character
-
Enter 'T' to create a tab-delimited file.
-
Enter 'C' to create a comma-delimited file.
Provide Vendor Service
-
Enter 'Y' if you wish to have the Vendor service displayed on the report. The information displayed is taken from field #21 on the vendor menu.
Provide Vendor Type?
-
Enter 'Y' if you wish to have the Vendor type code displayed on the report.
Note: When the Public Bodies Report is run, a file is created with the 6-digit # (######.LST). This file lists the suppliers and employees who are included in the report. Two additional files are created which list the detail of suppliers (LST_A) and employees (LST_B) who are under the specified $ amount for the Public Bodies Report.
Print Position Description for Employees?
-
Enter 'Y' to print the employees position on the report
-
Enter 'N' to omit printing the employees position.
Note: The position description of all elected officials will print on the report.