Share
ReportHow can I exclude Discontinued Items in the Item Lookup window for Bill of Materials?
Cards >> Inventory >> Bill of Materials
*This post is locked for comments
You’re offline. This is a read only version of the page.
3,812
How can I exclude Discontinued Items in the Item Lookup window for Bill of Materials?
Cards >> Inventory >> Bill of Materials
*This post is locked for comments
Hi Max,
You can add a generic discription for all discontinued items and sort by that so you will know the items is dicontinued so user can ignore the same.
Hello Max
Unfortunately, I have faced the same issue with no out of the box solution. You do know that there is a feature to exclude inactive and discontinued items, but it seems they've forgotten the "component item" lookup in the BOM window :)
In case you are not looking for a customization through which you can definitely handle what's retrieve by the lookup window, you may consider a work around solution by adding the letter "Z_" for instance as a prefix for the "short description" field for any discontinued items, this will push those items down the list as shown below:
I did automated the process by creating a bunch of triggers on the IV00101 table to update the short description field to include this prefix once the item is set to discontinued or inactivated.
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
