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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
airtech 12/4/2013 11:19:51 AM

GP2010 Project Accounting Inventory Transfer without eConnect


We are trying to transfer an inventory item to a Project in Project Accounting(PA) and have resorted to using SQL profiler to try and reproduce the actions taken by GP2010 to simulate the process.  It seems there are no eConnect schema/node combinations to perform this operation for us but I still believe there may be a better way then manually brute-forcing our way through.  I was told to extend eConnect by producing a new custom node but this would still require an in-depth understanding of what is happening behind the scenes of GP and Dexterity while building the necessary stored procedures.  Any suggestions or advice?


Thanks in advance,


Version: GP 2010
Section: Dynamics GP, eConnect, SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables