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

Three editing tips/trick/hacks

Please take a minute, look at our latest video: Three editing trick for Dynamics GP developers.

https://www.youtube.com/watch?v=Kkt9Dm_fL1o

RadLabel

I had a requirement today to make a disabled control 'more readable'

Grrr.

The control was a RadTextbox, and I had it disabled so people would not type in it. I suppose I could have made it 'read only', but that mode allows the cursor to enter and that bugs me.

I make the control a radLabel, and styled it below

dd_IVTransferTypeWrapper

This is a complete example of how to call the eConnect IVTransverType schema in SQL using the stored procedures, including the lots

Server 2012 Restarting in x minutes, x seconds Your PC needs to restart to finish installing important updates

So, I'm working on a client computer, and when I log on I get the message that the server is about to restart.

In the middle of a workday.

And I'll get blamed.

Solution below.

taRmApplyPost for Project Cost apply integrations

A client is integrating RM Apply documents into Dynamics GP, but they're using project accounting, and the PA tables are not getting updated. The fix was to put code in the taRmApplyPost script to update those tables. The code below is untested... but I don't have good access to this client and I wanted to get the code posted before I lose access.

There are three types of PA projects (Fixed Fee, Cost Plus, and Time/Material), the code below does not cover cost plus. It should be carefully tested for any use, this code might be client specific

IVTransferType Wrapper

This is how to call the eConnect IVTransferType from SQL.

IVTransactionType Wrapper

This article will conver how to call the eConnect IVTransactionType from SQL.

**ERROR: The commission sale total does not equal the commission sale amounts.

Grrr. What I did to fix it is below

Hide the grouped column

Usually when I group by a column in a grid, I don't what the column to show up in the grid below.

This piece of code demonstrates how to hide the column in a Telerik asp.net grid.

Placing pieces of code like this on the Telerik ASP.NET menu under the grid grouping section allows us to write code faster. Faster is better.

Need help with SOP batches

I'm trying to help a friend. The person that handled all of the sales batches has left the company and there are no instructions on how to processes online orders.

There is an econnect tool that pulls the orders from the web and puts them in the database. It doesn't connect the orders with a batch.

I'm a database guy, so I know the tables well, but I don't know the GP interface very well.

How do I find an order and add it to a batch? How do I do that in bulk?

All assistance is greatly appreciated.

GP Adjust Costs issue

Hi,

I've been asked to try to write some code that will help automate the entry of Inventory Adjustment Costs.

When an item is selected and the cost entered and then the PROCESS button is clicked, 2 reports are prompted.

They do not trigger the modal dialogue event.

How can I cancel these in VB? or turn them off completely?

Thanks in Advance,

Mark Moses Fineman

user security setting does not seem to work

Hi there what could be the possible reason that the user security setting stopped working. e.g. I give a user only order processing privilege and leave all other roles unchecked. however the user has access to even administrative rights such as modifying another user's access. thanks!

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables