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.