How to import item standard costs AX 2012

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:

  1. Import a standard cost for each site (referencing the Site Inventory Dimension Number on each row of the import spreadsheet).
  2. 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.
  3. 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 ….

Costing versions

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

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.

Excel import

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).


Advertisements

6 thoughts on “How to import item standard costs AX 2012

  1. I’m getting the dreaded “The date is fixed on the version” error when attempting to publish from Excel. I’ve tried formatting the date, using an integer value….nothing is working. Any ideas? Thanks

    Like

  2. Hi,

    When I was trying to copy item price between two same versions system was throwing the error:”From and to version may not be the same”.
    Can you please help me on this.

    Like

    • Hi Tulasi. I don’t have access to the system at the moment – but I do remember being caught by this error. Just start the Copy process from the other Version – but, apologies, I can’t remember whether you have to start from the ‘From’ or ‘To’ version.
      Tim

      Like

  3. Hi,
    When I try to copy cost price between same version system was throwing the error:From and to version may not be the same.
    Can you please help me on this.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s