Client Allocation Report

This report provides a listing of client allocations based on the allocation format selected.

Parameters and defaults:

•

If there is a company level Client Allocation Parameters record saved, this will determine the default values in the form for this report.

•

If there is not a company level Client Allocation Parameters record saved, the default values will be global level parameters if a Global level record has been saved in Client Allocation Report Parameters.

•

If there is no company or global level Client Allocation Parameters record, the system defaults are as shown.

To access this form, click Reports menu. Under Payroll|Report, click Client Allocation Report.

Note: You can also access the Client Allocation Report for a selected payroll in the Approval Payroll Reports form. To do this, select Approval Payroll Reports in the View Report/Analytic field on the Payroll Approval form, then select Client Allocation Report in the Report Title column.

To run the Client Allocation Report:

Enter Selection Parameters to determine what displays on the report (required).

•

Enter the Payroll Number to run this report for a specific payroll or select Enter a Pay Date Range and enter a Start Date and End Date to run the report for a date range.

Enter Report Parameters to determine how you want the report to display.

•

Select the Allocation Format from the drop-down (required). Allocation formats are managed in the backend/legacy system (HRPyramid); see the task sheet Setting Up and Creating a Client Allocation Report on the Customer Resource Center. The Allocation Format controls what data will be in each column of the report. When a format is selected, the number of columns defined display.

•

Select the Report Type.

•

Detail Report: This option displays the amounts allocated for each employee and miscellaneous charges at each allocation level, sub-totals for each allocation level, and the report total.

•

Summary Report: This option displays sub-totals for each allocation level and the report total.

•

Select Suppress EE Info in Report to suppress the line in the Detail Report displaying additional employee information, allowing more employees to fit per page in the report.

•

Select Suppress Employee ID to suppress the Employee ID column in the Client Allocation Report.

•

Select Suppress Subtotals to suppress the subtotals from the Detail Report.

Note: Using these two options together (along with the allocation and sort parameter Field Type Employee), allows the report to display employee amounts only.

From the Field Type Column Display drop-down, select one of the following options:

•

Both Code and Description: This option includes a column in the report for the Field Type Code and the Field Type Description. This is the default.

•

Code Only: This option adds a column in the report for the Field Type Code.

•

Description Only: This option adds a column in the report for the Field Type Description.

•

Do Not Display: This option suppresses both the Field Type Code and Field Type Description in the report. If this option is not saved on the Client Allocation Report Parameters form, the default is Do Not Display.

From the Field Type Column Display Order drop-down, select one of the following options:

•

Before EE Info: This option adds the Field Type columns to the report, before the columns with employee information.

•

After EE Info: This option displays the Field Type columns to the report, after the columns with employee information. If this option is not saved on the Client Allocation Report Parameters form, the default is After EE Info.

Select Other Parameters as appropriate.

•

Select Sort by Field Type Description to sort by the Field Type description instead of the Field Type Code.

•

Select Suppress Page Break on Primary Sort (Detail Report) to suppress additional page breaks in the primary allocation in the Detail Report.

•

Select Include Page Break on Primary Sort (Summary Report) to add a page break to the primary allocation in the Summary Report.

•

Select Print Detail Line if Zero to include all allocated employees and miscellaneous charges, even when the amounts set up for the Allocation Format is zero (or null) for the employee or miscellaneous charge.

•

Select Suppress Miscellaneous Billing to suppress miscellaneous charges from the report.

Enter Header Options. These options determine what information that appears in the report header when running the report for a Payroll Number. If the report is run for a date range, only the date range appears in the header.

•

Enter the Header Code.

•

Payroll Number: Displays the Payroll Number in the report header.

•

Invoice Number: Displays the Invoice Number in the report header.

•

Both: Displays both the Payroll Number and Invoice Number in the report header.

•

Select Include Pay Group in Header to include all pay groups included in the payroll, along with the period start and end dates.

Enter Output File (XLS) options to determine the content exported to Excel via XLS:

•

Suppress Company Name suppresses this column when exporting as an Excel report.

•

Suppress Report Title suppresses this column when exporting as an Excel report.

•

Suppress Select Criteria suppresses this column when exporting as an Excel report.

Enter the Allocation and Sort Parameters in the table, in display order. The criteria entered in this table control how the amounts included in the report are allocated.

•

Select the Field Type. This field controls the sortand how the amounts will be allocated for each employee and miscellaneous charge. If an employee or miscellaneous charge has time split across multiple items entered in the Field Type (for example, multiple departments), the amounts will be allocated across all departments. At least one field type is required. There is no limit to the number of fields you can enter.

•

You can enter custom Field Labels to go with the Field Type. This option allows the label for the Field Type entered to be customized, if desired. For example, if allocating the Field Type DEPARTMENT the label in the report will display DEPARTMENT unless the Field Labels is entered as Dept, then the report will display Dept.

•

Select either Sort By or Detail Only from the Sort/Detail drop-down. The first Field Type must be a Sort By field. Both Sort By and Detail Only Field Types can be used for allocations within the report, but Detail Only will not be sorted or subtotaled.

•

Indicate whether to include a Sub Total for the field.

•

If you selected Sort By, the options are Yes or No.

•

If you selected Detail Only, the only option is No.

•

The first Field Type in the table must be set to Yes.

•

Field types with Sub Total set to Yes will have a subtotal within the report.

Click Run.

Note: If you want convert the report to a printable PDF, the report must not include more than 14 columns of data; If you selected the Suppress EE Info in Reports parameter, this maximum is 10. Reports that include more columns of data can be converted to Excel.