Project:
View Revisions: Issue #28051 | [ Back to Issue ] | ||
Summary | 0028051: Reserved quantity is not correct under certain circumstancies | ||
Revision | 2015-02-26 18:54 by umartirena | ||
Steps To Reproduce | Reservations are disabled by default. To be able to use them please insert a new Preference using property Enable Stock Reservations with value Y. http://wiki.openbravo.com/wiki/Stock_Reservation [^] As group Admin role, Go to Physical inventory and remove the stock for Cerveza Lager. Keep 700 units in Warehouse España Región Norte 0-0-0 Go to Sales Order window, Org: España Lines: Cerveza Lager: qty: 900 Stock Reservation: blank Book it. Once you select the line, you will see Manage Reservations button. Click on it, and indicate you would like to reserve 400 units. Click on Done. Go to Stock reservation window. Realize that the register created indicates 700 units, but the user said 400. That is wrong. If you manage Stock again from the Stock Reservation window, and you indicate 400, now the register has the correct qty. Also, test the following flow in Oracle: Create a Sales Order with a line. Click on that line and press Manage Reservations. * Click on Cancel. * Go to Linked Items of that line and realize that a reservation has been created. This is wrong because we've selected cancel in the P&E. This happens because M_RESERVATION_POST commits, as explained in the description above. |
||
Revision | 2015-02-26 18:54 by umartirena | ||
Description | Reserved quantity is not correct under certain circumstancies. Also, the behavior in Oracle differs from Postgres. In Oracle when opening Manage Stock P&E, it automatically creates and processes the reservation, even if the Done button is not clicked. This happens because in Oracle M_RESERVATION_POST stored procedure automatically commits against database, unlike in Postgres. |
||
Revision | 2015-02-26 18:45 by umartirena | ||
Steps To Reproduce | Reservations are disabled by default. To be able to use them please insert a new Preference using property Enable Stock Reservations with value Y. http://wiki.openbravo.com/wiki/Stock_Reservation [^] As group Admin role, Go to Physical inventory and remove the stock for Cerveza Lager. Keep 700 units in Warehouse España Región Norte 0-0-0 Go to Sales Order window, Org: España Lines: Cerveza Lager: qty: 900 Stock Reservation: blank Book it. Once you select the line, you will see Manage Reservations button. Click on it, and indicate you would like to reserve 400 units. Click on Done. Go to Stock reservation window. Realise that the register created indicates 700 units, but the user said 400. That is wrong. If you manage Stock again from the Stock Reservation window, and you indicate 400, now the register has the correct qty. |
||
Revision | 2015-02-26 18:45 by umartirena | ||
Description | Reserved quantity is not correct under certain circumstancies |
Copyright © 2000 - 2009 MantisBT Group |