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. 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. 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:
  1. 1. For importing into Payroll Tables:
     2. _obj’ConvertToEmployeeKey$(Temp001$,Temp002$)
     3. For importing into Production Management tables:
     4. _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