Can I put in a SQL trigger at store which will re-insert the original PO items / quantities into a store PO when it is closed. The reason being unreceived ordered items are removed from a PO (no idea why) and undersupplied items quantity ordered is adjusted down to quantity received. The SQL query would ensure that PO items / quantity ordered reflects the original PO.
Any help would be greatly appreciated.