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
cschleh 2/22/2017 4:04:37 PM

Broken LInks in Drop Shipments

I am trying to figure out a way of alerting when the link between a SOP order and the PO are broken on a drop ship order. I was hoping to find a field in a SQL table that I could scan for a change in value if the link was broken, but it looks like it wont be that easy. Does anyone have any ideas on what to look for in the database to tell if the link is broken on a drop ship?

Thank you.

Version: GP 2015
Section: Dynamics GP, SQL Scripts, SSRS

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables