Delivery Options for Extract-Based Payroll Reports
Use the Report Category to define multiple delivery options for the following extract-based payroll reports:
-
Payroll Activity Report
-
Gross-to-Net Report
-
Statutory Deduction Report
-
Payment Register
-
Payroll Register
A report category is a set of delivery options grouped together.
A delivery option defines where and how the report output is delivered, including the output file format, choice of template and optionally a destination such as an FTP server.
You can also define your own delivery option and include it in the report category. For example, you can define a delivery option to use a combination of both PDF and Excel outputs for a single submission of the report.
The new optional Report Category parameter is added to the payroll report flow task to show the list of delivery options defined for the report's extract definition.
Here's the steps required to add Delivery Options for the Payment Register:
-
Select the Manage Extract Definitions task in the Data Exchange work area.
-
In the Search window, enter Payment Register in the Name field.
-
Select Archive Retrieval in the Type field.
-
Select a a legislative data group (LDG) and click Search.
-
Click Payment Register in the Search Results region.
-
Click the Deliver tab in the Manage HCM Extract Definitions: Payment Register page.
-
Select the Extract Delivery Options tab under the Hierarchy panel on the left, and complete the following:
-
Click Add to add a row for the delivery option you're about to create.
-
Enter these details.
Field
Description
Delivery Option Name
Enter a value, example Excel Register.
Output Type
Select a value, for example, Excel.
Report
Enter the location of the report output.
Template Name
Enter the name of the report template for this output type.
Output Name
Enter Name of the report output, for example, Excel Register.
Delivery Type
Select the mode of delivery of the report, for example, Documents of Record.
Required
Select this check box if this delivery option is a required option.
-
Click Save. The newly created delivery option is saved and you can select it when you create the Report Category.
-
-
Click Add in the Report Category Section.
-
Enter Short Name, Report Category, and Description of the new Report Category.
-
Click Add in the Additional Details section.
-
Select the name of the Delivery Option you have created.
Similarly, create additional delivery options and select it here. For example, create a delivery option to create a PDF of the register and have it delivered by email. Enter the email details in the Additional Details section.
-
Click Save and Close.
When you run the register, select the newly created report category to deliver the register in Excel in the Documents of Record.