Points: 55309

11/4/2021 2:42:29 PM


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

This article details a series of SQL scripts that will allow you to create Dynamics GP POs using the stored procedures that power eConnect. 

The steps involved:

  • Create staging tables that will hold the PO header and line data
  • Populate the tables
  • Call the ddtaPOPTransactionTypeWrapper stored procedure.
  • This proc callse two other procs: ddtaPOHdrWrapper and ddtaPOLineWrapper

All the calls are wrapped in error trapping, if any errors occur all the data is reversed and the error is reported.
Version: Unknown or N/A
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