Need to find Which class type is which user is used in Purchase order table in venders contact field

mania
Tera Contributor

Hi,

 

I have a few Purchase order records in that i have a field called Vender contact so that field is referenced by Sys_user table. In every user have classes.

My requirement is need to find Which class type is which user is used in Purchase order table in venders contact field 

How to filter, can you please help on this. It will be helpful.

mania_0-1705398245141.png

 

mania_0-1705398360241.png

 

 

Thanks in Advance!

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @mania 

 

If I understood , you can create a report on PO table. 

 

In config tab vendor cotract.user.class

 

You will get the details.

LearnNGrowAtul_0-1705398950481.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

@Dr Atul G- LNG 

Can we find out like which is my company user and which is the customer user through that class.

Thanks!

Mania

Hi @mania 

 

Yes, you can create a report on user table.

LearnNGrowAtul_0-1705402194737.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Sandeep Rajput
Tera Patron
Tera Patron

@mania Right click on the Vendor contact field and see which table is being referenced on this field.