Filter List of UOM Based on Part Specific/Conversion Factor of Part

I am referring to the UOM Combo Box for the lines in Quote Entry and Sales Order Entry apps.

Our sales team has asked if it’s possible to filter the list of available UOMs based on if ‘Part Specific’ is false or if conversion factor is greater than 0? Any ideas? Can we add parameters/filters/arguments to the Reusable Combo in App Studio? If so, what should they be?

This is the current combo setting in App Studio:


This is a partial list of UOM that currently displays in the combo box:

I would like to add a filter, so it only shows these two:

1 Like

You know that might make a good Epicor Idea have check boxes on the part UOM screen one for Sale UM, Purchasing UM, Inventory UM. Then depending on what screen you are selecting the UOM data from, it creates the list based on the selected check boxes, May need a company or site config option to turn that functionality on or off globally.

:thinking:

How to do this in the App studio I have no idea, but perhaps there is method that populates the list you may be able manipulate the list on the fly…

In the back of my mind I recall adding some sort for restriction a looooong time ago… at another employer

on a kinetic dashboard, i set up an event to call PartSvc.GetByID and store PartUOM in a dataview, i call the event on row change.
then set up my combo box to pull from this dataview, with row criteria of:

ConvFactor <> 0 

If you run a trace on BO that populates that combobox, you can prepend to the whereClause in a pre BPM, check if whereClause is blank and then set it to the above, if whereClause is not blank, then prepend "ConvFactor <> 0 AND ", i did something similar on reason codes BO that feeds the combo box, Erp.BO.Reason.GetList, put yours on Erp.BO.UOMSearch.GetList

image


true, set whereClause to:

"ConvFactor <> 0"

false, set whereClause to:

"ConvFactor <> 0 AND " + whereClause
1 Like

Yup that one sounds very familiar.