Create Report catalog items that have not been used in the last 18 months

Gouse Masthan S
Kilo Contributor

Create Report catalog items that have not been used in the last 18 months

2 REPLIES 2

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

Create a report on sc_cat_item table with the below condition:-

 

Saurav11_0-1669534023191.png

 

This report with give you all the items which has not been ordered in the last 18 months.

 

Please mark my answer as correct based on Impact.

Hello,

This does not work for the date part.

Thanks,

Chad