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

The FICA/Social Security tax table cannot be found. Paychecks cannot be calculated

I got this in GP9, SP4, after running MicrosoftDynamicsGP-KB2477913-v9-ENU.msp

I'm not sure exactly what what wrong, the tables (UPR41300, UPR41301, UPR41302, UPR41303 in the Dynamics database) all seemed to be there...

Inventry Transfer Multiple line itemsCsharp Code required?

Hello

I am trying to add multiple lines into inventory transfer, i have successfully enter the transfer header, transfer line item and transfer lot, but when i try to add multiple line items it gives me the error: The trx quantity <> the sum of serial/ Lots?

Please give me the solution for it?

Thanks

Data extraction using eConnect: Need advise on which service or method to use?

Hi,

I am planning on using eConnect for data extraction. The data is based on Items and Item Price Lists. I read through the eConnect Administrator's manual, and there are quite a few ways to accomplish this including (eConnect Transaction Requester Service, Transaction Requester .NET calls, and eConnect Replication).

Which one are you using and and why?

eConnect 11 and Visual Studio Issues opening the document sender.sln

I have an odd and simple question, I hope. I used the Direct Document Sender for eConnect for a long time with earlier versions of eConnect. Since they have moved it to Visual Studio, I just have not had the need for it but a couple of times. Both times I was in a hurry and able to solve my issue another way once I hit the following road block so I just dropped it.

I have eConnect 11 Installed with GP2010 on SQL2008 and VS2008. When I go to open the .sln VS throws up a message about needing to upgrade the solution. I stop, make a backup of the sln then let it go through its paces. It is obviously failing but not raising an error. If I go launch it again VS will not let it open because it does not like the version of the .vbproj file.

How am I supposed to be doing this? Is VS2008 not an acceptable version? I have been googling all over the place and not finding a resolution. Thought you might have an idea or could point me somewhere

Purchase Order

Hi everybody
Could you please let me know the table name for Inventory Posting Account.

I would like to fetch inventory account maped against a particular item. Regards Rajesh..

Walkthrough: Adding Menus for Visual Studio Tools GP2010 to a project

Below is a walk through for adding Menus for Visual Studio Tools GP2010 to a project. It's very similar to the GP10 code, but there are some new added enhancements, including the ability to hide/show menu items on the fly. You can also 'Register With Security', giving you the abilty to hide/show a menu item based on the security to a GP form.

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables