Skip to Content
avatar image
Former Member

Inventory valuatrion

Hi,

We have created different warehouses for a single item.Though the item cost is different for different warehouses it is showing the same prices in the for the item in all warehouses when running the inventory report.

Pls advise.

Rgds

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 04, 2008 at 01:01 PM

    Dear Mr Praveen,

    Can you tell me the following:

    -which valuation method you chose

    - if the Manage item cost by wahouse in the company details, Basic initialization tab under system initialization - administration is ticked or not

    - did you add documents in every warehouse or is there one where no documention (affecting the stock) was not added. What can you read int he item cost colum for that item?

    Thank you,

    Kind Regards,

    Marcella Rivi

    SAP Business One Forums Team

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Praveen,

      Yes, there is a problem since both Last Evaluated Price and also the Item Cost Price and Last Purchase Price lists are only one price list even though you manage Item Cost per Warehouse.

      The only thing I can recommend is to run a query on OITW to get the cost price for each Item in each warehouse.

      -


      SELECT T0.ItemCode, T0.WhsCode, T0.AvgPrice

      FROM OITW T0

      ORDER BY T0.ItemCode, T0.WhsCode

      -


      Please note that this will not work for Items that are managed by FIFO as their cost price is not kept in OITW.

      To get teh next open layer for each FIFO item per warehouse and the cost price that is going to be used, run trhe query below, the query will only contain FIFO items:

      -


      SELECT

      MIN(T0.transnum), itemcode, warehouse, openqty, calcprice

      FROM OINM T0

      WHERE

      openqty <> '0'

      Group by itemcode, warehouse, openqty, calcprice

      -


      Last Evaluated Price is also updated after running the Inventory Audit Report.

      Hope it helps.

      Jesper Magnusson