Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager er...
Microsoft Dynamics GP (Archived)

Integration Manager error.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi.

I'm trying to integrate a few items in the inventory table (IV00101). But I'm receiving this error. I don't get it!, of course they don't exist, that's the reason I'm trying to integrate them.

Can you help please?.

Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Object 'JM100001' does not exist -- cannot Update.
DOC 2 ERROR: Object 'JM100002' does not exist -- cannot Update.
DOC 3 ERROR: Object 'JM100003' does not exist -- cannot Update.
ERROR: Max Errors Exceeded at 11, Integration Canceled
ERROR: Integration canceled during document integration.
Integration Failed
Integration Results
    96 documents were read from the source query.
    11 documents were attempted:
        0 integrated without warnings.
        0 integrated with warnings.
        11 failed to integrate.

*This post is locked for comments

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Integration Manager error.

    Great to hear that ! 

    Let me know if you need any further assistance in Dynamics GP.


    Thanks Much
    Sandip

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager error.

    Guys, thanks. It worked, and from the bottom of my heart I love you guys, thanks, my boss was about to kill!. This means a lot to me.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager error.

    Hi guys, I'm going to try this one.

  • Verified answer
    Mick Egan Profile Picture
    Mick Egan 3,557 on at
    RE: Integration Manager error.

    Change the Inventory IM Integration "Destination Edit Mode" Properties to "Insert Only" and try again.

    Mick

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration Manager error.

    Hey thanks, take a look by yourselft, I managed to write some details everything fine for me. I guess...

    Insert Allowed: True.

    Update Allowed: True.

    Delete and open are: false.

    Duplicated keys allowed: false.

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Integration Manager error.

    Hi Freddy,

    On Integration Manager can you see what option you have selected is it 'Insert only', 'Insert or Updates' or 'Updates only'?

    I think you need to select 'Insert & Updates' option so if it found new record it will create otherwise it will update.

    Let me know how it goes.

    Thanks much
    Sandip Jadhav

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans