Custom Menu condition

The Condition determines under which condition the menu should be available, it is not passed to the new window. In your setup, the menu will be grayed out on all requisition lines in any status other than Planned, Released, or Partially Authorized.

I think you need to create a menu that will run a search, so a PL/SQL Block should suffice. The search would find in Purchase Requisition Lines all lines for this Part No and Supplier in states Planned, Released, or Partially Authorized.

OK I have to change my action type to “PL/SQL block” and then get the Purchase Requisition Lines window to open. I have never been able to get a custom menu with a PL/SQL block  to open a new IFS window though.

Hi @jdoherty,  

I am also passing in the condition that the state must be in one of "Released;Planned;Partially Authorized". This condition is not working though.

Can you clarify more regarding this statement? Did you mean the condition did not filter out the data on the destination window or the custom menu is available for all states? 

I mean that the the condition did not filter out the data on the destination window. I thought that was what it was supposed to do but it isn’t (my mistake). I will have to do it in a PL SQL block instead. 

You won’t get your desired outcome with a PLSQL method either if I am understanding the use case correctly.

This would be better delivered using a lobby or multiple lobbies. You could navigate from the page passing the parameters through to a lobby page, then have a lobby element that filters the data further by status.

I will try doing it by making the menu open a lobby that contains the Purchase Requisition Lines screen and passing in the parameters from the line on the Requisition; only lines in state “Released;Planned;Partially Authorized”.

I have done what you suggested; I created a lobby page with a lobby element that displays Purchase Requisition Lines filtered by status “Released;Planned;Partially Authorized".

I then set the custom menu to go to that lobby page but I can’t pass it the Vendor_no and Part_no parameters from the line on the Purchase requisition that has been right-clicked.

In my screen cap, the Url is the address of the Lobby. I need to append on to the end of it the Vendor_no and Part_no. Can anyone tell me how to do that?

Thank you

firstly u need to create variable in Lobby and after that u can get values from lines using &vendor_no&

there is an example below,

ifswin:Ifs.Fnd.CompositePageRenderer.PageContainer?page_id=b8eff497-4ce2-43fb-ab6f-eaa2f58c2293&Vendor_no =&VENDOR_NO&

Thanks, I will try that