Capturing The Part Maint Details

[ravi_gupta2u]

Hello Mfg/pro Users:

Version QAD eB2.1

I need to capture below data whenever someone is chaning part master data using item maintenance of usnig some other program.

1) user id who changed part details using 1.4.3
2) program name if part master data is updated through any other program
3) old value and new value

Could you please suggest best option?

 

[Pechadre]

Hello,
You can modify the pt_mstr trigger (ptw.t program) and at each modify on one of the list field add a record in audit table ( aud_det ).

like this

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.

Best regards