Scenario
User is trying to create a Saved Search that will list Assembly items that does not have a Bill of Material Linked to it.
If the user adds the field "Assembly Item Bill of Materials: Bill of Materials" to the Results tab of an Item Saved Search, the assembly items with no BOM does not appear in the search.
There is an existing enhancement related to this behavior:
- Enhancement # 643878: Searches > Item > Criteria > Assembly Item Bill of Materials Fields: Bill of Materials > is None : To have the ability to show Assembly Items that do not have BOM
Workaround
As an alternate solution, you can create 2 saved searches:
Saved Search # 1:
Item Saved Search with Type = Assembly in the Criteria tab of the Search
- This will give the list of ALL the Assembly Items
Saved Search # 2:
Item Saved Search similar to Saved Search # 1, then add the field "Assembly Item Bill of Materials: Bill of Materials" to the Results tab of the search
- This search will provide the list of Assembly Items which have Bill of Materials associated to them
Next step is to export these searches and use a program like MS Excel to compare the results using VLOOKUP or MATCH.
Note: It is suggested to add the Internal ID field in the Results of the saved searches, so you can have a unique key or basis when comparing the results.
Assembly Items which are found in Search # 1 but are not in Search # 2 are those items which have no BOM linked to it.
-----
If you find this information useful, let us know by reacting or commenting on this post!