Sunday, January 6, 2019

Standard Costing : Search that Will Display the Effective / Current Standard Cost Per Location of an Item Together with Its Effective Date

Standard Costing : Search that will display the effective / current standard cost per location of an item together with its effective date

Solution:

1. Go to List > Search > Saved Searches > New

2. Select Item

3. Criteria tab > Standard Subtab - Add the following fields

-- Transaction : Type = is Inventory Cost Revaluation

-- Transaction : Cost Component Amount = is greater than or equal to 0.00

4. On the Results tab - Add the following

-- Transaction : Date > Group

-- Transaction : Period > Group

-- Transaction : Number > Group

-- Transaction : Location > Group

-- Transaction : Item > Group

-- Transaction : Cost Component Standard Cost > Sum

5. Click Save and Run

No comments:

Post a Comment