Questions tagged [dynamics-gp]

Microsoft Dynamics GP is one of several ERP (Enterprise Resource Planning, or accounting software) solutions offered by Microsoft under their Dynamics brand.

Microsoft Dynamics GP is one of several ERP (Enterprise Resource Planning, or accounting software) solutions offered by Microsoft under their Dynamics brand. The application was originally developed by Great Plains Software, of Fargo, ND, which was acquired by Microsoft in late 2000 / early 2001. The application is typically self-hosted, with the primary means of end-user interaction being a native Windows application which communicates via ODBC with a single instance of Microsoft SQL Server. Most of the business logic is embedded in the client application, and there is no "middle tier", or dedicated application server between the client(s) and the database. Extensions to the application (such as Microsoft Business Portal for Dynamics GP) extend the interaction surface to Microsoft SharePoint, SQL Server Reporting Services, and Microsoft Excel.

The application is a popular solution for what Microsoft refers to as "SMB" (Small and Medium Business) clients, and is positioned above applications such as QuickBooks, and below the ERP suites sold by (e.g.) Oracle and SAP. There is a rich ecosystem of applications and tools, both from Microsoft and ISVs (Independent Software Vendors) that extend the base offering.

Most development work related to GP involves customization of the application for specific clients/industries, reporting, business intelligence, and integration.

This tag should be used for:

  • any questions relating to the development of applications, integrations, and reporting solutions for Dynamics GP
  • questions about applications which directly extend Dynamics GP, such as eConnect, or Dynamics GP web services
  • questions about the underlying technology stack (such as Microsoft SQL Server, or SharePoint) as it specifically relates to Dynamics GP

More information about Microsoft Dynamics GP:

141 questions
1
vote
0 answers

GP web services or econnect to process payment against newly created sales invoice after payment gateway returns success

I have been working on a light weight shopping cart type system for one of our applications. I have the cart creating a sales invoice in GP through web service CreateSalesInvoice. Then I have code to interface with our payment gateway sandbox and…
user3075760
  • 23
  • 1
  • 6
1
vote
1 answer

How can I capture the newly created invoice Id (key) after GP web service call to CreateSalesInvoice

The web service offering for Dynamics GP has a call to CreateSalesInvoice. The problem I'm running into is the call returns void so I don't actually get the sales invoice object after completing the call. I can see the invoice is created in the…
user3075760
  • 23
  • 1
  • 6
1
vote
1 answer

Passing multiple line items with GP webservice

Below is the code I'm working with to pass multiple line items to create sales order through GP Web service. I can pass single Line Item without any problem , but when I pass multiple Items it is only taking the last one. The array has around 5 Item…
Developer
  • 245
  • 1
  • 15
1
vote
2 answers

Connecting to GP Web service throws exception

I'm trying connect to GP webservice to create sales order from C# application. But When I try to connect it is throwing exception as below. The application encountered an unhandled system exception. Contact your system administrator for…
Developer
  • 245
  • 1
  • 15
1
vote
1 answer

Microsoft Dynamics GP database Insert method

Can you please let me know the adapter/connector for inserting the data in to Dynamics GP database from Azure Logic Apps?
Vinoth
  • 79
  • 2
  • 11
1
vote
1 answer

GP Webservices and Adding Notes to Invoice

We use webservices to integrate our Dynamics CRM 4.0 with GP 10.0. We do alot of integration using GP webservices like creating invoices, customers and vendors. However, we just faced a problem. We need to use the web services to add some notes to…
mohammedn
  • 2,926
  • 3
  • 23
  • 30
1
vote
2 answers

Unit price is not updating while create items on eConnect

I was using eConnect to connect my .NET application to the Dynamics GP. This is my C# eConnect code to create/update an item on Dynamics GP. taUpdateCreateItemRcd GpLineItem = new taUpdateCreateItemRcd(); GpLineItem.ITEMNMBR =…
good-to-know
  • 742
  • 3
  • 15
  • 32
1
vote
0 answers

Trying to delete a Miscellaneous Log Entry via eConnect - possible

I have a snippet of code that creates one or more Miscellaneous Log Entries via eConnect. If the code fails to create an entry, then all successfully created entries should be deleted. E.g. (pseudo-code) List xmlDocs = new…
XBond
  • 236
  • 2
  • 10
1
vote
2 answers

Execute stored procedure with variable database name

So I have created a stored procedure that hits a Dynamics GP Vendor table. It needs to be able to hit the same table in different databases. One of the possible solutions I saw said to just execute a parameter with the query written as a varchar.…
QRiz
  • 41
  • 7
1
vote
1 answer

Sending Scheduled Emails with reports in Microsoft Dynamics GP

Is there a way to schedule emails that attach a SSIS web report or Smartlist report or excel report and send it automatically at a specified time within Microsoft Dynamics GP 2013? Thanks
Sinnerv
  • 263
  • 2
  • 6
  • 17
1
vote
1 answer

Communicating with Microsoft Dynamics GP Database and Project DataBase

I am coding in ASP.NET C#. I have Microsoft Dynamics GP hosted at a server and my database hosted at another server. I would like the GP database take value from some table there and synchronise it with my database. Which is the best…
naveen
  • 53,448
  • 46
  • 161
  • 251
1
vote
1 answer

405 Method Not Allowed - Dynamics GP 2010 Web Service

I am trying to access my client's GP 2010 web service, but I get this error: The request failed with HTTP status 405: Method Not Allowed. The URL is http://www.xyz.com:48620/Dynamics/GPService In Visual Studio, I see this URL in the add web…
Joseph Anderson
  • 4,114
  • 4
  • 45
  • 99
1
vote
1 answer

SSDT with large, retail databases?

I'm just getting my feet wet with SSDT because I'm excited about its source control and deployment capabilities. I'm working on an instance of Microsoft Dynamics GP which consists of a couple thousand tables, about 20k stored procs, etc. I won't be…
1
vote
1 answer

Great Plains query to get GL codes

I need to write a SQL query to extract GL information (codes, descriptions, associated company) from Great Plains. Is there a site that can describe what each table does, how they are linked, etc? Or even better a site with an available SQL query…
marcwenger
  • 439
  • 1
  • 7
  • 19
1
vote
1 answer

In Wix, how can I avoid hardcoding a file source for a file that already exists in the installation directory?

In my .wxs file, I have the following file declaration. This file already exists in the installation directory. It is not being copied from the source directory. I need to update it using util:XmlConfig during the install. The XmlConfig part is…
Chad Braun-Duin
  • 2,188
  • 2
  • 19
  • 26
1 2
3
9 10