Sample File
File Requirements
The standard Pay Register Import screen is available under the Import menu on the Company tab.
The pay register import allows users to import pay register data for multiple assignments for a specific payroll system and pay period/pay date. For detail on exchange rate use in pay register, see the appendix.
The user may specify which status pay registers should be created. A pay register must be in Approved status to be available for shadow payroll reporting or the global statement of earnings report. The existing method for updating the status of a pay register is to Approve the pay registers individually on the Pay Register screen. A system preference exists to override this setting and create pay registers automatically in an Approved status. The system preference code is PYRGDEFSTT and the name is - Pay Register Default Status.
The pay register import will create both the pay register header records and the pay register line records. An additional system preference drives how a pay register import will react to duplicate records. The default setting is to allow duplicates and create them as manual adjustments to a pay register. The other option is to report the duplicate as a warning in the error log. The system preference code is PYRGDUPPRF and the name is - Pay Register Duplicate Preference.
Wage codes are a prerequisite for running the pay register import. If more than one account has the same wage code, then a “Primary Wage Code for Import” must be set on the Wage Code tab of the payroll system. The import will create records for the primary account if multiple accounts have the same wage code.
Upon successful completion of a pay register import for a payroll system and pay period/pay date, the pay register status for the pay period will be updated to Complete.
Currently the pay register status is only informational. Pay registers can be imported for any pay period that is set-up for the payroll system chosen.
The pay register import file format is comma-delimited and requires the following fields:
TABLE_NAME
FIELD_NAME
IDENTIFIER VALUE
WAGE_CODE_WHEN_PRIMARY (for primary payroll system that pay register is entered for)
AMOUNT
The TABLE_NAME / FIELD_NAME combination is the assignment identifier for the import. Available values are as follows:
TABLE_NAME | FIELD_NAME |
ASSIGNMENT | ID |
ASSIGNMENT | EMPLOYEE_ID |
ASSIGNMENT | NUMBER |
ASSIGNMENT | FROM_EMPLOYEE_ID |
ASSIGNMENT | FROM_NATIONAL_ID_NUMBER |
ASSIGNMENT | FROM_PAYROLL_ID |
ASSIGNMENT | FROM_SOCIAL_INSURANCE_ID |
ASSIGNMENT | FROM_NATIONAL_TAX_ID |
ASSIGNMENT | TO_EMPLOYEE_ID |
ASSIGNMENT | TO_NATIONAL_ID_NUMBER |
ASSIGNMENT | TO_PAYROLL_ID |
ASSIGNMENT | TO_SOCIAL_INSURANCE_ID ASSIGNMENT TO_NATIONAL_TAX_ID |
Troubleshooting Tips for Pay Register Import
"Error processing Row #1 String or binary data would be truncated." - this error can be resolved by updating the description of the Payroll System to 50 characters or less.
The Pay Register Data import uses a stored procedure that copies the Description field of both the Primary and Secondary Payroll Systems of the assignee from the Payroll System (which has a limit of 255 characters) to the Pay Register (which only has a limit of 50 characters). The discrepancy in the field lengths will result in an error.