Inactive Inventories


R

RMS

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


Thanks...

Tom
 
Ad

Advertisements

A

Akber Alwani

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.
 
Ad

Advertisements

T

Terrible Tom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inactive 1
Inactive Items 2
inactive items 1
Inactive items showing up in Physical Inventory - Why????? 0
Inactive Clients 2
INACTIVE STORE 1
Inactive Payee? 0
Inactive Item 2

Top