• 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

[BCB:155:Chat 100 US:ECB]

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