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
hamzajosh 4/3/2018 12:26:24 PM

eConnect question

I have an SSIS package with VB .net code in it to import purchasing receipts in GP2016. Package runs fine.

I am now been assigned to create one for creating new items in INVENTORY. While i was dabbling with documentation and other resources, I found the encrypted stored procedures for eConnect. Rather than writing .net code, I realized I could just make calls to eConnect SP taUpdateCreateItemRcd and create the items by passing the required parameters to this stored procedure. 

Questions are:

1) Am I correct in assuming this process to create items?

2) How is the result different calling SP directly rather than creating XML and passing it to the .net Classes?

3) Could I have used the appropriate SP for importing the purchasing receipts also?

Version: All
Section: Dynamics GP, 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