PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/10/2017 1:59 PM by  bcoyne
Limit Access to Vendors - RQC
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Neil Allen
Supply Chain IS Analyst
Private
Veteran Member
(165 points)
Veteran Member
Posts:81


Send Message:

--
01/28/2017 11:13 AM
    Is there a way to limit the vendors that users see in RQC?  We have some vendors that we don't want users to be able to use through service specials but they're able to pull them up.  Is there anything within AP10/PO10 that would allow us to "hide" the vendor from RQC?
    Stephanie
    SCM Practice Manager
    RPI Consultants
    Veteran Member
    (234 points)
    Veteran Member
    Posts:82


    Send Message:

    --
    01/28/2017 8:36 PM

    You could add a conditional rule to the security class assigned to your requesters.  Most use the AP Vendor Master Vendor Class for this and only allow the requester to see PO related vendors.  

    Stephanie Kowal | skowal@rpic.com
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    01/30/2017 10:10 AM
    Are they vendors you don't want to use at all? (No Item Master records either) - You could also set them to Vendor Status D on AP10 and they will not appear. But this will also not allow item master records to be added.
    kflores01
    Private
    Private
    Veteran Member
    (100 points)
    Veteran Member
    Posts:36


    Send Message:

    --
    02/01/2017 8:27 AM
    You could create new vendor lookup for RQC with new system key.  Then substitute the vendor key in RQC with your new one. 
    bcoyne
    System Analyst
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    02/10/2017 1:59 PM

    Hi Stephanie, I am attempting to do as you suggested in our DEV env, but it does not appear to be working. The class our requesters use is called MMREQUEST

    I added a rule to MMREQUEST, under Securable type I choose Files > AP>APVENMAST. I created a conditional rule access as follows (The goal being that requesters can not choose type 'ONE'

    if(table.VEN_CLASS=='ONE') 'NO_ACCESS,' else 'ALL_ACCESS'

     

    I cleared the cache and tested with a user whom is part of the MMREQUEST class and they were still able to see all vendors.

     

    To clarify they are going into RQC >Shopping>Detail profile>Cost Default Vendor and then choose Active Vendors by Class or Active Vendors by Name

    Am I missing a step, or is part of my syntax incorrect?

     

    Thank you very much!

    You are not authorized to post a reply.