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?

 

 

faq94

 

 

 

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.

 

 

faq95

 

 

 

_____________________________________________________________

Send feedback about this topic to AutoCount. peter@autocountSoft.com

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