web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

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

Integration Manager and GL Transactions

(0) ShareShare
ReportReport
Posted on by Todd Reddinger 140

We are combining two companies into one and I am having a problem.

When using integration manager to pull in a month of GL to the new company the accounts and debits and credits are blank for day 10 to the EOM. If I split the batch into day 1-9 and 10-EOM then both batches are OK.
But it consistently messes up from day 10-EOM when trying to pull in the entire month. Using eConnect version.

We are running Dynamics v10.00.1061 and IM v10.00.1384

Has anyone else run into this and did you find a fix?

Thanks in advance

Todd

*This post is locked for comments

I have the same question (0)
  • Todd Reddinger Profile Picture
    Todd Reddinger 140 on at
    Re: Re: Re: Re: Re: Integration Manager and GL Transactions

    It is a fix but, I still think they need to look at the eConnect procedure that is being used. It seems that when it changes from a single digit day to a 2 digit day it starts skipping the distributions. That is what was very consistent. I have no special characters in the table. This has happened to a co-worker who also works with GP and integration manager and it was exactly the same, day 9 to day 10 and the distributions are gone. He simply split it up into two batches and gave up.

    Victoria, I checked the short date settings and they are the same. 

    Thanks for listening.

    Todd

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Integration Manager and GL Transactions

    Great stuff Todd. Thanks for posting the MS response. One to remember for the future...when all else fails, switch off UseOptimisedFiltering...

    Best regards,

  • Todd Reddinger Profile Picture
    Todd Reddinger 140 on at
    Re: Re: Re: Integration Manager and GL Transactions

    I ended up calling microsoft on the issue and I am including their response which did fix the problem. I have looked through my data and found no unusual characters so I am not exactly sure what this setting is doing. To answer the other question, the header for days 10-EOM are there, just no distributions.

     ASSESSMENT:
    ==================================
    Thank you for taking my call and streaming today. We reviewed your integration and your SQL table you are pulling data from. We saw that you have the relationship and the Group bys set on Journal ID, Batch ID, and Trx date.

    We verified that your version of GP is 10.00.1061 and your version of IM is 10.00.1384.
    We queried the table and saw you have 2,200 journal entries and approximately 19,000 rows of distributions.

    We narrowed down the SQL table to only the days 9 and 10 and were able to recreate the issue.
    We then changed your Useoptimizedfiltering from True to False.
    This resolved the issue.
    As discussed this setting, when set to true will speed the integration as it ignores any sorting you have on the integration. There is limited information on this setting so if we suspect an issue with an integration such as this issue we generally at least test changing that setting and running the integration again.

    When setting UseOptimizedFiltering to False, the integration becomes a lot less particular about your source file. With it set to True, the source file must be exact and have no special characters (&^%$#@!~, etc) or it won't see the relationship as valid. You were using one SQL table for your queries so this may be due to special characters within the distribution reference field or possibly the column header itself.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: Re: Integration Manager and GL Transactions

    Also not sure I can help without actually seeing the data and the setup...however one thing that comes to mind when I hear that something breaks after day 9 is to check the Short Date format in the Regional Settings on the computer where you are running IM and compare it to what the SQL Server Short Date setting is. 

  • Community Member Profile Picture
    Community Member on at
    Re: Integration Manager and GL Transactions

    Hi Todd,

    Not sure I can help, but your post has been unanswered for a while, so...

    If you run a full months transactions, does the journal get created in GP?

    If it gets created is it the case that you get lines with accounts and amounts for the first 9 days...and then lines with just accounts for the remainder days up to EOM?...or what? (I think from your post that if you integrate a full month, onle th first 9 days get created...and this is all that comes into the journal).

    Ian.

     

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans