Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Mark Nelson 8/21/2015 3:07:11 PM

Integration Manager Import out of order

I am having a sorting issue after I run my integration. I have even modified the .ini with "UseOptimizedFiltering=False"

I have two sources:

Header and Detail both as TEXT.

The Header has sorting set as Order By BATCH ID; Group By Reference, Trans Date and Batch ID.

The integration imports from source however the source file is ordered and the entries after integration in the Transaction entry are in random order. I have verified that I do have FULL access perms to the IM database.

Would any scripting work? Any workaround possible?

Running GP 2010 SP 2 with IM 11.00.1767

Thank you


Version: GP 2010
Section: Integration Manager

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables