We want to insert log record on Shop Order when someone update allocations or operations. I wrote the plsql script but we could not find when the event will trigger?
Solved
How to insert History Log record when update allocations or operations on Shop Order?
+16Best answer by hhy38
We customized the update revision procedure. It solved our problem.
This topic has been closed for replies.
+10Hi,
if your operation updates a column value in shop order can’t you set up history logs against shop_ord_tab ? You can tick the relevant column id on a certain even which is insert, update or delete.
+10Hi
You are trying to insert a record to History tab when materials and operations are updated in Shop order.
Therefore you can trigger event on below tables.
SHOP_ORDER_OPERATION
SHOP_MATERIAL_ALLOC_TAB.
Regards,
+16We customized the update revision procedure. It solved our problem.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.