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?
Best answer by hhy38
View original
How to insert History Log record when update allocations or operations on Shop Order?
Userlevel 5
+14
This topic has been closed for comments
Userlevel 5
+10
Hi,
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.
Userlevel 5
+9
Hi
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,
Userlevel 5
+14
We customized the update revision procedure. It solved our problem.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.