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.