Skip to main content

Hello,

I have a generic inquiry of SO Shipment Lines and I’ve added a condition that limits the Inventory Ids to only those that start with “GENPSY”.

I’ve also added a parameter for the Inventory Id to allow users to select a specific item.

My issue is that I would like for the lookup for the parameter to also only show items that start with “GENPSY”, so that users don’t have to look through the entire stock item list.

Is it possible to filter a parameter?

 

This is my parameter:

 

These are my conditions:

 

 

On the results screen, I would like for the parameter lookup to only show items that start with “GENPSY”:

 

Hi @donnadeskins55 

Apply filter for Inventory ID will work in some cases only, did you verified option “contains” or else Update Inventory ID With starting fix for “GENPSY” Items Like G- SKUO1, G-SKUO2, Then start with filter works.

Thanks

Hi @donnadeskins55! In this case you wouldn’t be able to filter the selector based on the the beginning of the inventory item unfortunately.

To filter the contents of the selector the field being used for the lookup would already need to have it’s contents filtered prior to being used in the GI, so it would require a custom table to accomplish it.

Thanks @BenjaminCrisman.

Disappointing, but I appreciate the info 🙂

@donnadeskins55 One other option is to switch to the ComboBox parameter type.  This would allow you to manually enter the individual GENPSY items you wish to allow selection from.  

The downside to this solution is the list must be manually maintained as new GENPSY items are added to the system. The other downside is the dropdown list does not allow lookup or filtering on other criteria, it would simply be a dropdown box of all items and their description.  

Reply


Terms & ConditionsCookie settings