Can we get a cost of Phantom items

[Former Member]

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

[Former Member · Accepted solution]

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?

[former_member1269712 · Accepted solution]

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

[Former Member]

No costs are coming through.

[Former Member]

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

[Former Member]

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