85
I'm having an issue with an Employee integration. This is for new Employee's and updates. The new employee lines are failing with the message of "Paycode 'X' cannot be added because a base pay code has not been setup for employee 'X'"
The Document Errors out and the employee isn't setup at all with any of the paycodes.
Anyone have issues like this with the IM employee master import?
*This post is locked for comments
Jeff,
Thanks for the help! This worked like a charm. We have 3rd Party job costing software as well as HR, HRM, PIP and a Time Clock. I completed a "clean" install of GP and was able to integrate without any issues. Now we have a separate GP install/SET file that we use for Payroll and new employee integrations.
What a great solution, Thanks Again.
Tim Sparks
Have you tried these steps?
1. Open the Destination Mapping of your PR integration
2. Click on the Pay Codes icon
3. Click the Options Tab
4. Locate the Record Source
5. For that Option change the Rule from Use Default to Use Source Recordset
6. For the Source Select your Source file containing the data needed to be integrated.
The PR integration can be tricky at times because of HR, Payroll Extensions, customizations or 3rd parties. Generally, I will use these steps and it seems to resolve the issue for me:
1. Go to Tools >> Customize >> Customization Status.
2. Disable all modules except the following:
• Microsoft Dynamics GP
• Integration Manager
• SmartList
• Advanced Security
• Report Scheduler
• SmartList Builder
3. Close the Customization Status window.
If you have Human Resources (HR) and/ or HRM Solution Series (Payroll Extensions) installed this has been known to cause similar issues to this one.
When you exit Microsoft Dynamics GP and restart Microsoft Dynamics GP, the modules that you disabled, including HR and HRM Solution Series will be enabled again.
HR and HRM Solution Series are Microsoft products, however IM still considers these to be Third Party windows.
Integration Manager is still only designed to integrate to the basic GP windows. I don’t know of any plans for this to change, but until it does there are two options I recommend.
Option 1. Set up an alternate Dynamics.set file to be used while integrating data.
Option 2. Set up an additional Alternate/Modified Forms and Reports ID to be used with a specific login ID for integrating.
Per MSFT, the official work around is to remove HR and HR-related modules from the set file. The alternative, which I have seen work on several occasions, is to have the basic GP windows assigned, whether it’s for all users or one specific user login that is used for Integration Manager.
Hope this helps,
Richard,
Thanks again, No, that's not missing. I've tried different combinations that included either pulling off the source doc or default for the field. I've tried both with no success. I even have a paycode setup for "Default Data Entry" on the paycode setup screen.
Is this what is missing?
Richard,
Thank you for the response. It is a message you get when setting up a new employee, you have to setup a Base PayCode, say HOUR, then you can setup paycodes based from the base paycode.
I guess my question is how is that done on the IM employee import? The integration appears to have the functionality to import employee information and paycodes, but I'm not seeing any options in the destination mapping to handle "Base Pay Codes".
Thanks,
Tim
Have you tried to add an employee using GP first? Go through the exact same steps and you should see the same message. Has this integration ever worked? I am wondering if some warning box will appear if you do it manually that may illuminate the true issue. I doubt it is IM but something is not setup properly in GP.
#1
André Arnaud de Cal...
294,453
Super User 2025 Season 1
#2
Martin Dráb
233,062
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
