Sage 100

v2018 standard - Re-creating the version 2015 VI import to payroll data entry. In the input file there is a department number and employee number. In v2018 there isn't an employee number in the PR_Payroll Header, only an employee key. Has anyone successfully created a 2018 payroll data entry import? How did you handle the employee number?

Doug, I am sure there has been a couple created......... I believe you will have to import the department and employee number fields into temp fields, then create a calc formula for the employee key. Somewhere out in Sage U there are several helpful videos on the process. You also need to insert some perform logic to handle your auto deductions (some posts recently here). And be sure to sort your input file by employee number so all import records for the employee is sequential (also a recent post here). Oh, and don't forget to create the PR header file prior to the import. Have fun!!

Q: How do I import Employee Key if I have Department Number and Employee Number in separate columns? A: Create String Temp field to store Department Number by clicking Add Temp Field button located in middle of panel Set Operation to Replace Set Col/Pos to column in sourcefile that contains Department Number Set Assign Temp On to Key Assigns Only Select Clear on each Record Create another String Temp field to store Employee Number. Set Operation to Replace Set Col/Pos to column in sourcefile that contains Employee Number Set Assign Temp On to Key Assigns Only Select Clear on each Record Set EmployeeKey Operation to Calculated with the following calculation: _obj'ConvertToEmployeeKey$(Temp001$,Temp002$) owhere Temp001$=Department Number & Temp002$=Employee Number (KB86744)

@JaneCavanaugh posted this first - I take no credit.

@DougHiggs - Just another reason why you should not skip the MOTM conference.....

Thank you @BethBowers and @JeffSchwenk . You saved me a bunch of time and hassle.