Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
2 Odpowiedzi
2822 Widoki
Awatar
Jaco

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 ?

Awatar
Odrzuć
Awatar
Karina
Najlepsza odpowiedź

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 $$

Awatar
Odrzuć
Awatar
Jaco
Autor Najlepsza odpowiedź

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

Awatar
Odrzuć
Karina

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