make items inactive

Posted by faiz on November 9, 2007, 1:38 pm

Please log in for more thread options

I just finished updating the inventory and also putting the word UPDATED in
sub-description3. I have some items left that are not updated and would like
to make them inactive. I was thinking of running sql statement to make the
item inactive that is not updated in sub-description3 and also set the qty-on
hand to zero.
Need help with the sql statement.

Posted by convoluted on November 9, 2007, 2:13 pm

Please log in for more thread options

Hello Faiz...if you have items that have a quantity greater than zero, it
means they were received on a PO or on a transfer in - I would not recommend
you use a sql statement to set the qty to zero as you will not have any
visibility or audit trail in the system for that change - you can start a
physical inventory file in SO manager, apply a filter that selects items that
do not have the word "UPDATED" in subdescription 3, then zero out these qties.

The SQL to set the items to inactive can be something along these lines
BACKUP FIRST and try after hours if possible

UPDATE ITEM
SET INACTIVE = 1
WHERE SUBDESCRIPTION3 <> 'UPDATED'

Hope this helps...

"faiz" wrote:

> I just finished updating the inventory and also putting the word UPDATED in

> sub-description3. I have some items left that are not updated and would like

> to make them inactive. I was thinking of running sql statement to make the

> item inactive that is not updated in sub-description3 and also set the qty-on

> hand to zero.

> Need help with the sql statement.