Friday, May 31, 2019

Saved Search to show the Current Effective Standard Cost vs the Location Standard Cost for non zero items

1. Go to Lists > Search > Saved Searches > New.
2. Select Item.
3. On the Criteria Tab, add the below Filters:
--Costing Method is Standard
4. On the Results Tab, add the below Fields:
--Location On Hand
--Location Standard Cost
--Location Average Cost > Custom Label: Current Effective Standard Cost
5. Rename the Report.
6. Click Save & Run.


Note that this is currently logged under Enhancement: 227219: Standard Costing : Display the effective / current standard cost per location on the item record together with its effective date.
This Alternate Solution will show the Current Effective Standard Cost provided that Location On Hand is not zero.

No comments:

Post a Comment