User Id and Date Updated in Item Master
I have created 2 User Defined Field in OITM.
U_Userid (3 Character AlphaNumeric)
U_DateUpdate (Date Field)
I would like to pick the User Login who Updated the Item Master and the Date (Todays Date) when the Item Master was Updated.
I can use the Audit Trail but my Client would like to see the field on the Item Master.
I want to know from which Table can i get User Login and Todays so i can used FMS for Display
Nagarajan K replied
To get date of update, use below FMS and set auto refresh based on date of update:
SELECT T0.[UpdateDate] FROM OITM T0 WHERE T0.[ItemCode] = $[OITM.itemcode]
To get updated user I, use below FMS,
SELECT t1.userid FROM OITM T0 left join OUSR T1 on t0.usersign2 = t1.userID WHERE T0.[ItemCode] = $[OITM.itemcode]
Thanks & Regards,