# Filtering unused Reason Codes **URL:** \ **Category:** Epicor ERP 10\ **Tags:** form, customization\ **Created:** [January 14, 2019, 6:02pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378 "2019-01-14T18:02:33Z")\ **Posts on this page:** 18\ **Page:** 3
**Author:** ![tonygardner](https://www.epiusers.help/user_avatar/www.epiusers.help/tonygardner/32/36395_2.png) [@tonygardner](https://www.epiusers.help/u/tonygardner)\ **Post date:** [August 16, 2021, 1:33pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/41 "2021-08-16T13:33:38Z")
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 join Ice.UDCodes as UDCodes on UDCodeType.Company = UDCodes.Company and UDCodeType.CodeTypeID = UDCodes.CodeTypeID where (UDCodeType.CodeTypeID = ‘ORD\_SOURCE’) order by UDCodes.LongDesc It certainly doesn’t have to be User Codes. My objective is to have the drop-down show five options, preferably storing a code (Value Member) but showing a description (Display Member). The catch is to have the initial value set to one that is NOT on this list, and that would be “Select One…”. I will give your example a try and let you know how it goes. ---
**Author:** ![tonygardner](https://www.epiusers.help/user_avatar/www.epiusers.help/tonygardner/32/36395_2.png) [@tonygardner](https://www.epiusers.help/u/tonygardner)\ **Post date:** [August 16, 2021, 1:58pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/42 "2021-08-16T13:58:59Z")
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 more control over what is displayed, and have NO option displayed when the screen initially loads. ---
**Author:** ![lgrube](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/858c86/32.png) [@lgrube](https://www.epiusers.help/u/lgrube)\ **Post date:** [May 25, 2022, 2:01pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/43 "2022-05-25T14:01:31Z")
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. ---
**Author:** ![lgrube](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/858c86/32.png) [@lgrube](https://www.epiusers.help/u/lgrube)\ **Post date:** [May 25, 2022, 2:09pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/44 "2022-05-25T14:09:41Z")
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? ---
**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\ **Post date:** [May 25, 2022, 3:20pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/45 "2022-05-25T15:20:15Z")
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 🙂 ---
**Author:** ![lgrube](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/858c86/32.png) [@lgrube](https://www.epiusers.help/u/lgrube)\ **Post date:** [May 25, 2022, 3:29pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/46 "2022-05-25T15:29:39Z")
[export.bpm](https://www.epiusers.help/uploads/short-url/xY5tJTr8ZsUgOcCWhRPLkGPsaRM.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. ---
**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\ **Post date:** [May 25, 2022, 3:31pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/47 "2022-05-25T15:31:27Z")
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 ---
**Author:** ![lgrube](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/858c86/32.png) [@lgrube](https://www.epiusers.help/u/lgrube)\ **Post date:** [May 25, 2022, 3:39pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/48 "2022-05-25T15:39:21Z")
Okay, my bad. Here is a picture of the code. Not too different than what your picture had. ![Snag_317c68ab](https://www.epiusers.help/uploads/default/original/3X/0/2/024509cb3db6511313c31d52e20e6020f8c76d70.png) ---
**Author:** ![Aaron\_Moreng](https://www.epiusers.help/user_avatar/www.epiusers.help/aaron_moreng/32/745_2.png) [@Aaron\_Moreng](https://www.epiusers.help/u/Aaron_Moreng)\ **Post date:** [May 25, 2022, 3:41pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/49 "2022-05-25T15:41:29Z")
Coool, is the BPM enabled? The other thing to check is you might need to have the same exact BPM on GetRows too ---
**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\ **Post date:** [May 25, 2022, 3:43pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/50 "2022-05-25T15:43:39Z")
Have you tried running the BL tester to see if your where clause works there? Sometimes it’s easier separate the parts of the problem to troubleshoot. ---
**Author:** ![lgrube](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/858c86/32.png) [@lgrube](https://www.epiusers.help/u/lgrube)\ **Post date:** [May 25, 2022, 5:29pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/51 "2022-05-25T17:29:00Z")
I made sure the BPM was enabled and created a BPM for GetRows and that brought all the reason codes in when searching for a specific reason code. I have tried to filter by specific Reason code but that does nothing. ![Snag_31e13135](https://www.epiusers.help/uploads/default/original/3X/f/4/f45bfb42fe5c5f91f44d4c11ddb56cf1c8c6c2b9.png) ![Snag_31e13fcb](https://www.epiusers.help/uploads/default/original/3X/8/2/82a83c61015ce8a5622986088257924ca79e5372.png) ---
**Author:** ![lgrube](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/858c86/32.png) [@lgrube](https://www.epiusers.help/u/lgrube)\ **Post date:** [May 25, 2022, 5:29pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/52 "2022-05-25T17:29:41Z")
Not sure what BL tester is? ---
**Author:** ![CSmith](https://www.epiusers.help/user_avatar/www.epiusers.help/csmith/32/50752_2.png) [@CSmith](https://www.epiusers.help/u/CSmith)\ **Post date:** [May 25, 2022, 5:37pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/53 "2022-05-25T17:37:21Z")
Business Logic Tester > [@Setting up the BL tester](https://www.epiusers.help/t/setting-up-the-bl-tester/54385): > > So I happen to be setting up the BL tester on a new server. It’s one of those things that you only do once in a Blue Moon so it’s hard to remember what the heck you have to do to get it set up. So, I will document the process here as I do this one, so 1. I can come back to it later if I need to, and 2. so others can see how to set up this super useful tool. First, this tool is on the server, that’s where it lives and where you run it from when you need to use it. Correction, you can use this fr… ---
**Author:** ![lgrube](https://www.epiusers.help/letter_avatar_proxy/v4/letter/l/858c86/32.png) [@lgrube](https://www.epiusers.help/u/lgrube)\ **Post date:** [May 25, 2022, 5:41pm UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/54 "2022-05-25T17:41:47Z")
Will this work for a cloud environment? ---
**Author:** ![Hally](https://www.epiusers.help/user_avatar/www.epiusers.help/hally/32/1263_2.png) [@Hally](https://www.epiusers.help/u/Hally)\ **Post date:** [May 26, 2022, 2:13am UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/55 "2022-05-26T02:13:21Z")
That is a good question, you could try, not sure it is supported though. If you have the rich/fat client installed on your pc, when you go to configure the BL Tester you can get the application URI information from your config.sys found in the client directory. ---
**Author:** ![Mark\_Wonsil](https://www.epiusers.help/user_avatar/www.epiusers.help/mark_wonsil/32/51594_2.png) [@Mark\_Wonsil](https://www.epiusers.help/u/Mark_Wonsil)\ **Post date:** [May 26, 2022, 3:27am UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/56 "2022-05-26T03:27:15Z")
> [@lgrube](#): > > a cloud environment? Yes. ---
**Author:** ![KBMihaila](https://www.epiusers.help/letter_avatar_proxy/v4/letter/k/f14d63/32.png) [@KBMihaila](https://www.epiusers.help/u/KBMihaila)\ **Post date:** [April 3, 2025, 12:05am UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/57 "2025-04-03T00:05:28Z")
Hi Calvin, I would like to add a custom field “Inactive\_c” to the Reason Code. How would I defined this UD Field? ---
**Author:** ![Randy](https://www.epiusers.help/user_avatar/www.epiusers.help/randy/32/51539_2.png) [@Randy](https://www.epiusers.help/u/Randy)\ **Post date:** [April 3, 2025, 12:09am UTC](https://www.epiusers.help/t/filtering-unused-reason-codes/51378/58 "2025-04-03T00:09:18Z")
In “UD Column Maintenance” but you have to have the rights to add UD fields. [Previous page](https://www.epiusers.help/t/filtering-unused-reason-codes/51378.md?page=2)