How to import into the EmployeeKey field when using Visual Integrator on Sage 100 2018 and higher

• EmployeeKey is an encrypted value of the Department Number and Employee Number

  If sourcefile contains Department and Employee Number in same column in the format DD-XXXXXXX:

  • Set Operation to Replace
  • Set Col/Pos to Column in Sourcefile that contains DeptNo & EmployeeNo in DD-XXXXXXX format

  If sourcefile contains Department and Employee Number in separate columns:

  • Create String Temp field for Department Number by clicking Add Temp Field button located in middle of panel
    1. Set Operation to Replace
    2. Set Col/Pos to column in sourcefile that contains Department Number
    3. Set Assign Temp On to Key Assigns Only
    4. Select Clear on each Record
  • Create another String Temp field for Employee Number
    1. Set Operation to Replace
    2. Set Col/Pos to column in sourcefile that contains Employee Number
    3. Set Assign Temp On to Key Assigns Only
    4. Select Clear on each Record
  • Set EmployeeKey Operation to Calculated with the following calculation:
    • For importing into Payroll Tables: 
    • _obj'ConvertToEmployeeKey$(Temp001$,Temp002$)
    • For importing into Production Management tables:
    • _obj'ConvertToMFGEmployeeKey$(Temp001$,Temp002$) 
      • Where Temp001$=Department Number & Temp002$=Employee Number

  Note: If Payroll Departments is not selected in Payroll Options, simply replace the EmployeeKey with the column that contains Employee Number

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

Where are the sample ACA Visual Integrator jobs located