web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager - ...
Microsoft Dynamics GP (Archived)

Integration Manager - Sorting Issue with General Journal Entry

(0) ShareShare
ReportReport
Posted on by Community Member

After looking through this forum's posting for a solution, this appears to be an unresolved issue for a couple of users at least. Here goes:

My journal entry is as follows:

DB - 7780-PB-018-0000-0000 $18.00

CR - 7790-ED-028-0000-0000 $18.00

The financial general journal comes out as -

CR - 7790-ED-028-0000-0000 $18.00

DB - 7780-PB-018-0000-0000 $18.00

The steps given by the GP technician did not solve the sorting issue. Here they are:

1. Open Windows Explorer and go to C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 10\

2. In Notepad open Microsoft.Dynamics.GP.IntegrationManager.ini

3. Change UseOptimizedFiltering=True to UseOptimizedFiltering=False

4. Save and close Notepad, then restart Integration Manager

I made the change from True to False and as a result got this error message:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

DOC 1 ERROR: Error Executing Script 'Entries.Account Number' Line 5:

DOC 1 ERROR: Null value not allowed for field 'Entries.Account Number'.

Integration Failed

Integration Results

    1 documents were read from the source query.

    1 documents were attempted:

        0 integrated without warnings.

        0 integrated with warnings.

        1 failed to integrate.

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mark Stenseth Profile Picture
    Mark Stenseth Microsoft Employee on at

    Hello Fred,

    Thank you for using Online Communities.

    The UseOptimizedFiltering setting of False will work as long as you do not have any Order By on the Properties of the Source Query. The Order By will override the UseOptimizedFiltering Setting.

    Please reveiew KB924857 Integrated records are not sorted in the same order in which the records are sorted in the source file in Microsoft Dynamics GP 9.0

    support.microsoft.com/.../en-US

    Please let me know how this goes.

    Thanks

  • Community Member Profile Picture
    Community Member on at

    Remove any Order By clause that you have set for all of your queries.  - Hi, Mark, Thank you for your answer.  Where is this Order By clause located?

  • Suggested answer
    Mark Stenseth Profile Picture
    Mark Stenseth Microsoft Employee on at

    Hello Fred,

    The Order By is located in the Properties of the Source Query for the Intergation in the Sorting Tab.

    If you have any columns in the Order By, they will need to be removed. The easiset way to remove them is to click on the Column Name and the hit the Delete Key on the Keyboard. Once you have the Columns deleted, click Apply, then OK.

    Try this and let us know how it goes.

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    Hi, Mark,

    I don't have any "Order By" columns and I checked everywhere in Integration Manager.  Below is the fix using GP 10

    "Microsoft Dynamics GP 10.0

    To resolve this problem, change the UseOptimizedFiltering value to False. Remove any Order By clause that you have set for all of your queries. You must exit Integration Manager and then start Integration Manager for the new setting to take effect.

    Note When you rename the Microsoft.Dynamics.GP.IntegrationManager.ini file, the UseOptimizedFiltering value reverts back to the default value. The default value is True.

    The integration now sorts by the source file. For the sort to be the same when you use the Microsoft.Dynamics.GP.IntegrationManager.IMRun.exe file, make a copy of the Microsoft.Dynamics.GP.IntegrationManager.ini file, and then rename it as Microsoft.Dynamics.GP.IntegrationManager.IMRun.ini. After you do this, the sort will run the same way."

    The above is not step by step.  So if I were to order the steps, would it be:

    1) Change the Used Optimized Filtering value to False

    2) Exit Integration Manager

    3) Rename the Microsoft.Dynamics.GP.IntegrationManager.ini file  - Rename it to what?  Rename it to Microsoft.Dynamics.GP.IntegrationManager.IMRun.ini. after copying it?

    Regards,

    Fred

  • Suggested answer
    Mark Stenseth Profile Picture
    Mark Stenseth Microsoft Employee on at

    Hello Fred,

    You are correct. The steps you laid out will work.

    You after you create a copy of the Microsoft.Dynamics.GP.IntegrationManager.ini file, the new file would need to me renamed to Microsoft.Dynamics.GP.IntegrationManager.IMRun.ini.

    This will allow the UseOptimizedFiltering to work the same when you open IM and run from the shortcut on the desktop or if you Run IM from the GP Menu.

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    Okay, I made the changes and the Integration process ran without errors.  BUT the ED is still sorted before the PB in the journal entry.  

    Where exactly do I find the properties of the source query in Integration Manager?  I am still still uncertain about that.  Can you give me a step by step in order to find it?  No Order by would not be a field in a Financial General Entry, would it?  So should I still look?  I wish there was a way for you to provide screen shots.

  • Mark Stenseth Profile Picture
    Mark Stenseth Microsoft Employee on at

    Hello Fred,

    The Properties of the Source Qeury are when you double click the Source Query or when you right click the Source Query then choose Properties.

    More information on this can be found in the IMUSerGUide.pdf located in the IM directory. For example, mine is located here: C:\Program Files (x86)\Microsoft Dynamics\Integration Manager 11\Help\Documentation

    As long as you have the setting correct in the .ini file and there is not any order by, there is no reason this should not work. You may want to verify that the location IM is being run has the correct .ini file being edited.

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    It finally dawned on me what you mean by order by.  

    Here goes:

    In the general journal header properties the technician entered an asterisk in the order by section.

    In the general journal transactions properties the technician entered an asterisk in the order by section.

    Let me know if this needs modification.

    Regards,

    Fred

  • Suggested answer
    Mark Stenseth Profile Picture
    Mark Stenseth Microsoft Employee on at

    Hello Fred,

    Both of those Order By's need to be removed in order for the UseOptimizedFiltering ot work as expected. I am not sure why there is an asterisk in theere, but it needs to come out.

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans