Unused Items???

You could run a query, just make sure you backup first.

delete item where lastupdated < '03/01/2005' AND quantity < 1

This would delete items that haven't been updated in the last year and have a qty less than 1

Cheers

"V> My question is pretty simple, my database seems to keep growing, but I know

I would actually like to run a report that shows me what the actual unused items have been for the last year, and then personally I can go through and delete the ones that I know are no longer in the store. Is there a way to do that?

Vince,

If you have ever sold or received the item, no matter how long ago, it's a good idea to just mark it as inactive instead. That way your sales or movement history won't have blanks in it.

Good luck, Matt

Vince,

Here is a Memorized report for items that have never been sold and you can modify it for different dates. Copy it into your \Program Files\Microsoft Retail...\Store Operations\Reports folder and look for it in SO Manager | Reports | Memorized | No Sales Forever

The reason I think of deleting is because I was talking to my cousin, whom has a scanner system that only accepts 12,000 items, and his got maxed out, so he deleted everything, and started over ending up with a total of 5,400 items...so I thought that with so many unnecesary items that it will cause my database to run slower, and is probably not worth having old UPC codes???

Vince,

You are not going to have that problem! The # of items is basically unlimited. You may run into a database size limitation, but that will be partially fixed with the next RMS update/service pack scheduled for April/May to use SQL 2005 Express. That will double the maximum size of the database to 4 gig. If you get really big, you could upgrade to the full version of SQL 2005.

Thank you Jeff :) I appreciate your response as always.