DynDeveloper.com - Your Dynamics GP Questions, Answered

Search the GP Tables

Search by TABLE NAME

Search by FIELD NAME

These are our SOP scripts. All of our scripts for Dynamics GP can be found here

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Archives

Formatting a text box

This short code example will show how to format a text box for numeric values

Currently, we only show how to format for percent values... but we hope to expand it.

System.XML - How to Serialize a DataTable to XML Document

Recently I was asked to write a web service that would expose Dynamics GP tables. I've got code to grab the data and populate a DataTable, but I was missing the 'serialize' piece

This short code example will show how to take a DataTable and serialize it into a String.

eConnect - Sample SOP document

This is an XML file that will create a SOP document.

This is a bare minimum document that will auto create taxes. In the line we specify only the quantity, the pricing and extensions are defaulted.

eConnect 2010 - SOP Payment Example

A few months ago I posted the XML needed to create a SOP Payment transaction. Here's the other side - the code neede to generate the XML

Telerik - RadDropDownList

This article covers common coding techniques associated with the Telerik RadDropDownList.

Your First Navigation List

This is a walk through for creating a simple Navigation List using Dynamics GP 2010's Navigation List Builder.

In this example we'll create a list of items and create an Action to open the Item Maintenance window.

Thin Client HP T5565

I have 10 thin clients using Remote Desktop to connect to a Server 2008 R2 64 bit and with SQL SERVER 2008 where Dynamics gp 10 is, but when the users shut down their systems and come back the next day the printer ports assign previously is inactive and windows will assign new ports to printers and no one can't print.

Question: How can I configure Windows server to not create new ports everytime the users shut down or restart their systems and leave the port assign unchange?

Input variable contains a duplicate document

Edit 9/16/15 View the main post for this error here

Error Number = 56 Stored Procedure taSopHdrlvclnsert Error Description = Input variable contains a duplicate document

Node IdentiFier Parameters: taSopHdrlvclnsert

Edit 9/16/15 View the main post for this error here

Error Number = 60 Stored Procedure tasopHdrlvclnsert Error Description = Payment total does not match line deposit + credit card payment total
Node IdentiFier Parameters: taSopHdrlvclnsert

I got the above two errors while doing an eConnect SOP Payment integration, so I thought I'd document them.

I had copied the code from here but that code (I think) is GP2010 and I'm doing GP9.

Telerik - RadDropDownList

This article covers common coding techniques associated with the Telerik Winforms RadDropDownList.

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables