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
angelreynosog 4/9/2019 11:01:46 AM

SOP Document

good day!

I would like to know if you can guide me, how I can associate by the SOP master order number, the lines that have been transferred. Example, if you make a quote with 5 items, when transferring to order, the same when transferring only 3 item was transferred, and at the time of making invoice, only 1 item had quantity available.

It is more or less, a tracking of the items in each sales document.

Someone could help me, I would like to do that in sql.

Thank you
Version: GP 2015
Section: Dynamics GP, 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