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