Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

eConnect Help Requested

Posted on by 355

Hello,

I am writing to request help with eConnect (version 11.0, SP2, along with Visual Studio Pro 2013 and Dynamics GP 2010 SP2, build number 11.00.1914).  When I create a customer or a general ledger entry via C#, the data goes into the Great Plains SQL Server tables but doesn’t show up in the Great Plains application (the Customer Maintenance or Batches screens).

After turning on tracing via the Microsoft.Dynamics.GP.eConnect.Service.exec.config file, neither the Event Viewer nor the eConnect.log and eConnectSvc.log files registered any errors. The code I used for creating and inserting the new customer came right out of the eConnectSamples/CSHARP Console Application folder (with the exception of changing the connect string to point to our test environment’s Dynamics GP server.)

I’ve gone through both the programmers guide and the admin/install guide but have not been able to fix the issue.  I would be grateful to anyone who could help.

Thanks in advance for any suggestions or assistance.

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect Help Requested

    Hi Tommy,

    If it is test or Live, we need to track the cause of error through event viewer. for every integration process, activity need(s) to be tracked.

    Custom event log need to created to display the error status and integrated status. so that we can know the status of the integration.

    if the test environment has development tools as VS, then you can do the debug the process once you received the error.

  • Tommy G Profile Picture
    Tommy G 355 on at
    RE: eConnect Help Requested

    Hi Somakarpagamoorthy,

    Thanks for your advice.  We ended up having a discrepancy between our testing and production environments.  When this was discovered and corrected, eConnect ran just fine.

    Regards,

    Tom

  • Tommy G Profile Picture
    Tommy G 355 on at
    RE: eConnect Help Requested

    Hi Nataraj,

    Thanks for your response and offer to help.  As it turns out, we had a difference between our testing and production environments.  When this was discovered and corrected, eConnect ran just fine.  Regards,

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: eConnect Help Requested

    If the data's goes into SQL server GP database, surely the record will shows in GP application as well (eg: Customer Maintenance).

    Have you checked the SQL server instance for GP database in c# coding?

    Have you logged into GP with instance which is passed via c#?

    Also run the below query against your company database in SQL.

    SELECT * FROM RM00101 WHERE CUSTNMBR ='Enter the customer number which you have pass via c#'

    Hope this helps!!!

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect Help Requested

    Hi Tommy,

    Did you pass all the mandatory fields?

    Have you inserted a break point at the start and make sure what happen during debugging? mostly during break point you mostly hit with an idea about the issue.

    if you get with any error, make sure the corresponding version  of eConnect reference get attached.

    also make sure the eConnect service is running during the integration.

    if the above this properly configured then please share your code?  The community members gone through this post will ready to help you.

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