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

I placed a SO that via MTO+MTS created PO for some items that were in stock and for some not.

I did not expect any PO for products that were in stock.

In the Inventory delivery order, for the products that were reserved from stock i see these details:

Conditions

Supply Method Default: Take From Stock

Reserved
Availability 1.0 (reserved)


While for the products where it went wrong i get:


Conditions

Supply Method Advanced: Apply Procurement Rules
Reserved
Availability 4.0


as you can see, the products are available ... but not reserved.


Any idea what is wrong and how i can force the reservation and cancel the PO ?

Avatar
Zrušit
Nejlepší odpověď

I have solved this issue by changing the procure method of the transfer and deleting the origin movement of it.

This happens when a transfer links to other transfers created through procurement rules, if any of this created transfer is cancelled the first transfer can't find what needs through it procurement method, in this case MTO.

I don't know how to change it in odoo but i've made the changes in the db:

do $$
declare move int:=1156309; /* This is the id of the transfer with the issue */
begin
delete from stock_move_move_rel where move_dest_id= move;
update stock_move set procure_method='make_to_stock' where id= move;
end $$

Avatar
Zrušit
Autor Nejlepší odpověď

The strange thing is that in the products "Forecasted" has been updated with the quantity in the order ... but they are not reserved.

Avatar
Zrušit

Hi Jaco, please check my answer and try it out!