DynDeveloper.com - Your Dynamics GP Questions, Answered

Search the GP Tables

Search by TABLE NAME

Search by FIELD NAME

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

	WDC Scripts
	No records to display.

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