Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

Dynamics AX 2012 Products Import using Excel Add-in

by
on 17 Jan 2012
  • 0 comments

Error while updating multiple items through AIF

by
on 28 Jun 2012
  • Suggested Answer

Dynamics AX 2012 Excel Add-in - Tracking Dimensions

by
on 23 Feb 2012
  • 0 comments
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading to Microsoft Dynamics AX 2012


Microsoft Dynamics AX 2009

Application Object Server (AOS)

Enterprise Portal and Role Centers

Inventory Costing in Microsoft Dynamics AX 2009 

 Invoice Settlements/Discounts/Reversals

 SSRS and SSAS Integration

 Workflow

Default order settings for released products Dynamics AX 2012

This question is not answered
Charuhas Jadhav
Posted by
on 30 Oct 2012 9:39 AM

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

Dynamics AX 2012
All Replies
  • Baskaran Durai
    Posted by
    on 10 Dec 2012 7:00 AM

    I too face similar problem after migrating data using the recently released Data Migration Framework.  Appreciate any help on this.  Thanks
  • Baskaran Durai
    Posted by
    on 11 Dec 2012 6:07 AM

    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.
  • Mansoor Adeel
    Posted by
    on 11 Dec 2012 6:44 AM

    Have same problem, will appreciate any help.

    Mansoor Adeel

    Mansoor Adeel

    AX 2012 Techno Consultant
  • Mansoor Adeel
    Posted by
    on 12 Dec 2012 4:35 AM

    Hi  Baskaran,

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

    Mansoor Adeel

    Mansoor Adeel

    AX 2012 Techno Consultant
  • Charuhas Jadhav
    Posted by
    on 12 Dec 2012 7:45 AM

    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
  • GuyUK
    Posted by
    on 19 Dec 2012 3:49 PM

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