on 12-22-2014 8:16 AM
Dear All,
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
Kind Regards
Raju Parmar.
Hi,
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,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.