web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Does eConnect have a new API for Dynamics GP 18.3?

(0) ShareShare
ReportReport
Posted on by 365

I upgraded Dynamics GP from 18.0 to 18.3.  We use eConnect for an integration with our parent company's requisition system.  The new values for the 1099 Tax Type and 1099 Box Number for the Nonemployee Compensation are failing in the integration.  I am wondering if there is a new API for eConnect that I should be using.  The error message is "Sql procedure error codes returned: ".  I've included the .xml file with the error message.TWGPUS_5F00_Vendor_5F00_TWGPUS_5F00_1_5F00_MYT10001_5F00_Error_5F00_ACK.XML

Categories:
I have the same question (0)
  • Nicole Hellerud Profile Picture
    1,712 on at
    RE: Does eConnect have a new API for Dynamics GP 18.3?

    Hi JBeck-

    Thank you for your post.

    There is not an updated eConnect in Microsoft Dynamics GP 2018 18.3.

    Is there someone in the community that could offer guidance on the specific error noted?

    Best Regards,

    Nicole Fiskum

    Support Engineer

    Microsoft Dynamics

  • ImAPilot Profile Picture
    70 on at
    RE: Does eConnect have a new API for Dynamics GP 18.3?

    Hi Nicole,

    I think you're mistaken - on the mdgpfall2020 dvd in the AdProd/eConnect/x64/updates directory, There is a windows installer patch (MicrosoftDynamicsGP18-eConnect-x64-KB4052501-ENU) that will update the .dll version from 18.2.xxx to 18.3.1175.0. We also experienced this same issue that jbeck reported.

    The error we are seeing is most likely caused by this new GP 18.3 change: docs.microsoft.com/.../form-1099-nec-now-supported for which there is a new value for Tax Type of 'Nonemployee Compensation' and a value of 5.

    I ran it up the flagpole with our partner, and the response from Microsoft is noted here: community.dynamics.com/.../non-employee-compensation-nec-for-1099-form that documents the above functionality change, and notes that the new 1099 NEC was not added to Integration Manager or eConnect.

    The recommendation provided was to handle it in an eConnect SQL pre procedure.

  • jbeck2014 Profile Picture
    365 on at
    RE: Does eConnect have a new API for Dynamics GP 18.3?

    Jeff,

    I tried installing the patch for eConnect from the mdgpfall2020 dvd, but eConnect is still at version 18.0.xxx.  I've asked our integration developers to try to handle the Nonemployee Compensation value of 5 in the eConnect SQL pre procedure.  I'll update you on the results of that when I hear back from them.

  • Verified answer
    ImAPilot Profile Picture
    70 on at
    RE: Does eConnect have a new API for Dynamics GP 18.3?

    I think from add/remove programs, the eConnect version shows 18.0.1016.000, but the file properties of the .dlls show version 18.3.1175.0. There may not have been any substantive changes to the code, but there at least was a new build. 

    pastedimage1607095106424v1.png

    As far as the workaround, I ended up implementing both a pre and post procedure (taUpdateCreateVendorRcdPre/Post). My quick fix is certainly not very elegant, but in our case, we only insert one combination of Ten99Type and Ten99BoxNumber, so this works.  With a bit more time, (absent a fix from MS), I would implement a temporary table to store the actual values sent in the pre-procedure, then restore them in the post procedure. 

    Since GP 18.3 eConnect throws an error either when not passing the parameters, or while passing new valid values, or old (GP 18.2) parameter values, I added these two lines to the pre-procedure:

    SET @I_vTEN99TYPE = 4
    SET @I_vTEN99BOXNUMBER = 1

    The post procedure then sets the new GP 18.3 values for the fields via direct SQL:

    UPDATE PM00200 SET TEN99TYPE = 5,
                                            TEN99BOXNUMBER = 1
    WHERE VENDORID = @I_vVENDORID
          AND TEN99TYPE = 4
          AND TEN99BOXNUMBER = 1

  • Suggested answer
    jbeck2014 Profile Picture
    365 on at
    RE: Does eConnect have a new API for Dynamics GP 18.3?

    I updated the pre and post stored procedures to handle the new codes for the Nonemployee Compensation.  Our integration is working successfully.

    Thank you for the suggestion for the workaround.

    Julie

  • MKAEC Profile Picture
    17 on at
    RE: Does eConnect have a new API for Dynamics GP 18.3?

    It's sad.  Microsoft likes to refute the rumors that Dynamics GP is dying, but then they do things like refuse to update the eConnect API and move Management Reporter into maintenance-only mode.  Updating eConnect should have been a natural part of adding the 1099-NEC support.

  • ImAPilot Profile Picture
    70 on at
    RE: Does eConnect have a new API for Dynamics GP 18.3?

    Just an update that we installed the latest GP service pack 18.3.1233 released in late January, 2021, and the issue is not yet fixed. This remains a breaking change to the eConnect vendor insert function.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 857 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 548 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans