Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sort Order of Debits & Credits from Integration Manager to GP

Posted on by Microsoft Employee

If anyone can help with the sort order of Journal entries importing into GP from Integration manager. I am using an excel spreadsheet which has all journal entries for the month grouped into individual entries. I have the integration set up to group into separate entries which works fine, but when items are loaded into GP the Credits show up first and the debits show up second which we would like to have the Debits show up first in the entry for ease of viewing. Any ideas on how to correct this? 

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Sort Order of Debits & Credits from Integration Manager to GP

    The OptimizedFilter switch should not affect your integration at all, it is meant to only stop any sorting criteria.

    Are you sure you have only switched the OptimizedFilter only and had this result ?

    Keep us posted,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sort Order of Debits & Credits from Integration Manager to GP

    Now it doesn't import any lines into the journal entries, just each entry separate with the description but there are not any accounts or values?

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Sort Order of Debits & Credits from Integration Manager to GP

    In order to import the journal entries using the same order in the CSV file, you need to go to Microsoft.Dynamics.GP.IntegrationManager.ini file usually located on the following path (C:/program files/dynamics/Integration Manager), check that the following should be "false"

    UseOptimizedFiltering=False

    Additionally, ensure that there is no sorting on the properties of the source query. 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans