Skip to Content
Menu
This question has been flagged
2 Replies
2882 Views

Hi, 


one of my products, managed by serial numbers, is blocked. 
When i want to perform a delivery it states: It is not possible to reserve more products of 'XX' than you have in stock.

However, that serial number is on the correct location. It is reserved but I am not able to unreserve (normally there is button if it reserved by a MO/internal transfer/...)
Can anyone help me on this? this serial nr is fully blocked




Many thanks for this! 


Avatar
Discard
Author

Hi,

For me it was due to installation of a custom module for serial numbers..
I would suggest to raise a support ticket at Odoo. They were very helpful for my past issues

Best Answer

Hi,
You can just check it out in staging or test db and see if it works.

* there will be a picking with non done state having this product
* find the picking having this product
* find the stock move line id and execute a query to update the product_qty as 0 and product_uom_qty as 0 for this move line id
* now click unreserve button in the picking

Query sample:
update stock_move_line set product_qty = 0, product_uom_qty=0 where id in (375312,375313)


Thanks

Avatar
Discard
Best Answer

any solutions ? i have the same problem

Avatar
Discard
Related Posts Replies Views Activity
0
Mar 25
408
1
Feb 25
499
1
Jan 25
479
0
Jan 25
426
0
Nov 24
10