Integration Manager error.

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Mick Egan 3,561 on at

Like (0)

Report

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

Mick

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

Great to hear that !

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

Thanks Much
Sandip

Was this reply helpful? Yes No