Export Roster to Payroll

The Export Roster to Payroll run command is the equivalent of using the Export to Payroll command in Daily View.

When you have completed checking and editing your Roster, you can export it to Payroll for further processing.

Before you run the Export Roster to Payroll command ensure that you:

• Process transactions for all employees for the pay period.
• Run the Pay Calculation Report to check payments.
• View transactions to resolve any payments that appear incorrect.

Prerequisite

The Export to Payroll tab page must be completed in Company Settings. The file that is created as a result of running the Export Roster to Payroll command is written to the Data path specified in Company Settings.

Procedure

1. Navigate to Rostering | Export Roster to Payroll in the PayGlobal Tree.
2. Double-click the Export Roster to Payroll run command.

   You have options to filter by Query or by Employee.

   Leave these fields blank to export all employees.

3. Click on the Pay Sequences pick list to display the current open Roster pay sequences. Click a check box to select the required pay sequence. Click OK.

   The number that is displayed in the Pay Sequences field refers to the total number of pays selected, not the pay sequence number.

4. Export Filename: To use the default file name from Modify Company settings leave this field blank, otherwise enter the required data path and file name.

   Generally this is a file called Pgpayf.adt which is written to the Import sub-folder in the Data folder. When you double-click the Import Pay run command, the file is renamed to Pgpayf.bak and the transactions can then be viewed.

5. Click OK.
6. View the audit log to confirm that all employees have exported to payroll successfully.

Troubleshooting

There are two main reasons why an employee will not export to payroll:

• There are no transactions for the entire week in Daily View.
• The employee Export to Payroll field is set to 'No'. To fix this, navigate to the Employees | T&A/Rostering | Actuals | Details tab, and confirm Export to Payroll = 'Yes'.

Details tab

Query: This field allows you to export a specific group of employees using an employee query. To export all employees, leave this field set to 'Default'.

Employee: This field allows you to select a specific employee's data to export. To export all employees, leave this field blank.

Pay Sequences: Select the required pay sequence from the list of current open Roster pay sequences. The number that is displayed in the Pay Sequences field refers to the total number of pays selected, not the pay sequence number.

Export Filename: Leave this field blank to use the defaults in Company Settings or you can supply the required destination and filename.

For example: C:\PayGlobal\Pgpayf.adt.

If due to your network security access PayGlobal cannot write to the location entered in this field or to the default location, the export file is written to your PayGlobal database Temp folder.

If you are unsure where your export file will end up, check your Export Roster to Payroll audit log.

Advanced Filter Options tab

You can further define the data you wish to export by selecting records on the following sub-tab pages:

• Departments
• Locations
• Work Areas
• Awards
• Dims 1 to 4

To export all employees, leave all tab pages untagged.

Terminated Employees

• If a terminated employee has no transactions to export, then no entry appears in the audit log for the employee.

  If a terminated employee has transactions, a message similar to the following appears in the audit log and the transactions are not exported:
  !15 1013 Peters, Shirley Joan (not exported - terminated employee).

Topic: 13139