There are 4 tables, - inventory_item - inventory_item_detail - PhysicalInventory - Inventory_item_variance
I understand the use of the tables "inventory_item" and "inventory_item_detail" . In the physicalinventory table i can insert a line at for example 31 december 2010 when i will count my physical inventory with the reason. The i can insert in the table "inventory_item_variance" the link to the physicalinventory (physicalinventoryid) with the "inventoryitemid" and i want to insert here aivalabletopromiseVARIANCE value and the quantityonhandVARIANCE value. However this is not possible in the entity engine in frameworktools. How do i have to do it then? How does the thing works then? regards, Heidi 2010/11/9 James McGill <[email protected]> > On Tue, Nov 9, 2010 at 5:16 AM, pinaki_22 <[email protected]> > wrote: > > > > > What is the purpose of > > INVENTORY_ITEM_DETAIL table. > > > > InventoryItemDetail is equivalent to a credit / debit system for > quantities. Instead of tracking the quantity only in the InventoryItem, > the > Detail records provide a running total of transactions that can be audited > against the InventoryItem. > > If you want to manually change the ATP and QOH quantities, use the Variance > service. > > In a production system, variances will probably be rare, since inventory > should be created as a result of shipment receipts or work efforts. > > -- > James McGill > Phoenix AZ >
