Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I've managed to import data into the InventItemPurchSetup, InventItemSalesSetup and InventItemInventSetup tables. However, when I drill into a product's Default Order Settings window, all of the fields are empty and greyed out.
1) Why would the fields be empty?
2) Why would the fields be greyed out? Would fixing #1 solve this issue?
Check your inventdimid and inventdimidefault fields. For default order settings, the inventdimid field should not contain any dimensions (ie all blank) and the inventdimiddefault field can only have the siteID (although anything else is probably ignored but that's how it should be).
Dynamics AX MVP | My Blog | Sikich | Twitter @JorisdG
Keane, when I had this issue, it was because an item did not have a default location. I added a record with an inventDim of AllBlank and it was happy again.
In case anybody else has this problem, the key to fixing my issue was a combination of what Joris and Janet said.
Some of the dimension fields were incorrectly blank (probably a result of a botched export). Once I re-imported the data into the 3 tables with the appropriate data (including corrected inventDimIds with matching dimension information), the Default Order Settings fields were filled and enabled where appropriate.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics