How to Untick Stock Control If the stock is already used ?

Reminder: Please do not simply proceed with this action if you are not clear. If you really want to proceed this, please run a backup first. 


These are the steps to follow:

• Tools > Database Utility > Database Utilities > Connect > Choose server name and Database > Click Ok > Click Support > Click Data > Click New Query
• Type: Select *from stocks update stocks set stockcontrol ='0' where stockcode ='(Stock #)' 
• (Kindly replaced the 'Stock#' to your Stock #)

• Go to Tools > Database Utility > Database Utility > (QNE.ERP.DatabaseUtils.exe) > Click Yes  

• Click Connect

• File in the Server Name and Database > Click OK

• Click Support

• Click Data

• Click New Query

• Type: Select *from stocks where stockcode ='ASUS-EX' 
  (Replace ‘ASUS-EX’ to your Stock# that you wanted to unticked the Stock Control)
•   system display the item you want to edit. Please double confirm

          
Update stocks set stockcontrol ='0' where stockcode ='ASUS-EX'

• Then run this script 
• Now Click Execute and you can see the particular stock item is already Unticked/Uncheck

Now, 

• Get back at the Stock Items > Click Refresh

• Done