Skip to Content
avatar image
Former Member

Can we get a cost of Phantom items

Hi Experts,

We have been using SAP for about 18 Months now and are getting to the stage where we would like to take a more indepth look at our proudct costs. We currently have been doing this by looking at the BoM screen on SAP B1 and switching all the components to last purchase price and then totalling them up. However we have come across some problems;

Are BoMs are multiple level and so are quite complex we have Boms setup as phantom items, which i cant seem to get a cost for either when i set the item price to last purchase price or last calculate price. Any ideas of how we could get a up to date cost of a phantom?

This has made me consider whether the BoMs screen is the best way to get these costs? Does anyone have any suggestions on where to go to get an up to date cost of a multiple level Bom?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 21, 2010 at 10:48 AM

    So to get true costs do we go to the Bill of Material Report, or we do we need to write a query that will bring through all the prices?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi David,

      Try this...

      select Father As 'itemCode',Sum(Cost) Cost 
      from (select t1.Father,t1.Code,T1.Quantity,T2.AvgPrice,(T1.Quantity*T2.AvgPrice) cost from itt1 t1
      inner join oitm T2 on T1.code=t2.Itemcode) a inner join oitm T3 on a.Father=T3.itemcode 
      where T3.Phantom='Y' group by father

      Thanks

      Sachin

  • avatar image
    Former Member
    Sep 20, 2010 at 01:36 PM

    Hi,

    BOM is only a template. The cost displayed on BOM screen may not be true cost of the item.

    For phantom items, you may create a query report to get a cost.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 04:00 AM

    Hi David......

    As its not an inventory item so you can not get the cost of phantom item but you may get it via BOM report.......

    And its the combination of Unit Cost of Child Components

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 12:05 PM

    No costs are coming through.

    Add comment
    10|10000 characters needed characters exceeded