1. I need to build a saved search to find items that have not sold in 6 months, have no order and have no inventory in any location ? 2. Similar to this I also want to create saved search with Inventory and have not sold within 1 year ?

Do a search for items sold and use COUNT as summery in result to show how many units sold in a time span. In the criteria use a condition to exclude any item count over zero, then it will show only items with 0 count, in theory it should work. You can also do that by using SQL formula too