Item batch - How to uncheck Controlled by Batch No usign SQL Query ? |
Top Previous Next |
Question:
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?
Answer:
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. peter@autocountSoft.com © 2010 Auto Count Sdn Bhd - Peter Tan. All rights reserved.
|