Delete inactive items

Posted by geokar on November 3, 2006, 4:56 pm

Please log in for more thread options

Hi,

Can someone please give me a SQL Query make all On Hand quantities zero and
to delete all Inactive items? I am opening a new store and have copied my
database to the new location, but I don't think it's necessary to keep 3 year
old items on file.

Posted by jocelynp on November 3, 2006, 5:44 pm

Please log in for more thread options

I do not know your queries, but to delete all quantities (OH and negative)
you should just do a full physical inventory to set the qty = 0.

SO Mgr> Inventory> Physical Inv> Generate for all items> Calculate> Commit.

Then back report in HQ Mgr with a Request Full Inv Count and a task 190.
--
Jocelyn

"geokar" wrote:

> Hi,

> Can someone please give me a SQL Query make all On Hand quantities zero and

> to delete all Inactive items? I am opening a new store and have copied my

> database to the new location, but I don't think it's necessary to keep 3 year

> old items on file.

Posted by jocelyn on November 3, 2006, 5:47 pm

Please log in for more thread options

OK, here is your delete qty query from SO Admin:

*Backup first*

UPDATE Item SET Quantity = 0

I would also back report this one in HQ Mgr.

"geokar" wrote:

> Hi,

> Can someone please give me a SQL Query make all On Hand quantities zero and

> to delete all Inactive items? I am opening a new store and have copied my

> database to the new location, but I don't think it's necessary to keep 3 year

> old items on file.

Posted by geokar on November 3, 2006, 6:02 pm

Please log in for more thread options

Great,
Now how about deleting inactive items?

"jocelyn" wrote:

> OK, here is your delete qty query from SO Admin:

> *Backup first*

> UPDATE Item SET Quantity = 0

> I would also back report this one in HQ Mgr.

> "geokar" wrote:

> > Hi,

> >

> > Can someone please give me a SQL Query make all On Hand quantities zero and

> > to delete all Inactive items? I am opening a new store and have copied my

> > database to the new location, but I don't think it's necessary to keep 3

year

> > old items on file.

Posted by GregDxb on November 6, 2006, 1:48 am

Please log in for more thread options

hi,

normal procedure..before running any update or delete query, back up your
data..

this is the query to delete inactive items

* I assume that you have updated/set your item into inactive
---------------------------------------------
delete from item where inactive=1
---------------------------------------------
or if you want to delete 2000 year old data you can use this
---------------------------------------------
delete from item where (item.lastupdated <= CONVERT(DATETIME, '2001-01-01
00:00:00', 102))
--------------------------------------------

Run this query after backup is made successfully.

Good Luck

"geokar" wrote:

> Great,

> Now how about deleting inactive items?

> "jocelyn" wrote:

> > OK, here is your delete qty query from SO Admin:

> >

> > *Backup first*

> >

> > UPDATE Item SET Quantity = 0

> >

> > I would also back report this one in HQ Mgr.

> >

> > "geokar" wrote:

> >

> > > Hi,

> > >

> > > Can someone please give me a SQL Query make all On Hand quantities zero

and

> > > to delete all Inactive items? I am opening a new store and have copied my

> > > database to the new location, but I don't think it's necessary to keep 3

year

> > > old items on file.