ERPNext Conference 2019* Blog

Modify stock through mysql



Hello! my developer moved several store items through mysql. The problem is that by changing them directly without making an order of sale, the stock of the products is not real. I give an example.

I need to modify the real stock and I think that only do it through the database. I’m a novice and I need help. Thank you


create the Purchase Receipt/Stock entry as a purpose is Material Receipt.


thx for answering so quickly, but the problem is that this item have serial number. then i can not create a new purchase/receipt.
is a problem with database


You can set auto create serial no