How to deal with the "It is not possible to unreserve more products of ... than you have in stock" in Odoo.

If you're experiencing this issue, you can do the following steps to fix it:

Install this module on your testing instance.
Run the workflow for updating the "Force Qty" and then try to cancel/close the stock.picking.

What causes this error

There can be several reasons for this error, but the most common ones seem to be:

Changing the UOM of the product.
Updating the inventory after changing the UOM.
In both cases, Odoo thinks that you don't have enough product on hand to move the stock.picking record. Simply updating the on-hand inventory will not fix the issue. Due to the fact the 'reserved_quantity' is not updated on the front end.

Prevention

To prevent this error from occurring, you should follow these best practices:

Don't update the UOM in between inventory updates.
When updating the on-hand inventory, it's a good idea to unreserve any stock.picking records.

Here is the github repo.
https://github.com/thetrebelcc/Force-OverWrite-All-QTYs

Follow me on twitter more Odoo/Python

https://twitter.com/tunahorse21?t=ZzU5NNgL0YvTSRpy-6NThA&s=09