Message Boards

Audit changes to pt_mstr in 2012_1 EE

thumbnail
Raymond Chin Kwie Joe, modified 3 Years ago.

Audit changes to pt_mstr in 2012_1 EE

Post Date: 11/23/16 (Rhodium, 825 Posts) Recent Posts

Version 2012_1 EE. Does anyone know how to track changes in the pt_mstr in qad?

Mneu 36.17.. etc does not seem to log the pt_mstr.

 

thumbnail
Xavier Pechadre, modified 9 Years ago.

Re: Audit changes to pt_mstr in 2012_1 EE

Post Date: 11/27/16 (Silver, 70 Posts) Recent Posts

Hello,

You can modify pt_mstr triggers (on write) like that :

for change on pt_status on QAD SE 2012

if old_pt_mstr.pt_status <> pt_mstr.pt_status then do :

                find last aud_det where aud_domain = global_domain no-lock.

                v-i = aud_entry + 1.

                create aud_det.

                assign  aud_dataset = "pt_mstr"

                        aud_userid = global_userid

                        aud_date   = today

                        aud_key1 = pt_mstr.pt_part

                        aud_key2 = pt_mstr.pt_desc1

                        aud_old_data[1] = old_pt_mstr.pt_status

                        aud_time = string(time,"hh:mm:ss")

                        aud_entry = v-i

                        aud_field = "pt_status"

                        aud_new_data[1] = pt_mstr.pt_status

                        aud_domain = global_domain.

end.

 

Best regards

thumbnail
Raymond Chin Kwie Joe, modified 9 Years ago.

Re: Audit changes to pt_mstr in 2012_1 EE

Post Date: 11/29/16 (Rhodium, 825 Posts) Recent Posts

Thank you for this help.

Now to check if IT can get this done.

Message place holder