I am working on a new integration for a customer who is on Dynamics GP 10.00.1841 and Integration Manager 10.00.1617. The new integration will import GL Transactions including AA codes.
I followed the KB article support.microsoft.com/.../2687958 and have verified that I can manually enter the transaction directly into GP.
When I run the integration, it says it completed successfully and a GL transaction is created in GP, but no other info is actually imported into GP.
I also followed the steps at dynamicsgpblogster.blogspot.ca/.../integration-manager-integrating-journal.html to get the next journal entry number with no change in results.
As I was initially creating the integration on a separate computer from the SQL Server, I thought that maybe not having MSDTC installed was causing the issue, but when I tried the integration from the SQL Server, I still get no data imported into the journal entry.
I checked the logs and do not see anything that seems related.
My suspicion is that the eConnect adapter is not working for me. I have specified a domain user account in the eConnect COM+ Properties window and confirmed that it is a member of the DYNGRP role in SQL for the DYNAMICS and company databases.
Any ideas of things to check or that I may be missing?
Thanks,
Peter
*This post is locked for comments
With assistance from a coworker we found that the issue was that the Source Recordsets on the Options tab for each level were set to Use Default. After updating these to the specific source recordsets for each level, the integration worked properly.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156