Stack Overflow
Stack Overflow

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

Soap connection from PHP to Microsoft WS

I need the equivalent of the following for PHP System.Net.NetworkCredential credential = new System.Net.NetworkCredential("administrator", "PASSWORD", "DOMAIN"); wsDynamicsGP.Credentials = credential; DynamicsGPWebService.Policy apPolicy…
brentwpeterson
  • 162
  • 2
  • 9
2
votes
1 answer

eConnect timesheet entry multicurrency issue

I'm trying to use econnect to insert TimeSheet Entry batches from an external system via "taPATimeSheetLineInsert". When using the fuctionnal currency everything works fine. The problem is that when I use another currency, the ACCRUED REVENUES are…
Hugo Emond
  • 21
  • 1
2
votes
1 answer

GP proc only executes 42 transactions - Dexterity call to a SQL Procedure contains cursor

I am having issue with calling a SQL procedure from dexterity. The procedure contains cursor. This cursor is suppose to call another procedure which has a call to Dynamics GP Procedure 'taComputerChecklineinsert'. The working is supposed to be that…
msgpdev10
  • 31
  • 4
2
votes
0 answers

Using eConnect from Excel

I'm trying to get our database in Dynamics GP updated automatically using eConnect. I -could- just interact with SQL Server directly using ADO however I like the rollbacks and validation eConnect provides. I tried to reference the eConnect's dll…
Select Case Beer
  • 83
  • 1
  • 8
2
votes
0 answers

System.Web.Services.Protocols.SoapException The application encountered an unhandled system exception. From binary file

I have a project in .net that accesses a GP Web Services, it works fine. However when I generate a dll from this project and try to run the same from a different project using this dll, I get the following message:…
Rafael
  • 1,099
  • 5
  • 23
  • 47
2
votes
1 answer

Create your own Web Service on top of Dynamics GP eConnect?

I am new to C# development and to eConnect and Web Services for Dynamics GP. From some sources I have picked up the notion that Web Services is somewhat limited in its functionality and sometimes it is necessary or desirable to build one's own web…
CodenameCain
  • 573
  • 1
  • 9
  • 22
2
votes
1 answer

eConnect configuration to integrate data to GP

We need to integrate data from our application to GP using eConnect. We have GP and eConnect installed in a server.Our application runs from another machine which has to send data to GP in our server using eConnect. Is that necessary to install…
Ramya
  • 121
  • 2
  • 7
  • 13
2
votes
1 answer

How do I Return an Invoice in Dyamics GP through eConnect or Web Services?

We have invoice documents in GP 10.0. Recently, the accounting department has decided that when the incorrect client has been billed, we will return the invoice and create a new one. (Previously, we would issue a credit memo to the wrong client…
Pete
  • 3,991
  • 3
  • 31
  • 30
2
votes
1 answer

SOAP Exception when trying to Access GP WebServices

I am trying to write a program that simply connects up to a GP WebService and invokes it's GetCustomerList() method to get customers from Great Plains. The code I am outlining below is an duplication of what I was able to find in the documentation,…
bkorzynski
  • 541
  • 1
  • 5
  • 15
1
vote
1 answer

VBA type mismatch error

I have no clue what this is. Apparently it has to be some syntax error of some sort but I can not figure out what it is for the life of me! All I am doing is save data into a table in SQL Server 2008 and I am using vba in microsoft dynamics great…
javasocute
  • 648
  • 2
  • 11
  • 28
1
vote
0 answers

SQL query to match payments to invoices in Microsoft Dynamics GP (Great Plains)

How do you match payment information from an external source to invoices in Microsoft Dynamics GP (Great Plains)? I found this post, but it doesn't go into detail about the actual query to use: http://dynamicsuser.net/forums/p/36640/189486.aspx
user916863
  • 11
  • 2
1
vote
1 answer

MSMQ Transaction with COM (python)?

I'm attempting to use MSMQ from Python using the win32com library, similar to this example. I'm able to put messages onto the queue, but in this case it's a transactional queue, so I need to create a transaction around the message send. Basically…
Parand
  • 102,950
  • 48
  • 151
  • 186
1
vote
0 answers

GP Web Services - Creating Item - Won't accept item Type

I'm attempting to build a form for creating items in GP and running into one issue, no matter what value I set for the item type it gets put into the database (IV00101.ITEMTYPE) as 1, which is sales inventory. Is there anything that can be done to…
Ryan Raten Kuhar
  • 115
  • 1
  • 9
1
vote
1 answer

How to export SmartList Definition?

I just want to export SQL Query of the SmartLists for backing up and transfer to other system. Is any way to do so?
Richard Sayakanit
  • 695
  • 6
  • 12
1
vote
1 answer

eConnect to Great Plains Error: 'Timeout expired' - How to fix?

Receiving the following error when trying to pull reconciled orders from the last 30 days in Great Plains from a SOAP call: ServerSystem.Web.Services.Protocols.SoapException: Server was unable to process request. --->…
Kevin
  • 13,153
  • 11
  • 60
  • 87
1
2
3
…
9 10