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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / General C# integration...
Microsoft Dynamics GP (Archived)

General C# integration question

(0) ShareShare
ReportReport
Posted on by LordSupafly 215

I need to create an integration app that transfers data from our C# app to GP.  According to the documentation, it appears I should use the 'Visual Studio Tools'.  Unfortunately, most of the samples and documentation seem to be for creating new forms and functionality INSIDE GP.  I need to perform activities like updating vendor info, creating invoices, etc, programmatically.

Is this even possible?  And can I use an API to access objects?  Or am I going to be stumbling around with SQL trying to find the right table for the next 2 months?  What's the best way to go about it?

Thanks to anyone that can point me in the right direction!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Use can use VS C# to write directly to the tables which means you do need to get familiar with the GP tables structures or you can use VS C# to write to GP using eConnect  which will make coding a bit easier plus allow for greater data verification as eConnect will fill in a lot of the static values for you. There are sample C# examples in the VS Toolkit plus eConnect examples. Search CustomerSource and you will find them.

  • Suggested answer
    Steve Kubis Profile Picture
    Steve Kubis on at

    You'll want to use either eConnect or Web Services. Use the following whitepaper to help you decide which development tool for Microsoft Dynamics GP would be best for the tasks you need to perform:

    www.microsoft.com/.../details.aspx

    Steve

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    I totally agree with Steve and Richard on using eConnect or Web Services for this. The last thing you want to start doing is writing to GP tables directly. This method of integration is not supported by Microsoft.

  • LordSupafly Profile Picture
    LordSupafly 215 on at

    Thanks everyone for your input.  I'll definitely go the direction of the eConnect with .NET.  I need to get access to the CustomerSource website.  The person that handles Great Plains hadn't heard of it before, but I asked her to sign up so I can download that eConnect SDK.

    I appreciate your help!

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans