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) = 0
  • Formula: CASE WHEN {iswip} = 'T' and {linesequencenumber} = 1 THEN 1 ELSE 0 END

Note: You can add/remove criteria as necessary.

Results tab:

• Date
• Document Number
• Item
• Quantity
• BOM Quantity
• Bill of Materials; Name
• Bill of Materials Revision: Name

Note: You can add/remove columns as necessary.

Related Threads: