Friday, February 8, 2019

Item Saved Search providing standard costing item in a particular work order that has no Inventory Cost Revaluation yet

1. Navigateto Lists > Search > Saved Searches > New.

2.Select Item from the New Saved Search list.

3. On theSaved Item Search page, go to Criteria tab > Standard subtab.

4. Set thefollowing filters:

Type is anyof Assembly/Bill Of Materials, Inventory Item

Costing Method is Standard

5. Go to Summarysubtab.

6. Setthe following summary filters:

Sum Formula(Numeric) is 0 case when {transaction.type}='Inventory CostRevaluation' then 1 else 0 end
Sum Formula (Numeric) is not 0 case when{transaction.type}='Work Order' and {transaction.number}='enter the workorder number here' then 1 else 0 end

7. Go to Resultstab > Columns sub tab.

8. Retainthe Name column and select Group for its Summary Type.

9. Give thesearch a unique name.

10. Save& Run.

No comments:

Post a Comment