Itemcost column table at warehouse level in item master

[Former Member]

I have an issues regarding the item cost in Item master --> Inventory Data tab when we select Valuation method either Standard or Moving average we can see the itemcost (Column) value at warehouse level but for FIFO method we cant see the itemcost column.

Can any one tell me in which table the itemcost value is stored for FIFO method.? I can see the itemcost of a FIFO valuation method only when i do issue for production there i will get item cost but i want to know the itemcost value at production order level only for FIFO method because based upon the itemcost only my process cost is calculated.

[lorna_real · Accepted solution]

Dear Pavan,

The Item Cost column is not shown in the Item Master Data for items using FIFO Valuation Method. This is because a FIFO cost layer is created as Items are received to stock. Hence, it is possible that for one warehouse, several FIFO layers exist (depending on the different FIFO cost).

You can also see this information in the Stock Posting List.

I hope the above helps.

Regards,

Lorna

[Former Member]

From Help File,

Note! cost price is not displayed in the Item Master Data when managing perpetual inventory by FIFO.

The Information regarding the FIFO cost price exists in the OINM (Warehouse Journal) table under the fields Calculated Price and Open Quantity.

Regards,

Dhana.