Payroll Visual Integrator Job

I have a job that imports hours and earnings codes from our time clock system.  In general it works fine.  The only time I have a problem is when employees work a holiday and get double time.

For some reason, deduction code 4P (401k percentage) does not deduct from the double time hours.

If I go to payroll data entry and recalculate, it then comes up with the correct dollar amount.  I think the problem is with my VI job, but I can't figure out what it is.

Any ideas?

Sage 100 ERP 2014 edition

 

  • 0

    I don't know the answer, but.... In Payroll Setup, have you opened earnings code maintenance and put your double time earning code next to say regular time to see if there is some setting different that would cause this?  I would start there.

    Then, if you don't see anything, open deduction code maintenance for 4P, and hit the Earnings button to see if it has all earnings types, and exclusions are not funky.

  • 0 in reply to blorf

    Is the earnings code for double time imported after the 4P deduction?  If so, try placing it above the deductions.

  • 0

    You're either missing some required fields in your import job or your records tab is not defined properly or missing the perform logic needed.

    Refer to the following KB's:

    KB21326 - How to import into payroll data entry using Visual Integrator

    KB52022 - Automatic Deductions are missing when importing in PR.DATAENT

    KB21323 - How to determine required fields for Legacy import jobs

    If you still can't figure it out and have a support plan, you can e-mail your import job to [email protected] and Sage support can examine your import job.