A report for Purchased material which is not used yet!

[Former Member]

Dear All,

We need a report for Purchased material which is not used yet.

How is it possible in SAP B1?

Thanks in advance........

[vasileiosfasolis · Accepted solution]

Hi Param

Try this

SELECT 
T0.ItemCode
, T0.ItemName
, t2.onhand
, t3.cardname
, t4.price
, (t2.onhand*t4.price)
FROM 
OITM T0 
inner join oitw t2 on t0.itemcode=t2.itemcode 
inner join ocrd t3 on t3.cardcode=ISNULL(t0.CARDCODE,80566) 
inner join itm1 t4 on t0.itemcode=t4.itemcode 
where 
t0.itemcode not in (select t1.itemcode from oinm t1 where t1.transtype <> '-2') and (T0.ItmsGrpCod ='141' OR T0.ItmsGrpCod ='203') and t2.whscode='01' and t4.pricelist='27'
order by t0.itemcode

i use the above for my expectations and works perfect

try to change some values such as whscode, pricelist etc

[Former Member]

Thanks....

Edited by: Param Deshwal on Oct 20, 2011 10:56 AM

[Former Member]

Hi Param......

Did you check Inactive Item Report?

Please check this report through Inventory> Inventory Reports> Inactive Items.......

You get your solution.......

Regards,

Rahul