You’re offline. This is a read only version of the page.
75,730
I have used Integration Manager for decades and have never had the problems I am having with the GP 2013 version. I am currently working on importing 14 years worth of sales transacitons. As the years get more current there are more and more sales orders per year. As the number of sales orders has grown past 4,000 I started getting messages about duplicate invoice numbers. These were bogus messages. When I went in to look at one of these I discovered what IM did was insert a record into the SOP10100 table that only had the SOPNUMBE and SOPTYPE and SOPDATE fields populated. Everything else was blank. So I have since started breaking the years in half and the imports work just fine on the same dataset. Which, by the way, is a set of SQL queries. I have tried changing the setting on the UseOptimizedFiltering and that has not helped. IM just seems to have trouble with large data sets with sales transaction entry. Has anyone else experienced this?
*This post is locked for comments
Thanks Lorren, I am waiting for someone at eOne to get back to me to see if we get a copy of Smart Connect as part of reseller agreement.
Richard, I was able to apply a single payment to multiple invoices and multiple payments to a single invoice with Smart Connect. Hope that helps.
Lorren
Lorren, I jsut came across something is was not expecting. There are occassions where one check covered multiple invoices so I configured IM to handle the apply correctly. Howewer, I have now seen where one invoice may have been paid with multiple payments. IM did not handle this correctly. It applied the full amount to the first invoice. I am going to re-run the integration and change the apply rule to not appy all but specify the actual amount. Do you know if Smart Connect would handle this correctly?
What a maroon I can be. I totally forgot about Smart Connect. I will shoot them an email and see if there are any deals for resellers.
Richard, I am biased of course but you could use Smart Connect to import those invoices, cash receipts and apply them.
Lorren
Jonathan, I have 15 years of historical sales invoices to import. I break up the integration into yearly chunks. As I get to more recent years there may be 5,000 invoices in one year. Would that be considered to large for IM? It would be too costly to write custom code just to migrate from one ERP to GP, hence the use of IM.
If you have eConnect installed you can find them here:
C:\Program Files (x86)\Microsoft Dynamics\eConnect 11.0\XML Sample Documents\Incoming
Jonathan, where can I find an example of Sales Order import using eConnect? I use VS 2010 C#
Richard remember that IM was never designed to handle large data sets. Really you should look at using Web Services or eConnect otherwise the workaround is to do lower amounts like you mentioned.
So the header record is created as a place holder waiting for the remainder of the header record. I assume as lines are added the totals are adjusted. Out of about 45,000 sales orders I am going see this happen two dozen times. Once all the years are integrated I will compare what is in the import tables to what showed up in GP. I need to get them all correct because the next step is importing the cash receipts applied to those invoices.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (