ERPNext Conference 2019* ERPNext.com Blog

Modify stock through mysql

bug
stock
mysql

#1

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


#2

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


#3

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


#4

You can set auto create serial no

Yes