Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[David Morinello]

I have been moving Integration Manager 2013 integrations to 2018 and have one pair of integrations that hang in 2018.  The same Integrations work ok in 2013

I then built them from scratch and they still fail. I uninstalled IM and reinstalled, same issue.

GP 2018 R2 18.00.0727

I narrowed it down to a script in Mapping. If the script exists, it fails. No script it works but the expected custom distributions are incorrect. 

Event Log

*****************************

The program Microsoft.Dynamics.GP.IntegrationManager.exe version 18.0.641.0 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel.
 Process ID: e20
 Start Time: 01d9420f758e77dd
 Termination Time: 4294967295
 Application Path: C:Program Files (x86)Microsoft DynamicsIntegration Manager 18Microsoft.Dynamics.GP.IntegrationManager.exe
 Report Id: df6b75db-ae02-11ed-abcc-06f66a63a338
 Faulting package full name: 
 Faulting package-relative application ID: 

*****************************

Thought, comments?

——————————
David Morinello
Senior Developer
TruckPro LLC
Cordova TN
——————————

[Chris Donnelly]

Can you share the contents of the script?  I bet there is a connection to another dataset that doesn’t match your GP2018 data (i.e. your GP2013 data).

Chris

——————————
Chris Donnelly
Director of Business Applications
Healthmark Industries
——————————
——————————————-

[David Morinello]

Below is the Script for the Debit Integration. 

The Credit script is the same except for the first line.

Account = trim(SourceFields(“CM Receivables-Header.GL Account”))
Store = left(SourceFields(“CM Receivables-Header.Customer ID”),3)
Distribution = “”

***Debit  Distibution Script*********************************************************************************

Account = trim(SourceFields(“_DM Receivables-Header.GL Account”))
Store = left(SourceFields(“_DM Receivables-Header.Customer ID”),3)
Distribution = “”

Select Case Account
Case “1INT”
    Distribution = “800-000-13400”
Case “BDR”
    Distribution = Store + “-000-13410”
Case “BDRF”
    Distribution = Store + “-000-13410”
Case “BDWO5”
    Distribution = Store + “-000-13410”
Case “BDWO”
    Distribution = Store + “-000-13410”
Case “BDWOC”
    Distribution = Store + “-000-13410”
Case “BDWOB”
    Distribution = Store + “-000-13410”
Case “BDWOD”
    Distribution = Store + “-000-13410”
Case “CAR”
    Distribution = Store + “-000-10000”
Case “OS”
    Distribution = Store + “-010-51020”
Case “CCRA”
    Distribution = “800-000-10311”
Case “CCRD”
    Distribution = “800-000-10312”
Case “CCRVM”
    Distribution = “800-000-10313”
Case “CHGB”
    Distribution = “800-000-13404”
Case “CHGBWO”
    Distribution = Store + “-000-13410”
Case “CODR”
    Distribution = Store + “-000-13410”
Case “CODWO”
    Distribution = Store + “-000-13410”
Case “CE”
    Distribution = Store + “-000-13410”
Case “CORER”
    Distribution = Store + “-000-13410”
Case “CORWO”
    Distribution = Store + “-000-13410”
Case “CW”
    Distribution = Store + “-000-13410”
Case “DC”
    Distribution = Store + “-010-44707”
Case “DELC”
    Distribution = Store + “-000-13402”
Case “DELR”
    Distribution = Store + “-000-13402”
Case “FR”
    Distribution = Store + “-010-54750”
Case “FSC”
    Distribution = Store + “-010-38100”
Case “IMPRT”
    Distribution = “800-000-10215”
Case “INV”
    Distribution = Store + “-000-14200”
Case “MC”
    Distribution = Store + “-000-13400”
Case “NSF”
    Distribution = “800-000-13405”
Case “NSFR”
    Distribution = Store + “-000-13410”
Case “NSFSC”
    Distribution = Store + “-000-13410”
Case “NSFWO”
    Distribution = Store + “-000-13410”
Case “SC”
    Distribution = “800-870-51500”
Case “SCR”
    Distribution = Store + “-000-13401”
Case “TE”
    Distribution = Store + “-000-13400”
Case “TX”
    Distribution = Store + “-000-23600”
Case “ZOFF”
    Distribution = “800-000-13400”
Case “ZSR”
    Distribution = “800-000-10431”
Case Else
    Distribution = Store + “-000-13410”
End Select

CurrentField = Distribution

*****************************************************

——————————
David Morinello
Senior Developer
TruckPro LLC
Cordova TN
——————————
——————————————-

[Chris Donnelly]

Hmmm.  No connections.  Are your input files still named CM Receivables-Header and _DM Receivables-Header?

Chris

——————————
Chris Donnelly
Director of Business Applications
Healthmark Industries
——————————
——————————————-

[David Morinello]

Yes

——————————
David Morinello
Senior Developer
TruckPro LLC
Cordova TN
——————————
——————————————-

[Chris Donnelly]

Cool.  Next thing…   look at the file definitions (ODBC on the machine?)…   Is the column named “Account” defined as a numeric?  It should be defined as a string.

Chris

——————————
Chris Donnelly
Director of Business Applications
Healthmark Industries
——————————
——————————————-