Item batch - How to uncheck Controlled by Batch No usign SQL Query ?

Top  Previous  Next




I have mistakenly checked the checkbox of 'Controlled by Batch No.' for all items... Instead of to uncheck it one by one at Stock Item Maintenance, can I use SQL Query to do so?









Go to AutoCount Accounting Management Studio, login to the same account book using ADMIN.

Go to Tools > SQL Query ..


Use the following query, then press Execute.








Send feedback about this topic to AutoCount.

© 2013 Auto Count Sdn Bhd - Peter Tan. All rights reserved.