Format Errors and How to Correct Them

The following format error messages are displayed for payroll files uploaded in either text or Excel formats.

 

FORMAT ERROR

HOW TO CORRECT

Critical error: Unable to load record from bin.

A log to be raised with the Vendor

Value not numeric. ACT

Change the format of value to be Numeric

Value not numeric. ECS

Change the format of value to be Numeric

Value not numeric. RCS

Change the format of value to be Numeric

Not a valid Income and Expense Type(ACT)

Update the Income Type

Not a valid Income and Expense Type(ECS)

Update the Income Type

Not a valid Income and Expense Type(RCS)

Update the Income Type

Not a valid Membership Reference Number

Correct the Membership Number

ZERO Reference Number not allowed when auto generation of reference numbers is switched off

Correct the Zero Reference Number

Error executing Reference number generation stage 2. The error has been logged

A log to be raised with the Vendor

The new entrant reference number was not generated successfully

Check the error log and that the Threshold has been generated correctly on Pay Centre Settings

Surname, ID Number and DOB already matches other memberships (this error includes a list of the other memberships)

Edit the Format Error and select the correct Membership Number

Zero Reference number required for new Employee details for this fund

Add a zero reference number in the payroll file you are uploading if the member is a new entrant.

Duplicate: This membership is exit finalised, but discrepancy found. To create a New Entrant for this person, Edit and Save the format error using the old reference number.[38511] <includes reference numbers>

Edit the Format Error and select the correct Membership Number or create a New Entrant with zero reference number if this member is new

Error executing Reference number generation stage 2. The error has been logged

Raise a log with the Vendor

The new entrant reference number was not generated successfully

Check the generation of reference numbers

Duplicate: Employee already has a Membership in this fund.[38501]

Edit the Format Error and select the correct Membership Number or create a New Entrant with zero reference number if this member is new

Reference Number, Identity Number mismatch.

The reference Number or ID number needs to be corrected.

Illegal characters in initials or surname

Update the Illegal Characters

Contribution Category is invalid.

Update the correct Contribution Category

Benefit Category <Benefit Category> + <PlanID> is invalid.

Benefit Category and Pay Centre code is not valid and needs to be updated.

Member needs to be at least <MinimumAge> to join fund.

Remove member from file or make sure that date of birth is correct

Member has passed his/her retiral age. <Age>

Remove member from file or make sure that date of birth is correct

The Date of Joining Fund contains invalid data. <ReferenceNumber>

Correct the invalid data.

Date of Joining Fund cannot be prior to Commencement Date of Fund

Correct the Date of Joining Fund

Date of Joining Company cannot be greater than Current Cycle

Correct the Date of Joining Fund

Date of Joining Fund cannot be less than Date of Joining Company / or invalid.

Correct Date of Joining Fund

Date of Joining Fund cannot be greater than Current Cycle.

Correct Date of Joining Fund

Membership cannot be active on two paycentres for one cycle date. <Transfer Error>

Investigate the member. Perhaps a transfer in or out needs to happen.

Data corruption averted: Payroll employee details does not match details of transfer. <Transfer Error>

Correct and Update Employee Details

Not a valid Membership Reference Number. New Entrants must be Generated.

Correct the reference number or if the member is a new entrant, update zero reference number.

Duplicate: Employee already has a Membership in this fund.[38521]

What is the difference between this one and the error above [38501]

Duplicate: Employee already has a Membership in this fund.[38531] <includes membership count and reference number>

Edit the Format Error and select the correct Membership Number

Data corruption averted: Payroll employee details does not match details of transfer.

The user needs to use the transfer -IN menu on the system to do the transfer. Then the user can save the format Error to store the new details from the file

Member found in previous cycle for this pay centre - manual transfer required. <Member is not allowed to be transferred in and out in the same paycentre in less than 3 months>

The user needs to use the transfer -IN menu on the system to do the transfer. Then the user can save the format Error to store the new details from the file

Investment Option Code invalid.

Correct and Update Employee Details

Format error due to invalid characters. <show which line on file has the invalid chars>

Edit the format error and correct the invalid character

Record does not have a valid mask code

Correct the Mask Code

Paycentre (Force Payroll Mask) is an invalid mask code.

Correct the Mask Code

Error: Cannot load membership for fund (FundName). Fund status must be OPEN for the Pay Centre.

You are not allowed to

Error: Mask does not contain a field for branch (level 3).

Add a branch field for the mask.

Error (21202) in Payroll Upload: <includes an unknown error. would require investigation>

Raise a log with the Vendor