How to import into Payroll Data Entry using Visual Integrator

Description

How to import into Payroll Data Entry using Visual Integrator on Sage 100 2018 and higher

Resolution

Importing into Payroll Data Entry on Sage 100 2018 and higher requires importing into the 2 separate tables

1. Create import into the table PR_PayrollCycle
   • The following fields must be included:
     • BatchNo
       • Assign this field to 00001 if Batch Entry is disabled
     • PayCycle
     • PayPeriodStartingDate
     • CheckDate
   • Additional fields may be used for this import, but these fields needed at a minimum
2. Create import into the table PR_PayrollHeader
   • The following fields must be included:
     • H.BatchNo
       • This field is only needed if Batch Entry is enabled
     • H.EmployeeKey
       • Formatted DD-XXXXXXX where DD=Dept No and XXXXXXX=Employee No
       • Refer to KB86744 – How to import into the EmployeeKey for more details
     • H.CheckEntryNo
       • This field can be assigned to 1
     • L.LineType
       • This field can be assigned to E if only Earnings Codes are being imported
     • L.EarningsCode
     • L.Hours
   • Additional fields may be used for this import, but these fields needed at a minimum
   • Auto Deductions
     • Verify the following Perform Logic Command exists if Auto Deductions are desired:
     • tmp = coBusiness’PreWrite(1)
   • Verify the following Perform Logic Command exists if Auto Deductions are not desired:
     • tmp = coBusiness’PreWrite(0)

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.