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.

 

Sage has issued a hotfix for their payroll which allows those who elected not to subscribe to the new payroll tiers to view payroll reports. Previously if a subscription was not present and the user previously was licensed for payroll they would have been locked out of the module – including any reporting.

This hotfix also reportedly extends the payroll expiration date for partner and accountant internal use copies of Sage payroll.

A separate hotfix is available by version and the fixes are only available for supported versions of Sage 100 and Sage 100c.

 

Description
Allows read-only access to an unregistered Payroll Module.

Extends the Payroll expiration date for Resellers and SAN Customers with Not For Resale (NFR) keys.

Cause
Payroll expiration date is expired for NFR keys

No longer own the Payroll module and need access to Payroll reports

Resolution
After installing this program fix:

 

1. Customers who no longer own the Payroll module will have Read-Only access to their Payroll reports
2. Payroll read-only allows access to most reports under the Payroll > Reports menu as well as the Quarterly Governmental Report and Employee Totals
3. Verification report under the Payroll > Period End menu

This enhancement is available for the following Sage 100 versions:

• 2015 PU5
• 2016 PU2 and higher
• 2017 PU1 and higher

Partners and SAN customers who have NFR in their product key, the Payroll Expiration Date will be extended to one of the following dates depending on the version:

• Sage 100 2015 PU3 and higher – 12/31/2018
• Sage 100 2016 PU1 and higher – 12/31/2019
• Sage 100 2017 PU1 and higher – 12/31/2020

If the Payroll expiration date does not update after installing the applicable Program Fix, do the following:

1. Open Library Master, Setup, System Configuration
2. Click the Registration tab
3. Click Activate or click Edit then click Activate

   Download the applicable program fix below for the specific version of Sage 100 you have installed.

 

Sage 100 Partner / Accountant Payroll Expiration and Read-Only Hotfix