Import Pay - RESC File - Error Messages

The following table explains Import Pay audit log error messages that will cause the import to fail for the whole file or for individual lines in the file.

If the whole file fails to import, then correct the error and run Import Pay again.

If individual lines fail to import, then:

Correct the errors in those lines
Create an import file that contains only the corrected lines

Run Import Pay again to import the corrected lines.

Important: If individual lines fail, then you must re-import only the corrected lines or you will duplicate RESC imports for the lines that did not fail.

Error Message	Cause
RESC Import file Format is not valid Import file is not in the expected format. Please correct the file and re-try the import.	Import file is set up incorrectly. Check that the import file has 4 columns/fields (3 commas per line) with a comma separating each field.
Mandatory field is not populated Line (number), [Fieldname] is a required field on all transactions. Please correct the file and re-try the import.	The Employee Code, Allowance Code or RESC Amount fields are not filled in (blank or null)
Field format is not correct Line (number), [Fieldname] does not match the expected format. Please correct the file and re-try the import.	The field value is not consistent with the field format. For example, the RESC Amount field contains R1234 instead of 1234.00 or 1234
Field size is not correct Line (number), [Fieldname], [Field value] does not match the expected size – it is too large. Please correct the file and re-try the import.	The field is larger than the field size and expected values. For example, Employee Code is 16 characters instead of the expected 12. The RESC Amount field allows values from -999999.99 to 9999999.99.
A field does not exist in the appropriate Database table. Line (number), [Fieldname], [Field value] does not exist in the database. Please correct the file and re-try the import.	The Employee Code, Allowance Code or Superfund Code value does not match the value in Exolvo as expected. For example, the Allowance Code is ABC123 and the allowance code in Exolvo is ABC132
Allowance code does not match criteria ( and no superfund is populated) Line (number), [Fieldname], [Field value] should be of type Z or A, and be Paying = No and Superannuation = Yes. Please correct the file and re-try the import.	Allowance Code contains an allowance that is not Type Z or A, Paying = No and Superannuation = Yes when Superfund Code is not populated. For example, Allowance Code contains an A-Type allowance with Paying = No, but it has Superannuation = No.
Allowance code is not linked to superfund (and superfund is populated) Line (number), [(Allowance code) Fieldname], [Field value] is not a valid allowance code for the selected Super Fund. Please correct the file and re-try the import.	The Superfund Code field is populated, but in Exolvo, the Superannuation Fund \| Allowances tab does not contain the allowance specified in the Allowance Code field. For example, In Exolvo, the ABC Superannuation Fund is linked to only the 501 allowance, but the import file has Superfund Code = ABC and Allowance Code = 510.
Superfund code is not linked to Employee ((and superfund is populated) Line (number), [(Employee code) Fieldname] is not enrolled in superannuation fund [(Superfund code) Fieldname] in Exolvo. Please correct the file and re-try the import.	The Superannuation Fund field is populated, but in Exolvo, the employee does not have an Employee Super Fund record for that Superannuation Fund. The employee has never been enrolled in that Superannuation Fund. For example, Superannuation Fund = ABC, but in Exolvo, the employee has only been enrolled in the XYZ Superannuation Fund.

Error Message

Cause

RESC Import file Format is not valid

Import file is not in the expected format. Please correct the file and re-try the import.

Import file is set up incorrectly. Check that the import file has 4 columns/fields (3 commas per line) with a comma separating each field.

Mandatory field is not populated

Line (number), [Fieldname] is a required field on all transactions. Please correct the file and re-try the import.

The Employee Code, Allowance Code or RESC Amount fields are not filled in (blank or null)

Field format is not correct

Line (number), [Fieldname] does not match the expected format. Please correct the file and re-try the import.

The field value is not consistent with the field format.

For example, the RESC Amount field contains R1234 instead of 1234.00 or 1234

Field size is not correct

Line (number), [Fieldname], [Field value] does not match the expected size – it is too large. Please correct the file and re-try the import.

The field is larger than the field size and expected values.

For example, Employee Code is 16 characters instead of the expected 12.

The RESC Amount field allows values from
-999999.99 to 9999999.99.

A field does not exist in the appropriate Database table.

Line (number), [Fieldname], [Field value] does not exist in the database. Please correct the file and re-try the import.

The Employee Code, Allowance Code or Superfund Code value does not match the value in Exolvo as expected.

For example, the Allowance Code is ABC123 and the allowance code in Exolvo is ABC132

Allowance code does not match criteria ( and no superfund is populated)

Line (number), [Fieldname], [Field value] should be of type Z or A, and be Paying = No and Superannuation = Yes. Please correct the file and re-try the import.

Allowance Code contains an allowance that is not Type Z or A, Paying = No and Superannuation = Yes when Superfund Code is not populated.

For example, Allowance Code contains an A-Type allowance with Paying = No, but it has Superannuation = No.

Allowance code is not linked to superfund (and superfund is populated)

Line (number), [(Allowance code) Fieldname], [Field value] is not a valid allowance code for the selected Super Fund. Please correct the file and re-try the import.

The Superfund Code field is populated, but in Exolvo, the Superannuation Fund | Allowances tab does not contain the allowance specified in the Allowance Code field.

For example, In Exolvo, the ABC Superannuation Fund is linked to only the 501 allowance, but the import file has Superfund Code = ABC and Allowance Code = 510.

Superfund code is not linked to Employee ((and superfund is populated)

Line (number), [(Employee code) Fieldname] is not enrolled in superannuation fund [(Superfund code) Fieldname] in Exolvo. Please correct the file and re-try the import.

The Superannuation Fund field is populated, but in Exolvo, the employee does not have an Employee Super Fund record for that Superannuation Fund. The employee has never been enrolled in that Superannuation Fund.

For example, Superannuation Fund = ABC, but in Exolvo, the employee has only been enrolled in the XYZ Superannuation Fund.

Topic: 27174