EpicomboBox filter leaving a value that should be filtered

Epicor ERP 10
, ,
1

Hello, I’m trying to filter the manufacturer part numbers on PO entry based on a UD field that I added so we can mark the manufacturer part numbers as inactive. I added the filter for the field to the combobox and it is filtering out all of the inactive part numbers except for one.

This is what I see when I click on the dropdown. I added the UD field as a column on the combo box so that I can see it and it should only be showing manufacturing part numbers that do not have the box checked off. I added a bunch of part numbers and marked most of them as inactive and it is filtering all of them except for one.

image
image995×114 42.8 KB

I’ve tried this across multiple manufacturers and multiple manufacturer part numbers and it always leaves the first part number on the list regardless of if it is set as inactive.

Any ideas on what I might be doing wrong here?

2

This is what I have set for the filter

image
image784×577 45.2 KB

3

Hi Eric, Welcome to the community!
I am not sure about the exact answer to your question. However, I often have trouble with combo boxes, and making sure the contents are up to date. I normally try to force the combo box to refresh before I interact with it. May this could work for you too. You could put this in a main form load, or an epinotification event. Not sure where the best place is, but this often helps me.

cmbRevs.ForceRefreshList();

Make sure to replace cmbRevs, with the name of your combobox.
Good luck!
Nate

1 Like
4

Could try changing ListDataSet to RowDataSet to see if that works, I nearly always have to do that with the User Codes table or it grabs more data than it should.