Sage 100

Error occurs when importing into PR Data Entry (v2016) from data exported from Kronos. We thought it might be records in the source data for new employees, and removed them from the file, but still get the error. Can anyone tell me what the line number refers to? Error occurs almost immediately after launching the job.

Do you have any CALCULATED fields?

You cannot divide by 0.

Yeah, this is an import that Kronos wrote for them a LONG time ago, and I'm trying to interpret everything that's going on.

And yes, there are calculated fields.

Post the VI job.

Here you go.

This might make it easier. By the way, I opened a case with Sage. Sent them the job and the source file.

Has this always been this way?

i don't know, but they run these jobs semi-monthly and have had for years. There has been no change to their Sage - no product updates or changes to the VI job.

Other things we tried: I rebuilt the employee masterfile (just cuz), removed all records from the file except for 2 employees (still fails right away and doesn't even create a log file); tried to import the last file that successfully uploaded (it fails now, too). So it seems like it's not data.

When comparing this CSV to the one that imported, are there any differences in layout?

Make a copy of the VI job and start removing VI fields one at a time until you determine what field is causing the error. Begin with the most suspicious suspects.

Barbara, looking at the code of that program and line number, it's doing a calculation where it is dividing by the employee's Autopay hours from PR1. That must be zero. It only does it if the employee's pay method is S and the Use Pay Rate from PRD's Employee's Earning Code record is either 1 or 2. Hope this helps.

Barbara, as a follow up, it only hits this condition and calculation if the rate on the PR7 data entry's earning detail record is zero. Just noticed that.

Thanks @MarcosDeLuna! Passed the info to the client to have them see if they can identify the issue in the data.

By the way, since the last good file failed during testing, I ended up rebuilding their PR data files. Errors found in PR6 (no records in blocks) , among other files. Good last file now works.They had manually entered the data because they needed to get payroll out.