Follow the instructions in this document to reset the stock units from negative to zero
Negative units are created when you bill an out-of-stock item. Refer to the image below:
![](https://www.saleculator.com/wp-content/uploads/2021/09/image-12.png)
Procedure:
- Open MySQL command prompt (Windows), mysql -u root -p from root (Raspberry)
- Password is password
- Type
use SALECULATOR;
And press the Enter Key - From the MySQL command prompt type the below query
UPDATE STOCKCURRENT SET UNITS=0;
And press the Enter Key - Type exit and press the Enter Key
![](https://www.saleculator.com/wp-content/uploads/2021/09/image-13.png)
6. Restart the system and check the inventory now
![](https://www.saleculator.com/wp-content/uploads/2021/09/image-15.png)