Actually you can use this method for all item cost prices, not just standard cost items. The only difference is that Standard costs must reference a costing version with a Costing type = ‘Standard cost’, and item’s which don’t’ use standard costs must use a costing version with a Costing type ‘Planned cost’
Note. A standard cost must be activated for each Site before an item may be received into that Site. You will notice a ‘Copy’ function on the costing version form, but this must be used to copy from one costing version costs on one site to another costing version for the cost at a different site, or from active costs to pending costs for another site.
Therefore there are three possible import and activation processes:
- Import a standard cost for each site (referencing the Site Inventory Dimension Number on each row of the import spreadsheet).
- Import the costs for a site. Activate the costs for that site. Copy the costs to pending costs for the other sites and activate the pending costs for the other sites.
- Create a cost version for each site. Import pending costs for one site/cost version. Copy those costs to other sites/cost versions. Activate all of the sites/cost version costs.
Option 2) is described in detail, as follows ….
Inventory and warehouse management > Setup > Costing > Costing versions:
Create ‘Standard cost’ costing versions as required.
Note. You may find it convenient to have a ‘Copy’ version in addition to the version used to activate the costs.
Standard costs are established for each item by import or BOM calculation.
Standard costs are seen at Product information management > Released products > Manage costs > Item price:
Note. This form displays Pending and Active cost prices.
You won’t import active costs, you’ll import pending costs and activate them.
Unfortunately you need to have System admin rights to import into a table using the excel add-in. If you want to give this function to ‘normal’ users you’ll have to create a customised Data import export framework ‘Target entity’.
Open Excel, connect to Microsoft Dynamics AX and setup an import template for the InventItemPriceSim table like:
Note that ‘Site’ on the table is mapped to ‘Dimension No.’ in the spreadsheet.
Add additional rows and ‘Publish data’:
Check your imported data
Inventory and warehouse management > Setup > Costing > Costing versions > Price > Item price:
Activate the costs
Inventory and warehouse management > Setup > Costing > Costing versions > Activate
Copy to other sites
Inventory and warehouse management > Setup > Costing > Costing versions > Copy > Copy item prices:
Complete the ‘Select’ filter query and Copy from and copy to options, like:
Click OK, and check new cost prices:
Repeat for each Site.
Activate the costs (as above).