Skip to main content

Notifications

Microsoft Dynamics AX (Archived)
Answered

Default order settings for released products Dynamics AX 2012

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at
    RE: Default order settings for released products Dynamics AX 2012

    you can import data from excel in this table

    1. InventItemInventSetup

    2. InventItemPurchSetup

    3. InventItemSalesSetup

    with dimension allblank

  • Guy Terry Profile Picture
    Guy Terry 28,673 Super User 2025 Season 1 on at
    RE: Default order settings for released products Dynamics AX 2012

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Default order settings for released products Dynamics AX 2012

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Default order settings for released products Dynamics AX 2012

    Same fun is here with me :)

  • Guy Terry Profile Picture
    Guy Terry 28,673 Super User 2025 Season 1 on at
    Re: Default order settings for released products Dynamics AX 2012

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Default order settings for released products Dynamics AX 2012

    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

  • Mansoor Adeel Profile Picture
    Mansoor Adeel 840 on at
    Re: Default order settings for released products Dynamics AX 2012

    Hi  Baskaran,

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

    Mansoor Adeel

  • Mansoor Adeel Profile Picture
    Mansoor Adeel 840 on at
    Re: Default order settings for released products Dynamics AX 2012

    Have same problem, will appreciate any help.

    Mansoor Adeel

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Default order settings for released products Dynamics AX 2012

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Default order settings for released products Dynamics AX 2012

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans