Hi. I want to get items that have not saled within previous one year. Please give me some advice if anyone has experience

There's more than one way to skin a cat: • Create a search to find slow moving inventory, depending on what you are using that could involved inventory counts or inventory transfers etc, you need to consider if your inventory is old simply because you don't sell it but what if you did a inter-company transfer order etc?(many factors). • You can create an Inventory search for Items not present in Transactions in the last year. Please notice you can search for Item in two different main ways: • Transaction Search to get Items information. • Item Search to get transaction information if any via transaction line or something similar(from the top of my head).

thank you @alien4u. In this project, I've already added a saved search. This search returns average sales price for each items. My total purpose is to set avg sales price to item record. And even if, there is no sales transaction within previous one year, I want to set 0.