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

Checksum error

I'm getting a checksum message when trying to call the get sales order list method.

The message is

header checksum: 0 x 0000 [incorrect, should be 0 x 164c]

Any thoughts?

FP_SOPGetNextDocNumber

This post is an explanation of how to use the internal Dynamics stored procedure SopGetIdNumber, which gives you the next SOP number available. We also share our own script that does essentially the same thing (but we recommend the Dynamics script)

FP_RMGetNextDocNumber

This post is an explanation of how to use the internal Dynamics stored procedure taGetPaymentNumber, which gives you the next RM number available. We also share our own script that does essentially the same thing (but we recommend the Dynamics script)

FP_SY00500_UPD

This is a sql script that will insert/update into the SY00500 batch table in Dynamics GP. It works in the bigger modules, but not all. I'd be happy to update it if there is a request.

It was written against GP 9 but will probably work against later versions

Edit 8/30/2018 added PA Billing support

FP_RMCashReceipt_INS

Here is a SQL script that will insert lines into the RM Cash Receipt table

FP_SOPPayment_INS

Here is a SQL script that will do an SOPPayment insert

Code to move the Sales Item Detail Grid to the first item

This article can be found on the Visual Studio Tools menu.

Here's a piece of code that will move the SOP Sales Item Detail grid to the first item

SOP Transaction Entry Expansion Button Definitions

Today I had to open the Sales Detail Item Inquiry window from SOP Transaction Entry. I knew that I had to press a button, but which one? Here are all the expansion buttons, and the forms that they open:

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables