AX4 - Excel Import to Items table not showing

martinleonardmartinleonard Member Posts: 5
edited 2008-03-19 in Dynamics AX
I'm trying to import items to INVENTTABLE and INVENTTABLEMODULE using the excel template wizard. I have completed the template and imported. However, none of the items appear in the item table in AX4.

If I look in the SQL table directly (enterprise manager) I can see the items listed, but they do not show in AX4.

Any help appreciated as I will be asked to import many of these!

Thanks,
Martin

Comments

  • martinleonardmartinleonard Member Posts: 5
    18 views, not a single response. hmmm......
  • martinleonardmartinleonard Member Posts: 5
    Solved. Need to import INVENTITEMLOCATION table also.
  • HarishHarish Member Posts: 172
    Hi Martin,

    I am glad you managed to fix your issue :)

    A tip - whenever you import data, make sure you run the consistency check job (available under Basic -> Periodic). You can check / correct errors related to data using this tool.

    Regards,
    Harish Mohanbabu
    Long way to go before I sleep..
  • martinleonardmartinleonard Member Posts: 5
    Good to know, thanks!
Sign In or Register to comment.