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?
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?
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.
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,
We 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.