How to import into the Employee Key field when using Visual Integrator in Sage 100

Resolution

• 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:
  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