Scenario
User needs to create a saved search that would show the Work Orders and Components (Member Items) that were used in each.
Solution
This can be done by doing a simple Transaction Saved Search. Here are the details:
Criteria tab:
- Type = Work Order
- Main Line = False
- COGS Line = False
- Tax Line = False
- Formula (Numeric) = 0Formula: CASE WHEN {iswip} = ‘T’ and {linesequencenumber} = 1 THEN 1 ELSE 0 END
Results tab:
- Date
- Document Number
- Item
- Quantity
- BOM Quantity
- Bill of Materials; Name
- Bill of Materials Revision: Name