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