When Sage releases Sage 100c v2018 on October 20, 2017 one of the biggest features will be the new payroll module.
This has been completely re-designed from the ground up. Gone are the days of making copies of your current year payroll data before printing W2 forms and closing for the year.
One thing that we may need to re-learn is the process for importing data to payroll using Visual Integrator.
Unlike prior versions, the new release of Sage 100 payroll will require that you import to 2 tables.
– PR_PayrollCycle
– PR_PayrollHeader
Frequently Asked Questions About Sage 100 Payroll 2018 Import using Visual Integrator
Q: What file do I need to import into when importing Payroll Data Entry?
A: To import Payroll Data Entry, you must import into both PR_PayrollCycle & PR_PayrollHeader. (KB86731)
Q: Since I now need to run 2 separate Import Jobs to import Payroll Data Entry, is there a way to set up the imports so the second Import Job is automatically run after the first Import Job is complete?
A: Yes. The Chain To option on the Payroll Cycle Import can be configured. Simply click the lookup and select the Payroll Import Job to be run after the Payroll Cycle Import is complete. (KB86733)
Q: Is Batch Processing now available in Payroll Data Entry?
A: Yes. Batch Processing can now be enabled for Payroll Data Entry by selecting the option on the Entry tab in Payroll Options. (KB86741)
Q: Can I set up Import Job to import the next available Batch Number?
A: No. The Next Operation cannot be used with the Batch Number field and the other “tricks” that are used for other Data Entry Imports i.e. Assign Blank or Replace from blank column do not work -It will just assign to batch 00001. Batch number can be assigned a static value, set to Run-Time Assign, so the batch Number is manually entered during the import, or it can be replaced from a value in the sourcefile. (KB33719)
Q: What is Employee Key?
A: Employee Key is an encrypted combination of both Department Number and Employee Number
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$)
- where Temp001$=Department Number & Temp002$=Employee Number (KB86744)
Q: Are there other ways Employee Key can be imported besides using a calculation?
A: EmployeeKey Operation can be set to Replace if sourcefile contains Department and Employee Number in same column in the format DD-XXXXXXX where DD=Dept No and XXXXXXX=Employee No (KB86744)
Q: Auto Deductions are not displayed after running Payroll Data Entry Import
A: Open Import Job Maintenance and select the PR_PayrollHeader import. Click Perform button on Configuration Tab. Click Existing Perform Lookup button in upper right corner. Select Before Write command tmp = coBusiness’PreWrite(0). modify command to tmp = coBusiness’PreWrite(1) and click Accept. Running Import Job with Before Write command tmp = coBusiness’PreWrite(1) will populate Auto Deductions when importing Payroll Data Entry. (KB86745)
Here’s a demo of how the process will work within the new payroll module.
