Creating a Payroll Export Task

  1. Select Maintenance > Payroll Settings > Payroll Close > Payroll Export Task.
  2. Click Create New Entry.
  3. Specify this information:
    Name
    Specify a unique name for the task. This name is used to specify the Name field (Wbityp_Name column) in the Export Transaction page (WBINT_TRANSACTION table) when a scheduled task in the Job Scheduler runs a Payroll Export Task with the Write to Staging Table option selected.
    Description
    Optionally, specify a description of the Payroll Export Task.
    Output File Path
    Specify the path to where the export output file is to be placed. Use an absolute path.
    Output File Mask
    Specify the exported output file name's mask. The file name of the output file is generated based on the pay group and the time when the pay group was created. The pay group is indicated by the PAY_GROUP_NAME variable and the date can be formatted. See Datatime format for Layout tag.

    For example, if the output file mask is payroll-PAY_GROUP_NAME-yyyy-MM, then the resulting file name is payroll-Night328-2023-03, where Night328 is the pay group name. The file was created in March 2023.

    Output File Extension
    Optionally, specify the extension of the output file name.
    Comments
    Optionally, specify comments for this payroll export task.
    XML
    Specify the XML definition.
    Export Adjustments to a Different File
    If you selected the Adjustments to be created for this group check box when creating or editing your paygroup, you can select this option to create an additional export file for adjustments. For more information, see "Creating or editing pay groups" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.

    The export for the adjustments uses the fields outlined in VIEW_PAYEXP_ADJUSTMENT fields. The setup is extensible allowing you to choose the fields that you want.

    Filter Zero Records
    Select this option to filter out all time records with a value of 0 from actual payroll export values. By default, this option is unselected. Select the check box to suppress the 0 records on export.

    This value is derived from the WRKD_ MINUTES field. Records are filtered out when the WRKD_MINUTES field is 0.

    Note:  This field may return incorrect results under certain circumstances. This includes values from mapped inputs or functions that result in a value of hours rather than minutes. If you receive unexpected results, verify the input to the WRKD_ MINUTES field.
    Extension Script
    Specify an extension script for the Payroll Export Task. See Using the Payroll Export extension script.

    For more information on extension scripts, see Infor Workforce Management Custom Scripting Developer Guide.

  4. Click Save.