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
0
votes
1 answer

Refactoring an eConnect method that uses a single stored procedure

I'm writing a program to modify some invoices in GP10 using eConnect. Some of the invoices require the distributions to be reset because the totals do not add up correctly due to various other (not important for this question) processes; this is…
MalibuCusser
  • 124
  • 1
  • 8
0
votes
1 answer

SSRS sum if series expression error

I'm working with Microsoft dynamics GP, trying to get some data to display in a column chart in SSRS. Below is the query I used to get started SELECT RTRIM(S.CUSTNMBR) 'Customer ID', RTRIM(C.CUSTNAME) 'Customer Name', S.SOPTYPE, CONVERT(varchar(4),…
Pracha Yang
  • 11
  • 3
0
votes
0 answers

Dynamics GP - Tax Schedule ID percentages

Is there a way of getting the total tax percentage of an item's tax schedule ID? So far all I can guess is that this can be done by getting a sum of the percentages for each tax detail ID at the taxable percentage. For instance, tax schedule ID…
ryansin
  • 1,735
  • 2
  • 26
  • 49
0
votes
1 answer

SSIS Cozyroc Dynamics GP Tools, using ObjectCriteriaXML Scope of ReturnBasedonCustomerId returns error

I'm in the middle of evaluating the Cozyroc Dynamics GP tools. I'm very comfortable using SSIS and have used Scribe in the past to integrate to Dynamics but I'd prefer to use SSIS on this project. I have managed to get simple queries to work without…
Jay13
  • 860
  • 9
  • 15
0
votes
0 answers

Dynamics GP Webservices CountryRegionCodeKey

I am creating a new sales order through the webservice. I am setting the ShipToAddress property to a BusinessAddress class with a country code that is in a different country than the bill to address. When I create the order and send it to GP there…
Devnsyde
  • 1,297
  • 1
  • 13
  • 34
0
votes
1 answer

eConnect Classes not visible in referenced dll Microsoft\Microsoft.Dynamics.GP.eConnect.Serialization.dll

IV_Suggest_Sales_Setup_HDR(IV00400),IV_Suggest_Sales_Setup_LINE(IV00401) These are two classes to insert suggested items in Item card These are two tables related to suggested items in Item card and i found that these are the two econnect classes…
user3792804
  • 37
  • 10
0
votes
3 answers

Add Dynamics GP namespaces Visual Studio project

I need to add the following namespaces • Microsoft.Dynamics.Common • Microsoft.Dynamics.Common.Types • Microsoft.Dynamics.GP.BusinessLogic • Microsoft.Dynamics.Common • Microsoft.Dynamics.GP to my project in Visual Studio, Kindly suggest how I can…
Umair Manzoor
  • 33
  • 7
0
votes
1 answer

Sales Order Taxes For Dynamics GP

In Microsoft Dynamics GP I need to set the tax on individual orders as taxable/non-taxable (cannot be done on customer record). For some reason no matter what I pass into the CreateSalesOrder call for the web services, it will not save the tax…
StrangeWill
  • 2,106
  • 1
  • 23
  • 36
0
votes
0 answers

Great Plains Smarlist runs excel macro twice

I wrote a smartlist and an excel macro enabled workbook that is supposed to sum two columns and put the total under each column on a new row. It works perfectly straight from excel but when run from GP Smartlist export it sums my columns twice. …
VinnyGuitara
  • 605
  • 8
  • 26
0
votes
1 answer

Get next BACHNUMB for econnect taPopRcptHdrInsert

How do I get the next BACHNUMB for the Dynamics GP eConnect proc taPopRcptHdrInsert?
Adam
  • 497
  • 2
  • 9
  • 29
0
votes
1 answer

Microsoft CRM Dynamics GP Using database after CRM License Expires

my company wants to stop using GP but would like to retain all the historical data (for reporting) from the Great Plains 2010 system . Can someone please advise if I can just take a backup of the Great Plains database after the license expires and…
ace
  • 215
  • 6
  • 17
0
votes
1 answer

Microsoft Dynamics GP report writer Calculated fields

Does anyone know how to add Tax Commodity code which is in IV00101 (Item Master table) on to SOP invoice as a calculated field. I could go create a new calculated field and then select 'Item Master' from Fields --> Resources,then select 'Tax…
Sinnerv
  • 263
  • 2
  • 6
  • 17
0
votes
1 answer

Dynamic GP eConnect - Creating a new PMClassMaster

I am finding my self looking in front of a wall right now. I've started working with eConnect to communicate with Dynamic GP in order to access information. I've come accross a questions that I have yet to see answered and I'm tired of searching all…
Filipe Picoito
  • 673
  • 6
  • 23
0
votes
1 answer

New Check Signature File in Dynamics GP

How do I add a new signature file in Microsofts Dynamics GP. I already have the signature scanned into a .bmp file. What do I need to do next?
Billy Rogers
0
votes
1 answer

Dynamic GP: Read Line Items of Sales Invoice

From Web Service of Microsoft Dynamics GP 2013 Creating Sales Invoice by following code: private void CreateInvoice() { CompanyKey companyKey; Context context; SalesInvoice salesInvoice; SalesDocumentTypeKey…
Khalid Farhan
  • 435
  • 1
  • 3
  • 19
1 2 3
…
9 10