Filtering the ShipTo combo using a UD field (active/inactive)

[ckrusen (Calvin Krusen)]

Here’s an example of how we do this for “inactive” Product Groups.

• The PrdGrp table has a UD field AllowUsage_c

A Pre-Proc BPM for Erp.ProdGrup.GetList consists of:

With the Set Argument expression

"ProdGrup.AllowUsage_c=TRUE " 
+ (whereClause ==  null ? "" : " AND " + whereClause)

Then anywhere that a user has a list of Prod Groups to choose from, they see:

And this doesn’t prevent you from selecting them in Product Group Maintenance