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
7
votes
2 answers

Integrating with Great Plains, best way?

I can't find much information around the web about it. Has anyone used both eConnect and the Dynamics web services to interact (read/write) with Great Plains. I am looking for the pros and cons of both approaches. This product will be installed and…
pmlarocque
  • 1,704
  • 1
  • 18
  • 26
4
votes
1 answer

What are the similarities or differences between Dynamics CRM vs Dynamics GP (Great Plains)

I am doing research about integrating a product into Dynamics Great Plains. I have worked with Dynamics CRM before but not with Great Plains. I have heard that GP is a different animal than CRM, even though they share the same "Dynamics" prefix,…
7wp
  • 12,505
  • 20
  • 77
  • 103
3
votes
2 answers

Dynamics GP eConnect: get data (as opposed to create/update)?

I'm using eConnect to create and update various items in Dynamics GP, but I can't seem to find how to use it to read data from GP. For example, I'd like to get the Vendor and Account lists from GP. Is there a way to do this from eConnect? Do I have…
Parand
  • 102,950
  • 48
  • 151
  • 186
3
votes
1 answer

Great Plains eConnect Issue, FileNotFoundException... what am I missing?

I am trying to invoke a call to Dynamics Great Plains, and am getting a very frustrating error. I call the code: eConnectMethods eConCall = new eConnectMethods(); and I immediately trap the following: ERROR System.IO.FileNotFoundException: The…
Jeremy Holovacs
  • 22,480
  • 33
  • 117
  • 254
3
votes
1 answer

eConnect 10 Errors Numbers - how can I check what they mean?

I'm implementing Microsoft Dynamics eConnect 10 in a custom project, and while testing the EntryPoint method that's supposed to write to the ERP, it throws an exception when some data are missing or not entered correctly. The exception is…
Rami Alshareef
  • 7,015
  • 12
  • 47
  • 75
3
votes
0 answers

There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference

I am using eConnect SDK 11.0. I have a windows service app in which i had added reference of GP sdk. 1) Microsoft.Dynamics.GP.eConnect.dll 2) Microsoft.Dynamics.GP.eConnect.Serialization.dll When i build my project it had built successfully but gave…
Developer
  • 173
  • 2
  • 13
3
votes
5 answers

Generic Exception over webservices

I am integrating with MS Dynamics GP WebServices from C# and I am not sure how to handle exception. If I do a GetCustomer with a inexistant ID, the web services return me a "generic" SoapException and the message is "Business object not found." So…
pmlarocque
  • 1,704
  • 1
  • 18
  • 26
3
votes
1 answer

Dynamics GP Web Services: Limited?

I am writing an integration with GP web services for the first time and I am comparing the Receivables Transaction eConnect XML node to the ReceivablesInvoice and ReceivablesDocument WS objects. I cannot find properties on the WS objects for…
CodenameCain
  • 573
  • 1
  • 9
  • 22
3
votes
3 answers

Determine a customer's account balance via eConnect?

I work on a web application that uses eConnect to interface with Dynamics GP. Specifically, when orders are processed through our online store we submit invoices into GP using eConnect. Some of our customers are on account and their account balance…
Scott Mitchell
  • 8,659
  • 3
  • 55
  • 71
2
votes
2 answers

Microsoft Dynamics GP 10 WebServices using PHP

We are considering the use of Microsoft Dynamics GP 10 Web Services and will want to use PHP to create / update customers and sales... So the question is: Is this possible and if so does anyone know of good documentation out there? I am not finding…
Chad Smith
  • 177
  • 10
2
votes
1 answer

Dynamics GP Web Service -- Returning list of sales order based on specific criteria

For a web application, I need to get a list or collection of all SalesOrders that meet the folowing criteria: Have a WarehouseKey.ID equal to "test", "lucmo" or "Inno" Have Lines that have a QuantityToBackorder greater than 0 Have Lines that have…
PercivalMcGullicuddy
  • 5,263
  • 9
  • 46
  • 65
2
votes
0 answers

Object reference not set to an instance of an object while connecting Microsoft Dynamics GP 2018 with eConnect 18 using .net Framework 4.6.1

I have tried many solutions for this simple error but I couldn't find bug what actually cause it. Here is some code for reference. GPController [HttpPost("testConnection")] public bool TestConnection() { try …
Aarsh
  • 2,555
  • 1
  • 14
  • 32
2
votes
2 answers

All rows from Table in Database B and C, only unique rows from Table in Database A

I've got a requirement to select data from a table which exists in several databases which hinges on excluding duplicates in a specific way. The data is such that rows in databases B and C might contain the same Account Segment (SGMNTID) as rows in…
CodenameCain
  • 573
  • 1
  • 9
  • 22
2
votes
2 answers

Javascript text file encoding with Arabic and English for macro file

I am trying to export a text file using JavaScript to be used as macro for Microsoft Dynamics GP. The problem is Arabic letters don't render correctly when I try to use the macro in GP. For example "النسر" would render as "ط§ظ„ظ†ط³ط±" My JavaScript…
Y2H
  • 2,419
  • 1
  • 19
  • 37
2
votes
0 answers

Dynamics GP Web Service "System.UnauthorizedAccessException" while fetching Vendors

I am using Microsoft Dynamics GP 2013 Web Service to fetch All Vendors. But I always get System.UnauthorizedAccessException. I also added user to Web Service role assignment still same issue. My code looks like: DynamicsGPClient gpClient = new…
Rajesh Kumar
  • 471
  • 5
  • 14
1
2 3
9 10