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 are the fields that are 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)
     • Refer to KB86745 for more details