Summary

This export file creates a Fixed Width file that has the following conditions:

• File format references a specific User-Defined Field and Dim Codes 3 and 4
• Contains a hard-coded data path

File Format

A separate file is produced for each Store code.  The filename is defined as "[CompanySettings.TAExportFileName].Company Number" or "[CompanySettings.LSExportFileName].Company Number" depending on whether you run T&A Export to Payroll or Rostering Export to Payroll.

Export Data 
Path

For most Export types PayGlobal creates the export file in the location you specify in the Data path field on the Export to Payroll tab page in Modify Company Settings. However, for the RM. REG/MasterPay export type PayGlobal applies a default hard-coded data path:

• \[store]\ferntree\out\

  The attribute store uses the Employee.DIMCode4 field.

A separate file is created for each store using the following format:

• brmrdn.ccc

  "brmrdn" is a constant string and "ccc" is a company number.

User Notes:

• If the T&A | Export to Payroll | Data path field does not contain this default data path, PayGlobal automatically applies this data path to the existing data path details.
• If you do not supply a drive, PayGlobal creates the above folder structure in the PayGlobal Database Temp folder, provided you have write access to this location.
• If you do supply a drive, but the above folder structure does not exist, PayGlobal creates the folder structure. provided you have write access to this location.
• If you do not have write access to create a new folder structure for the destination folder, the creation of the export file(s) will fail.

Additional Notes

• The PayCode is displayed using the following format: cccqqqqqqq
  • ccc = paycode and qqqqqqq = quantity or dollar of units
• The quantity of units is assumed to have two decimal places.  When the value is a negative amount an ‘M’ precedes the value.
• Allowance.PayrollAllowance codes beginning with the number eight (8) display quantity of units.
• Allowance.PayrollAllowance codes beginning with the number nine (9) display a dollar value.
• Each employee record displays a maximum of four cost codes. Where the number of cost codes exceeds four, the first 30 characters of the employee record are repeated on a new line with the details of the next four cost codes. This process is repeated until all cost codes for an employee are included in the report.

See also

Modify Company Settings

Rostering - Export to Payroll

T&A - Export to Payroll