Modify stock through mysql

ERPNext Stock/Inventory
, ,
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.

fail%20
fail%201738×1530 196 KB

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