Does eConnect have a new API for Dynamics GP 18.3?

(0) Share

Report

Posted on by jbeck2014

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:

Microsoft Dynamics GP

All responses (7)

Answers (1)

ImAPilot 70 on at

Like (0)

Report

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.
MKAEC 17 on at

Like (0)

Report

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.
Suggested answer

jbeck2014 365 on at

Like (0)

Report

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
Verified answer

ImAPilot 70 on at

Like (0)

Report

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.

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
jbeck2014 365 on at

Like (0)

Report

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.
ImAPilot 70 on at

Like (1)

Report

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.
Nicole Hellerud 1,712 on at

Like (0)

Report

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