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.
make items inactive
Nov 09, 2007
1 Replies
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'
H> I just finished updating the inventory and also putting the word UPDATED in
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required