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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
btamulis 11/22/2011 7:47:54 PM

Integration Manager Scripts

I have an integration (GP2010) I inherited that used to properly update a SQL table with the value "READ" after a document has been successfully integrated.

The script is as follows:

Dim GP

 Set objRec = CreateObject("ADODB.Recordset")

 GP = Sourcefields("PORECEIPTS_LINES.PONO")

 sSQL = "Update RBI_POReceipts set ReadByGP = 'READ' where PONO= '" & GP & "'"

 Set objRec = GetVariable("Connection").Execute(sSQL)

 

Does anybody have any thoughts? Does anybody have an example of a script they use that I could review?

 

 

Version: GP 2010
Section: Dynamics GP, Integration Manager








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