Open Forum

Expand all | Collapse all

Integration Manager error

Jump to Best Answer
  • 1.  Integration Manager error

    GPUG ALL STAR
    Posted Feb 05, 2020 12:58 PM
    So I've run into an error which I've never seen before and can't seem to find any information on.  I'm hoping someone here can chime in and tell me what is going on.

    We have an online retail site from which we are trying to perform an ETL and integrate in as invoices into Dynamics GP.  The company is set up with Manufacturing and Willoware which is supposed to help turn orders into manufacturing orders, etc. but I don't know if that's actually involved or not.  (My suspicion says it is.)  We imported a batch of online sales (as invoices) a month ago, but that was before we really had a lot of the manufacturing stuff set up and running.  I haven't changed anything since the last go, yet now I'm receiving the following critical error (meaning that the integration fails) for every document:

    Opening source query...
    Establishing source record count...
    Beginning integration...
    DOC 1 ERROR: You can update the In-House due date, but dates for existing manufacturing orders won't be updated.
    DOC 2 ERROR: You can update the In-House due date, but dates for existing manufacturing orders won't be updated.
    DOC 3 ERROR: You can update the In-House due date, but dates for existing manufacturing orders won't be updated.
    ...
    ERROR: Max Errors Exceeded at 11, Integration Canceled
    ERROR: Integration canceled during document integration.
    Integration Failed
    Integration Results
    57 documents were read from the source query.
    12 documents were attempted:
    0 integrated without warnings.
    1 integrated with warnings.
    11 failed to integrate.

    I can't find any information on this error and which field it is complaining about.  (I think it could be the Requested Ship Date, but I'd like confirmation.)  I'd certainly appreciate any help.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Integration Manager error

    TOP CONTRIBUTOR
    Posted Feb 06, 2020 08:52 AM
    Blair,

    I have a hunch...   is the inventory item setup as "Make to Order - Silent"?   cards > inventory > item > goto > item engineering data > Fulfill. Method

    Chris

    ------------------------------
    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Integration Manager error
    Best Answer

    GPUG ALL STAR
    Posted Feb 06, 2020 10:04 AM
    Thanks for the suggestion, but that setting is blank.

    I actually did figure it out with the help of @Sunny Mattoon.  For some reason, the integration was dying because the Requested Ship Date was being set at both the Header and the Detail levels on the invoice.  As soon as I took the data import on the detail/item off, they integrated.  (What's really weird is that the base data doesn't break this out - the Requested Ship Date is the same date at both the invoice and item level.)​

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role