Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

Here’s How To Import To The New Sage 100 Payroll in Version 2018

October 13, 2017 by Wayne Schulz

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.

 

Share this:

Filed Under: Sage 100 ERP Tagged With: payroll, sage 100

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • When Will Sage 100 2023 Be Released?
  • Sage 100 Updated TLS 1.2 Licensing Requirements ( February 2023 )
  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2023 · Parallax Pro Theme on Genesis Framework · WordPress · Log in