Labor Distribution Export

A Labor Distribution Export is designed to follow a Payroll Export. While the Payroll Export shows the paid hours for a group of employees, the Labor Distribution export shows all the transactions (paid and unpaid) for the pay period for each employee. The Labor Distribution Export shows the actual cost of the labor.

The parameters for the Labor Distribution Export (Parameter Names on the Exports form) will correspond to previously run payroll exports. You cannot select all of them; you can only select one.

Once an export has been configured, you can run it via Run Export on the Exports form. To configure an export, see the Configuration Steps below.

See Also: Labor Export

See Also:

Configuration

Run the Labor Export

Download/View/Save the Labor Distribution Export Data

 

Configuration

To configure a Labor Distribution Export, follow the steps below:

Step

Details

Form to Use

1. Create the Export Rules

Export rules determine when and how labor data is grouped (when the LABOR_ALL_MT service runs). Each rule is expressed as an IF-THEN statement. The IF portion contains one or more conditions, and the THEN portion contains one or more actions. When the conditions are met, the action is executed. Use the Export Rule Operands to create the rules.

Calc Rule

2. Create an Export Ruleset (with Context Name ExportRuleset)

Rulesets are used to group individual rules. When you create the ruleset you add individual rules to it. You will assign the ruleset to an Export Name later.

Note: You must use ExportRuleset as the Context Name.

Ruleset

3. Assign Individual Rules to the Ruleset

Assign the rules you created in Step 1 to the Ruleset you created in Step 2.

Rulesets

4. Create an Export

When you create an export, you define which Ruleset to use when the export runs. For example, you can assign the Ruleset you created in step 2.

Note: The Split Premium field requires that you have an Export Premium Policy configured.

Export

5. Configure the Data Export

By configuring the export, you format the output of the data that can be extracted from system tables. You can create fixed-length or comma-separated values file. You can configure how you want the header, detail and trailer to look in your output.

On the Export Parameters tab, set the PROCESS_NAME to Labor Distribution.

Export Definition

6. Configure the Data Output Format

You can modify the format of the output data. For example, you can determine the output of positive and negative values.

Field Function

 

Run the Labor Export

Once you have configured the labor export, you can run it via the Exports form. When you run the export you extract labor data from the system tables based on the Ruleset in the Export Name.

  1. Click Main Menu > Payroll > Exports.

  2. Select the Export Name from the drop-down menu.

  3. Enter an Output Name. This is the identifying name of the export instance.

  4. If you want to include records that have not yet been exported, check the New Records box.

  5. If you want to include previously exported records, check the Prev Exp Records box.

  6. If you checked the Prev Exp Record box, use the Prev Exp Start and Prev Exp End date fields to specify the dates when the records were previously exported.

  7. In the grid section of the form, select the Payroll Export on which this Labor Distribution Export will be based.

  8. Click Modify.

  9. Check the Select box and click Save.

  10. Click Run Export on the toolbar.

 

Download/View/Save the Labor Export Data

You can download, view, and save the output data via the Output tab on the Exports form. The steps listed below are also available in the Output section.

  1. Click Main Menu > Payroll > Exports.

  2. Go to the Output tab.

  3. Click the filter button and use the filter fields to find an output file.

  4. Select the record and click Download on the toolbar. You can open or save the file.