Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME

Sign Up Now!Log In
kretek 11/14/2019 9:49:17 AM

Sales order to Invoice with Econnect


We are creating sales orders with econnect, and invoicing them also and have no problems with this. We noticed when we do a sales order to invoice transfer through gp, the salesorder moves from sop00100 tables to history. However when we batch the invoices, the invoices move to history,the original sales orders stay in the sop00100 tables.


What we are trying to figure out is if there is a way we can tie it all together and move the Sales order to history when we batch the invoices. If we need to add a particular field that we need to make sure is filled out on the invoice through econnect that we are missing or if maybe its some feature we need to turn on.


we currently have checkbox checked to maintain order history so it get's moved to sop30200 but we could only get it to work with transfers so far and not through regular invoice creation and batching

Version: GP 2015
Section: .NET Development, 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