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
1
vote
1 answer

SQL trace in Great Plains shows Invalid column name 'desSPRkmhBBCreh'

This error seems to just pop up now and again. It is not restricted to a single table and even happens on tables it just created. Anybody else see this weird behavior? [Edit w/solution] It turns out that this query is used to determine if the…
Craig
  • 11,614
  • 13
  • 44
  • 62
1
vote
1 answer

MS GP eConnect create EFT Bank

Simply trying to create via eConnect the EFT Bank informations on a customer. You go inside a customer - > address - > EFT Bank. I cannot find any informations in the eConnect documentation or on the web of the correct method to use. Trying my…
pmlarocque
  • 1,704
  • 1
  • 18
  • 26
1
vote
2 answers

SQL Right Join?

Arrrgh, I am not getting this. I have a table of accounts from Dynamics GP that has 7 columns. I need to fill in the blank months for accounts that didn't have any activity for a given month. I have created an in memory table @MONTHS that has lines…
Jason Maggard
  • 1,632
  • 1
  • 16
  • 21
1
vote
1 answer

Creating new user in Dynamics GP

I have created new user 'testUser' in Dynamics GP company lets say 'TWO', there is another database on same server which is a non GP company database lets say 'TEST'. There are few tables in TEST db which I need to read on my some Dynamics GP form.…
Almas Mahfooz
  • 896
  • 1
  • 10
  • 19
1
vote
1 answer

Can you connect to Dynamics GP from an Azure worker role?

I'm looking into the possibility of integrating an Azure hosted .NET solution with Dynamics GP and I'm new to Dynamics. In general it seems like there are two approaches to connecting to GP: 1) web services and 2) eConnect. This article has some…
Bryan
  • 857
  • 1
  • 11
  • 25
1
vote
4 answers

QTP / Dynamic Great Plains automation

I have recently completed a detailed investigation regarding GP functional test automation possibilities with QTP, TestComplete, and other GUI recognition/interaction tools. In short, none of the tools acted well. Mentioned above did best but still…
Albert Gareev
  • 790
  • 6
  • 13
1
vote
3 answers

Dynamics GP 10 table name

Are the table names for GP 10 the exact same as GP 9?
Terry
  • 319
  • 1
  • 3
  • 13
0
votes
1 answer

Collecting a list of vendors

I have been searching for hours on Google and Microsoft to find a code example of how to collect a list of active vendors from Microsoft Dynamics Great Plains 9 via eConnect. I have downloaded 3 SDKs, multiple snippets, and an obscene amount of…
Jeremy Holovacs
  • 22,480
  • 33
  • 117
  • 254
0
votes
1 answer

How to configure a button to run a method in vba

I have a custom application I am developing in vba. I have written all the code and the only thing I am confused about is how to configure a button to actually "start" or "run" the program. On the form on the user side, the user will type in an item…
javasocute
  • 648
  • 2
  • 11
  • 28
0
votes
1 answer

Microsoft Dynamics GP SUTA Report Running Slowly

We are running Microsoft Dynamics GP version 11.00.1860 (SP2) and we're having issues running our SUTA report for this past quarter (10/01/2011 - 12/31/2011). It's running incredibly slowly. The quarter before that, it ran for 3 hours. I ran a…
kelleystar
  • 123
  • 7
0
votes
2 answers

Are there any issues with connecting MS Access to a SQL Server database that I should be aware of?

I have an issue occurring in Microsoft Dynamics GP, and am doing research to see if this is the cause,but this could be a Access to SQL Server issue. GP stores data in SQL Server, and MS Access is being used to access the table data. Some data…
Kinze
  • 3,780
  • 5
  • 21
  • 15
0
votes
2 answers

How do I create and synchronize a combined reporting-only db from two live dbs?

I need to quickly implement a read-only database containing data pulled from two identically structured live databases. The live dbs are actually company dbs from a Dynamics accounting system so I'm happy for any Dynamics specific advice but this is…
tetranz
  • 1,932
  • 3
  • 24
  • 32
0
votes
2 answers

Is there an eConnect for Microsoft Dynamics GP 8

I have a question regarding eConnet does GP8 already have this, if it does can I use Visual Basic 6 as a tool to integrate system to GP.
Rob
  • 638
  • 3
  • 14
  • 34
0
votes
0 answers

How to Delete an Item using the Dynamics GP Web Services

It appears there is not a DeleteItem or UpdateItem function for Items in Microsoft Dynamics GP Web Services. Is there a way that you can preform either operation using the Web Services?
user489041
  • 27,916
  • 55
  • 135
  • 204
0
votes
1 answer

First call to Dynamics GP 2010 Web Services takes 10+ seconds

I have a web site that communicates with a .NET 4 WCF web services. That WCF service connects to Dynamics GP Web Services on a remote server. Both Web Services are self-hosted (no IIS). The first call to GP takes around 12 seconds to complete!!…
dstj
  • 4,800
  • 2
  • 39
  • 61
1 2 3
…
9 10