Skip to Content

Item Cost not present in Item master data in warehouses

Hi Experts,

I am using SAP B1, I have seen few of my items in item master data is without item cost in warehouses, what could be the reason ? the item has purchase price and we have done GRPO but there is no item cost showing.

Pls let me know how I can have item cost for all these items in item master data.

Thanks

Suman

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2014 at 11:14 AM

    Hi,

    Check if those items as defined as "Inventory Item".

    Beni.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2014 at 12:13 PM

    Hi SK R,

    What is your valution mathod - FIFO aur Moving average.

    Did you check Inventory audit report properly?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 22, 2014 at 12:34 PM

    Hi,

    Please check this thread http://scn.sap.com/thread/3452722

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2014 at 11:15 PM

    Hi Suman,

    Make sure the item your have GRPO is on the warehouse you are checking.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 24, 2014 at 02:10 AM

    Hi Suman,

    If you want to have item cost for all warehouses in the item master data, you must choose or tick 'Manage Item Cost per Warehouse' tick box in the Company details.

    If you have ticked it, you must check the stock audit report to know the cost whether it is available or not.

    if there is no item cost in the stock (inventory) audit report, I am afraid this issue is affected by sapnote 1295350 - How to identify items which have no item cost?


    If the sapnote is correct, you must escalate this incident to SAP global support.



    Rgds,


    Jimmy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 24, 2014 at 03:23 AM

    Hi,

    Please Refer SAP Note: 1295350


    In SAP Business One once the items are created their stock can be updated via a Goods Receipt PO or an AP Invoice not based on Goods Receipt PO, a Goods Receipt from inventory or a stock take or stock posting. If any of these documents are posted without an item price, the stock of this item will be created without a cost price.

    Cause
    Consulting
    Solution
    An item without item cost cannot be released from the stock when the check box 'Allow Stock Release without Item Cost' (Administration ->
    System Initialization -> Company Details -> Basic Initialisation tab) is checked.

    In order to find the items without cost please run the following query (also attached):

    /* The first query calls the item from OITM where they are not managed by warehouse as there will be one cost price for all warehouses. It also checks that there is stock for this item*/
    SELECT
    distinct T0.[ItemCode],
    T0.[DfltWH], /*Default warehouse*/
    T0.[AvgPrice], /*cost price*/
    T0.[OnHand] /*Quantity in Stock*/
    FROM
    OITM T0
    WHERE
    (T0.[AvgPrice]is Null or
    T0.[AvgPrice] = '0') and /*select all items without a cost price*/
    T0.[OnHand]>=0 and /* Select all the items with a stock greater than 0*/
    T0.ByWH ='N' and /*Select all the items which are not managed by warehouse*/
    T0.EvalSystem <> 'F'

    Union ALL/*join the two queries refer to MSSQL online help*/

    /* When the item is managed by warehouse, each warehouse has it's own cost price. The second query will call all those items managed by warehouse and check the stock of those items*/
    SELECT
    distinct T0.[ItemCode],
    T0.[WhsCode], /*Will specify the exact warehouse where there is no item cost*/
    T0.[AvgPrice],/* cost price*/
    T0.[OnHand] /*Quantity in Stock*/
    FROM
    OITW T0
    inner Join
    OITM T1 on
    /*The information regarding the management of the item by warehouse is only available on OITM. The two tables need to be joined.*/
    T0.ItemCode = T1.ItemCode
    WHERE (
    T0.[AvgPrice]is Null or T0.[AvgPrice] = '0') and /*select all items without a cost price*/
    T0.[OnHand]>=0 and /* Select all the items with a stock greater or equal to 0*/
    T1.ByWH = 'y' and /*Select all the items which are managed by warehouse*/
    T1.EvalSystem <> 'F'

    Union ALL

    /* This query will help to find the item valuated by FIFO. The FIFO cost prices are not stored in OITM or OITW.*/
    SELECT
    distinct T0.[ItemCode],
    T0.Warehouse, /*Will specify the exact warehouse where there is no item cost*/
    T0.calcprice,/* cost price*/
    T1.[OnHand]

    /*Quantity in Stock- this is not the quantity per layer. OINM will need to be queried to find the amount of layers and the quantity per layer*/
    FROM
    OINM T0
    inner Join
    OITM T1 on

    /*The information regarding the valuation method is available on OITM. The two tables need to be joined.*/
    T0.ItemCode=T1.ItemCode
    inner Join
    OITW T2 on
    T0.Warehouse = T2.WhsCode and
    T0.ItemCode=T2.itemCode and
    T1.itemCode= T2.Itemcode
    WHERE
    (T0.CalcPrice is Null or T0.CalcPrice = '0') and /*select all items without a cost price*/
    T1.[OnHand]>=0 and /* Select all the items with a stock greater or equal to 0*/
    T1.EvalSystem = 'F' /* will only call the items valuated by FIFO*/

    /*To identify which layers and which documents are affected for the FIFO items the following query can be used. */
    SELECT
    T22.Transnum, /* identify the transaction*/
    T22.Transtype, /* Identify the document type eg Goods Receipt PO*/
    T22.createdby,/* Journal Entry reference*/
    T22.Base_ref, /* Document Number*/
    T22.Itemcode,
    T22.Inqty,
    T22.OutQty,
    T22.price,
    T22.Calcprice,/* Cost price*/
    T22.openQty
    FROM
    OINM T22
    WHERE
    T22.itemcode in ('XX', 'XXX') and /* List of affected FIFO items*/
    T22.inqty <> T22.openQty and
    (T22.CalcPrice is Null or T22.CalcPrice = '0')

    If the query should return results, please contact your accountant in order to decide of the cost of the item and then reavalute them.
    Stock Management -> Stock transaction ->Stock Revaluation.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.