x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 107 subscribers
  • Views 743 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
kalexander@hughessnell.com

Importing employee data

SUGGESTED
Posted By

I'm attempting to create an import job that will either create a new employee record if it does not already exist or update an existing employee if it's already present.  I'm running into an issue where existing employees are not updating and am not sure why.  Any ideas would be greatly appreciated.  This is for Sage 100 2018 - new payroll platform.  

  • 0
    SUGGESTED

    I tested this in v2020 by importing names into existing employee records and had no issues. Does the Job Log indicate records are being skipped or are there errors? At the risk of being Captain Obvious, do you have "Skip Over Existing Records" checked?

  • 0 in reply to rclowe

    Thank you for the reply.  "Skip Over Existing Records" is not checked (that would have been too easy...LOL)  The job log indicates that the record passed with invalid fields for existing employees - the failed field being the social security number stating that it's already on file.  Tests to update the employee address do not update, so I can only assume it's due to the SSN error.  

*Community Hub is the new name for Sage City