unavailable item

[former_member193355]

Hi Experts,

How to see the unavailable item or inactive item using a query sql ? We want to know inactive item in the last year. In the report, we want to see the price and quantity per every warehouse. In the SBO std inactive item report, there is no price or warehouse data. Pls help.

Andre

[former_member193355]

Solved. Thank you

[Former Member]

Hi Andre,

Check this:

Thanks,

Gordon

[former_member193355]

Thanks for the queries but they are not what I am looking for.

I am very sorry that my question is not very clear. Actually I need inactive item query especially for item that have no transaction or stock mutation within two years ago. Pls help. Thank you.

Andre

[former_member193355]

Thanks for the queries but they are not what I am looking for.

I am very sorry that my question is not very clear. Actually I need inactive item query especially for item that have no transaction or stock mutation within two years ago. Pls help.

Andre

[Former Member]

Hi Steve

Try This....

SELECT T0.[ItemCode], T0.[ItemName], T1.[Quantity], T1.[Warehouse], T1.[Price] FROM OITM T0  INNER JOIN ITT1 T1 ON T0.ItemCode = T1.Code WHERE T0.[frozenFor] ='Y'

Thanks

Shafi

[Former Member]

Hi,

SELECT T0.[ItemCode], T0.[ItemName],T0.[FrozenFor] FROM OITM T0 INNER JOIN ITM1 T1 ON T0.ItemCode = T1.ItemCode where T0.[FrozenFor] ='Y'

try this... hope u can get qty and price from oitm..

regards,

Vignesh