Message Boards
Audit changes to pt_mstr in 2012_1 EE
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 PostsXavier Pechadre, modified 9 Years ago.
Re: Audit changes to pt_mstr in 2012_1 EE
Post Date: 11/27/16 (Silver, 70 Posts) Recent PostsHello,
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
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 PostsThank you for this help.
Now to check if IT can get this done.
Message place holder
Forums