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.