tag:blogger.com,1999:blog-5285970135510371565.post6098154463264886858..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: IM - Integration Manager skipping records despite proper query relationshipsMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5285970135510371565.post-18199130250100081772017-05-16T01:07:05.291-04:002017-05-16T01:07:05.291-04:00Thanks a lot, your solution helped me figure out w...Thanks a lot, your solution helped me figure out why some of the orders imported by a GP integration were missing items. Cheers!!!!Anonymoushttps://www.blogger.com/profile/08294424728680276173noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-51792927711696446462012-02-05T14:03:58.184-05:002012-02-05T14:03:58.184-05:00Hi Mariano,
Just to let you know,this blog entry...Hi Mariano, <br /><br />Just to let you know,this blog entry was very helpful for me in resolving an issue I had with an Integration. <br /><br />Per one of your replies to a post on the Community boards, I needed to total the Debit Amounts to get a Total Purchase Amount for the integration. The only difference was I was using a *.csv source file. Per your instructions, I created 2 Advanced ODBC source adapters and built the integration in a test environment with no issues importing the transactions. <br /><br />The interesting thing is when I imported the integration in the Production environment, I kept receiving the error "The BATCH ID does not have a default value..." message. If you want details on the issue, you can read it here: http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/fdfb8fd6-6507-41f1-a73e-f6612142ba94/ <br /><br />So, even though the symptoms pointed to the source file (and how *.csv file have format issues in Excel), ultimately, the issue was the lack of the ORDER BY line in the SQL Statement in the Details source adapter. <br /><br />So, as always, thank you for the informative postings. They saved me hours of additional troubleshooting and having to use a ticket with MS Support.Lisa Sorensenhttps://www.blogger.com/profile/16353205488378787276noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-52956350298989168392011-03-22T08:53:17.427-04:002011-03-22T08:53:17.427-04:00@lnyere,
There are two .ini files: one for the IM....@lnyere,<br />There are two .ini files: one for the IM.EXE and the other for the IMRun.EXE. Make sure the two files are using the same settings for UseOptimizedFilter. If unsure, copy the IM.INI file and rename to IMRun.INI. <br /><br />Keep in mind I am simplifying the names as in v10 the files are Microsoft.Dynamics.*.ini.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-66961908353186683322011-03-22T06:31:06.895-04:002011-03-22T06:31:06.895-04:00Hi Mariano-
i'm getting this error message. we...Hi Mariano-<br />i'm getting this error message. we just upgraded to Dynamics GP 2010 from GP 9 and we started getting this error message.<br /><br />do you happen to know more about it. i've three sources all using queries and with the same ordering clause. verified data types and relationships, all looks fine.<br /><br />issue is, it was working but now throwing an error after the upgrade.<br /><br />you can email me at lnyere@gmail.com if you know something.<br /><br />regardsAnonymousnoreply@blogger.com