Hello,
I used the new data migration tool to load in items into AX 2012. Looks like the migration tool didn't run the insert method on inventtable and so it did not create records for that product in InventItemSalesSetup, InventItemInventSetup and InventItemPurchSetup and so the default orders settings form is greyed out.
I ran a job after to create these records. The records are created correctly in the table but when I open the default orders settings form for the product, all fields are still greyed out as if no records exists.
Has anybody faced this problem? Am I missing a table or something when I create these records through x++?
Any help would be appreciated.
Thanks,
CJ
*This post is locked for comments
you can import data from excel in this table
1. InventItemInventSetup
2. InventItemPurchSetup
3. InventItemSalesSetup
with dimension allblank
Hi Fadi,
Check here if you want to get DIXF to do this for you:
community.dynamics.com/.../missing-default-order-settings-with-dixf-products-import.aspx
Hi,
the solution is to find a way (excel add's in, SQL, AOT) to update the following tables:
1. InventItemInventSetup
2. InventItemPurchSetup
3. InventItemSalesSetup
you need to update this column "InventDimIdDefault" with the value of "AllBlank" for all the items that you have imported.
this everything will work fine, and thanks MS.
regards
Same fun is here with me :)
If anyone experiencing this problem has access to Microsoft Connect, you can vote up that these tables get added to the Products entity:
If you don't have permission to view, please first find Dynamics AX in the list of 'products accepting suggestions' and 'join'.
I got it to work using the following code, hope it helps!
inventDim1.InventSiteId = "ABC";
.
.
inventDim = inventDim::findOrCreate(inventDim1);
//InventItemSalesSetup
inventItemSalesSetup.clear();
inventItemSalesSetup.initValue();
inventItemSalesSetup.ItemId = itemId;
inventItemSalesSetup.InventDimId = inventDim::inventDimIdBlank();
inventItemSalesSetup.InventDimIdDefault = inventDim.inventDimId;
inventItemSalesSetup.insert();
//InventItemInventSetup
inventItemInventSetup.clear();
inventItemInventSetup.initValue();
inventItemInventSetup.ItemId = itemId;
inventItemInventSetup.InventDimId = inventDim::inventDimIdBlank();
inventItemInventSetup.InventDimIdDefault = inventDim.inventDimId;
inventItemInventSetup.insert();
//InventItemPurchSetup
inventItemPurchSetup.clear();
inventItemPurchSetup.initValue();
inventItemPurchSetup.ItemId = itemId;
inventItemPurchSetup.InventDimId = inventDim::inventDimIdBlank();
inventItemPurchSetup.InventDimIdDefault = inventDim.inventDimId;
inventItemPurchSetup.insert();
Thanks,
Charu
Hi Baskaran,
Thanks for your help, I tried this but did not solved the issue, did anybody tried it?
Mansoor Adeel
Have same problem, will appreciate any help.
Mansoor Adeel
I have resolved this issue by importing data into these three tables (through SQL)
1. InventItemInventSetup
2. InventItemPurchSetup
3. InventItemSalesSetup
The rule is that for every item, you need to have two lines with proper dimension IDs. Originally when I imported the data through DMF, these three tables did not populate.
I too face similar problem after migrating data using the recently released Data Migration Framework. Appreciate any help on this. Thanks
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156