Skip to main content

Notifications

Announcements

No record found.

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

Integration Manager - SOP Invoices

(0) ShareShare
ReportReport
Posted on by Chris Flood 655

When I import a file containing 3 invoices into a batch in our live GP company (Version 11.00.1752), Integration Manager produces the following message and kicks me out of Integration Manager:

Microsoft.Dynamics.GP.IntegrationManager.exe has stopped working

Windows can check online for a solution to the problem

  • Check online for a solution and close the program
  • Close the program
  • Debug the program

The Integration will run if I replace the files I am using with the sample files then import the sample files into Fabrikam.

Regarding the records in the file I am attempting to import, each customer and item in the file contains the following information in GP.

Customers:

  • Customer ID
  • Customer Name
  • Customer Class
  • Address ID
  • Address info (Add1, Add2, city, state, zip)
  • Price Level

These customers are active and are not on hold

Items:

  • Item Number
  • Item Description
  • UOM Schedule ID
  • Default distribution accounts
  • Price List information for the items being imported (Applicable for all quantity of items 1 - 999,999,999,999)
  • Price Group
  • Default Selling UOM
  • Default Price Level
  • Price Level matches the price level on each record in the file
  • UOM matches the UOM on each record in the file
  • Currency ID = USD

The settings in Integration Manager are as follows:

  • If missing batch --> Create New
  • Over Credit Limit --> Override
  • Quantity Shortage --> Override Shortage

Do you have any ideas what Integration Manager may not like that is causing it to kick me out of GP and Integration Manager every time I attempt to import the file.

*This post is locked for comments

  • Suggested answer
    Chris Flood Profile Picture
    Chris Flood 655 on at
    RE: Integration Manager - SOP Invoices

    Although the Integration would run when imported to Fabrikam but not into the live company appears to be a setup issue within the company.  The cause of the failure was due to a product (Dynamics Advantage) active in the background that had not been used here for several years.  

    This was causing the integration to try and open windows in modules we don't use which was causing the integration to fail.

    Removing Dynamics Advantage from the Dynamics.set file on the machine the integration was being performed on allowed the integration to run to completion.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Integration Manager - SOP Invoices

    Chris,

    The fact you can run the integration into Fabrikam with no trouble, strongly points to a setup issue.  If I am ever stumped on an integration, I attempt to enter the data I am trying to import into the system manually.   This is often instructive as to what the core problem is.   Have you tried manually entering one of your test transactions by hand?

  • Chris Flood Profile Picture
    Chris Flood 655 on at
    RE: Integration Manager - SOP Invoices

    I can enter the transactions in the file. The only messages I receive are about exceeding the customer's credit limit and a quantity shortage message.

    I have override options for both of these in the integration.

    If I import the file into Fabrikam, the records are imported into a batch.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Integration Manager - SOP Invoices

    Whenever you run an integration through Integration Manager remember it goes through the same processes as if you typing the data in manually. If you have a field that is the deposit amount, then IM will try to open the deposit window on the SOP entry screen. Go into GP and try to enter a sample SOP with a deposit to see what it does. In this case there will be other required fields that need values.

  • Chris Flood Profile Picture
    Chris Flood 655 on at
    RE: Integration Manager - SOP Invoices

    I have simplified the integration to the minimum number of fields.  To rule out the possibility of this error being related to my machine, I ran this integration from another computer.  

    I was logged into the machine (network login) as the other user and logged into GP as the other user.  Using these credentials, the Integration ran, but failed with the following message

    DOC 1 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry' - Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'

    DOC 2 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry' - Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'

    DOC 3 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry' - Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'

    Integration Failed

    Integration Results

       3 documents were read from the source query.

       3 documents were attempted:

           0 integrated without warnings.

           0 integrated with warnings.

           3 failed to integrate.

    The GP user I was logged in as has less permissions than I do.  

    After this (While still logged into the other user's computer as the other person), I logged out of GP as the other user then logged into GP as my user.  When I ran the integration, it blew up and kicked me out of Integration Manager and GP.

    After this, I went back to my machine. While logged into the network as myself, I logged into GP as the ‘sa’ user and ran the integration. This also blew up and kicked me out of Integration Manager and GP.

    Both my user and the ‘sa’ user have Poweruser/full access to all functions in GP so it seems extremely unlikely that this failure/message is related to permissions for either GP user (myself or 'sa').  

    Do you have any ideas how I can run the integration from my machine.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Integration Manager - SOP Invoices

    One of the windows isn't modified or using a 3rd party dictionary is it? Have you turned on ShowDynamics in the IM.ini file? Are you using VBA on one of these windows?

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Integration Manager - SOP Invoices

    Sorry Chris, I misread your post.

  • Chris Flood Profile Picture
    Chris Flood 655 on at
    RE: Integration Manager - SOP Invoices

    The fields I listed are not in the file.  I was mentioning they exist in GP.  I stripped the original file to the minimum fields:

    Header

    • SOP Type - 3 (Invoice)
    • Customer Number
    • Document ID
    • SOP Number

    Items

    • SOP Number
    • Item Number
    • Quantity
    • Price
    • Price Level
    • Salesperson - blank
    • Territory - blank

    Distribution

    SOP Number

    • Account
    • Debit
    • Credit
    • Distribution Type

    v

    E

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Integration Manager - SOP Invoices

    Not sure Chris, but you could simplify the integration by eliminating the following fields:

    Customer Name

    Customer Class

    Address Info

    Item Description

    UOM Schedule ID

    Default Distribution Accounts

    Default Price Level

    Currency ID

    and letting these default in from your Customer and Item records.  You could be getting a conflict even though it appears there is none.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans