Answered

Default order settings for released products Dynamics AX 2012

(0) Share

Report

Posted on by Community Member

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,

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Community Member on at

Like (0)

Report

I too face similar problem after migrating data using the recently released Data Migration Framework. Appreciate any help on this. Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mansoor Adeel 840 on at

Like (0)

Report

Have same problem, will appreciate any help.

Mansoor Adeel

Was this reply helpful? Yes No
Mansoor Adeel 840 on at

Like (0)

Report

Hi Baskaran,

Thanks for your help, I tried this but did not solved the issue, did anybody tried it?

Mansoor Adeel

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (1)

Report

If anyone experiencing this problem has access to Microsoft Connect, you can vote up that these tables get added to the Products entity:

connect.microsoft.com/.../data-migration-framework-dmf-add-inventiteminventsetup-inventitempurchsetup-inventitemsalessetup-target-entities

If you don't have permission to view, please first find Dynamics AX in the list of 'products accepting suggestions' and 'join'.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Same fun is here with me :)

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you can import data from excel in this table

1. InventItemInventSetup

2. InventItemPurchSetup

3. InventItemSalesSetup

with dimension allblank

1 people found this reply helpful.

Was this reply helpful? Yes No