I’m sure like others, we have Reason Codes for RMA, Scrap, etc areas that have for one-reason-or-another been needing to be “disabled” and no longer show up in the pull down. In this case, I was lucky we only had two valid reasons to display and I was able to get some help to this filter working: E…

[image] Randy: ? ie: ReasonCode <> ‘ABC%’ This is close. Here’s the syntax: [image] And the result (all of the names starting with ‘A’ are gone) [image]

Thanks for jumping in, Randy. Actually, I did make a BAQ for this purpose, but couldn’t figure out how to configure it properly.

Do you mean you couldn’t configure the BAQ or get the BAQ Combo to work? Edit: Just did a quick demo as it’s been awhile since I used a BAQCombo. :slight_smile: Settings for BAQ Combo on form: [image] BAQ: [image]

O.K. Let’s take a closer look. But it’s important to understand that I couldn’t find documentation or examples for how to use the EpiBAQCombo, so it’s pretty much a best guess situation. Here’s the BAQ: select [UDCodes].[CodeDesc] as [UDCodes_CodeDesc] from Ice.UDCodeType as UDCodeType inner joi…

Thanks again for your assistance, Randy. I do believe this is working nicely now. So, the take-away lesson here is that I would use a standard EpiCombo if I’m okay with the first option being unpredictable (don’t forget my EpiSort didn’t work), and the BAQCombo is good for when you want to have mor…

Have you had any luck getting this to work in 2022.1.3? Nothing happens when I created the BPM and tried to look up rework reason codes.

Have you been able to get this to work on 2022.1.3 its not hiding anything when I changed the R (Rework) reason code and alter where to match our reason code description?

I’m not on that version, but I don’t believe the core product for BPMs has changed from Epicor 10 to Kinetic outside of the UI stack. Share your code and process if you want to get some help :slight_smile:

export.bpm (12.3 KB) Here is the BPM that I was using. I also tried putting in a condition on a different test to only filter on the Rework reason code. What we are wanting to accomplish is hid reason codes with ZZ in front of the description since they are no longer used.

FYI exporting the BPM is not really the preferred way, usually screenshots of the code or pasting your formatted code is the way. I’m certainly not going to import it into my environment

Okay, my bad. Here is a picture of the code. Not too different than what your picture had. [Snag_317c68ab]

Filtering unused Reason Codes

Epicor ERP 10

CSmith (Clint Smith) May 25, 2022, 5:37pm 53

Business Logic Tester

Topic		Replies	Views
Hide reason codes or filter an EpiUltraCombo Epicor ERP 10 e10 , customization , tasks , quote-entry	5	993	June 17, 2022
Make Reason Codes Inactive Epicor ERP 10	6	2894	June 9, 2017
Delete Reason Code or Make It Invisible Kinetic ERP epicor	8	2924	March 16, 2023
Filter Out No Longer used Inventory Adjustment Reason Codes Kinetic ERP bpm	0	418	November 18, 2022
E9: EpiCombo on UserCodes Filter only for IsActive = true Epicor ERP 9 customization	11	2843	March 12, 2020

Filtering unused Reason Codes

Related topics