Friday, January 28, 2011

Item has no parameter for inventory

http://dynamicsuser.net/forums/t/32717.aspx

2 comments:

  1. Check, item does not exists in 1st 3 tables, where it should exists in all 6 below tables.
    (Regards - Sunil Khalapurkar)
    select * from InventItemInventSetup where itemid='ITEMID'
    select * from InventItemSalesSetup where itemid='ITEMID'
    select * from InventItemPurchSetup where itemid='ITEMID'
    select * from InventTable where itemid='ITEMID'
    select * from InventTableModule where itemid='ITEMID'
    select * from InventItemLocation where itemid='ITEMID'

    ReplyDelete
  2. It exists in all 6 tables so whats the problem?

    ReplyDelete

Leave your comments and solutins