Is there any way to delete all inactive inventories with no sales history or is this a bad idea?
Thanks...
Tom
Is there any way to delete all inactive inventories with no sales history or is this a bad idea?
Thanks...
Tom
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:
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
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.