View Standard Costing on Item Record

For reviewing standard cost byeffective date and planned standard cost, you can create these saved searchesto review the data and add them as sublist to the item record. Steps below are solution to this concern.

 

A. Search for displayingstandard cost by effective date

A.1. Navigate to Lists > Search >Saved Searches > New > Item

A.2. Navigate to Criteria tab >Standard subtab > Filter column > add Transaction fields… select Type, onDescription, select Inventory Cost Revaluation.

A.3. Navigate to Results tab > Columnssubtab > Field column > add the following:

- Transactions fields… select Date;on Summary Type column, select Group

- Transactions fields… select Location;on Summary Type column, select Group

- Transactions fields… select Item;on Summary Type column, select Group

- Transactions fields… select CostComponent Standard Cost; on Summary Type column, select Sum

On the Sort By field, selectTransaction: Date

Then By field, select Transaction:Item

A.4. Navigate to the Available Filterstab > Filter column> add the following;

- Internal ID (Number), on Label,type Name

- Transaction: Location

A.5. Enter preferred Search title

A.6. Click Save & Run

 

B. Saved Search for Cost by CostVersion

B.1. Navigate  to Lists > Search >Saved Searches > New > Planned Standard Cost

B.2. Navigate to Criteria tab >Standard subtab > Filter column > none selected

B.3. Navigate to Results tab > Columnssubtab > Field column > add the following:

- Standard Cost Version; on SummaryType column, select Group

- Location; on Summary Type column,select Group

- Item; on Summary Type column,select Group

- Cost; on Summary Type column,select Sum

On the Sort By field, select StandardCost Version

B.4. Navigate to the Available Filterstab > Filter column> add the following;

- Item: Internal ID

- Standard Cost Version; on theShow in Footer, tick checkbox to Yes

- Location; on the Show in Footer,tick checkbox to Yes

B.5. Enter preferred Search Title

B.6. Click Save & Run

 

C. Add sublist to item record

C.1. Navigate to Setup > Customization> Sublist

C.2. Navigate to Item tab > and selectthe following:

- On the Search column, select theItem Record: Effective Date Std Cost; on the Label, type – Std Cost View; onTab column, select Inventory; on the Inventory Item and Assembly/Bill ofMaterials put a tick to select Yes

- On the Search column, select theItem Record: Planned Standard Cost View; on the Label, type – Cost Version View;on Tab column, select Inventory; on the Inventory Item and Assembly/Bill of Materialsput a tick to select Yes

C.3. Click Save

 

After the steps above, you will now see the Standard Cost View on theitem record.

Notes:
1. Std Cost View and Cost Version View tabs contain Inventory Cost Revaluations and Planned Standard Costs respectively.
2. Custom roles should have at least a View level permission of the following to view the sublists contents:
2.1. Revalue Inventory Cost (Setup > Users/Roles > Manage Roles > find the role > Permissions tab > Transactions sub tab)
2.2. Planned Standard Cost (Setup > Users/Roles > Manage Roles > find the role > Permissions tab > Lists sub tab) 

3. On the Criteria subtab, please add Transaction fields...= Line greater than 1 if the customer is only using Inventory Items in order to avoid the inclusion of the Old standard cost in the Cost Component Standard Cost.