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
SteveGray 2/16/2012 1:26:01 PM

eConnect - SOP to POP linking

* This article, and all our great eConnect documentation, Is available on the eConnect menu

I'm doing SOP to POP linking with eConnect for the second time. It can't be done with eConnect proper, but we add some code to the 'post' procedure for the PO eConnect transaction and it gets linked like that.

The first time there were issues, and we struggled with them, and then got the thing working. The issue is that you have to get the right combination of fields.

But I didn't write it down.

Now for the second time there are issues. Grrr.

Below is the taPoLinePost procedure that we use. Note that the @I_vUSERDEFND1 needs to have the Sales Order number, and @I_vUSERDEFND2 has the SOP line item sequence number

4Penny.net
Version: GP 2010
Section: eConnect






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