Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
4432 Zobrazení

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
Zrušit
Autor

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

Nejlepší odpověď

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
Zrušit
Nejlepší odpověď

any solutions ? i have the same problem

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
srp 25
202
0
čvc 25
354
2
čvn 25
1390
1
kvě 25
1404
0
bře 25
1246