Saved search to show the standard costing item in a work order with no Inventory cost revaluation

This search shows the standard cost item in a particular work order which have no Inventory cost revaluation yet.

To create the saved search, follow the steps below: 

1. Navigate to Lists > Search > Saved Searches > New
2. Click Item
3. Search Title:Enter Search Title
4. Click Criteria tab
5. Click Standard subtab
6. Filter:
   • Select Type
     1. Type: Select any of Assembly/Bill Of Materials, Inventory Item
     2. Click Set
   • Select Costing Method 
     1. Costing method: any of Standard
     2. Click Set
7. Click Summary subtab
8. Set the following summary filters:
   • Add Formula (Numeric) 
     • Summary Type: Sum
     • Formula: case when {‌transaction.type}=’Inventory Cost Revaluation’ then 1 else 0 end
     • Formula (Numeric): Select equal to
     • Value: Enter 0
     • Click Set
   • Add Formula (Numeric)
     • Summary Type: Sum
     • Formula: case when {‌transaction.type}=’Work Order’ and {‌transaction.number}=enter the work order number here then 1 else 0 end
     • Formula (Numeric): Select not equal to
     • Value: Enter 0
     • Click Set
9. Click Results tab
10. Click Columns subtab
11. Field:
    Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.
    • Select Name
      • Summary type: Select Group
    • Select Transaction fields…
      • Transaction field: Select Type
      • Summary type: Select Group
    • Select Transaction fields…
      • Transaction field: Select Document Number
      • Summary type: Select Group
12. Click Save & Run