Inactive Inventories

Is there any way to delete all inactive inventories with no sales history or is this a bad idea?

Thanks...

Tom

Reply to
RMS
Loading thread data ...

Hi, Yes it is somehow, however if you wanted to do so make sure no orders are there, no onhold are there, no sales are there. then you need to create on SQL query to delete all of them.

Well discuss with your management you wanted to do so may be you need the few items which are inactive in future. I can write you one small query which check the items are inactive and no sales there

delete from item where ID not in (select ItemID from TransactionEntry) and Inactive=1 and Quantity=0;

if help rate pls.

"RMS" wrote:

Reply to
Akber Alwani

If you have an inactive item in your database that has never been ordered, received or sold, thengo ahead and delete it.

If the item(s) in question have ever been received into inventory, then you should probably leave them alone.

Just my $0.02.

Tom

Reply to
Terrible Tom

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.