1 Reply Latest reply on Jan 16, 2017 3:50 AM by Sanjay Desai EBS

    Restriction of Document Type LOV in Purchase Order Summary

    1034351

      I'm looking for a way to restrict the Document Type LOV in Purchase Order Summary.  We want to remove Blanket Purchase Agreement (or gray it out) from the list if the user is using the PO Entry responsibility. The buyers need to be able to query for an existing BPA but not create a new one. Right now we have it limited so that once they try to save the header, it greys out the PO Lines block but this will require cleanup and we'd like to do away with the ability for them to create the BPA header in the first place.

       

      Suggestions?

       

      Thanks!

       

       

       

       

        • 1. Re: Restriction of Document Type LOV in Purchase Order Summary
          Sanjay Desai EBS

          Hi,

          you can restrict to create the BPA by using personalization.

           

          On Purchase order form, do the personalization in the follwing way.

           

          Trigger Event : WHEN-VALIDATE-RECORD
          Trigger Object : PO_HEADERS

          Condition -

          :PO_HEADERS.DOC_TYPE_NAME = 'Blanket Purchase Agreement'

           

          Action :

           

          seq : 10
          Type : Message
          Message Type : Error
          Message Text : You cannot create BPA

           

          Seq : 20
          Type : BuiltIn
          BuiltIn Type : RAISE FORM_TRIGGER_FAILURE