Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035958 | Openbravo ERP | 04. Warehouse management | public | 2017-05-09 11:40 | 2017-05-30 20:59 |
|
| Reporter | ngarcia | |
| Assigned To | collazoandy4 | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q3 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035958: Reactivating a sales order and decreasing the ordered quantity that is already reserved causes wrong reservation |
| Description | Reactivating a sales order and decreasing the ordered quantity that is already reserved causes wrong reservation |
| Steps To Reproduce | As group admin role:
Set the Enable Stock Reservations preference to Y
Log out and log in
Create a Sales Order
Add 12 units of a product with stock, set the Stock Reservation as Automatic and complete the sales order
Check a reservation has been correctly created
Reactivate the order, change the ordered quantity to 6 and complete it
Check the reservation has been updated to:
Quantity: 6
Reserved Qty: 0
Status: Closed
Reactivate the order, change the ordered quantity to 3 and complete it
Click on Manage Reservation and reserve 3 units
Check the reservation has been updated to:
Quantity: 6
Reserved Qty: 3
Status: Closed |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0033912 | | scheduled | collazoandy4 | Automatic Stock Reservation does not work if an order set as Manual is reactivated and then changed to Automatic. | | related to | defect | 0035270 | | closed | collazoandy4 | Wrong reservation when closing a sales order with a voided partial shipment | | related to | defect | 0026959 | 3.0PR14Q4 | closed | AtulOpenbravo | Wrong Reservation status under some circumstances | | causes | defect | 0038799 | | closed | AtulOpenbravo | More quantity reserved than available after booking a reopened sales order with more ordered quantity |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-05-09 11:40 | ngarcia | New Issue | |
| 2017-05-09 11:40 | ngarcia | Assigned To | => Triage Finance |
| 2017-05-09 11:40 | ngarcia | Modules | => Core |
| 2017-05-09 11:40 | ngarcia | Resolution time | => 1496095200 |
| 2017-05-09 11:40 | ngarcia | Triggers an Emergency Pack | => No |
| 2017-05-09 11:40 | ngarcia | Issue Monitored: networkb | |
| 2017-05-09 11:41 | ngarcia | Relationship added | related to 0033912 |
| 2017-05-10 16:47 | aferraz | Assigned To | Triage Finance => collazoandy4 |
| 2017-05-17 17:40 | collazoandy4 | Status | new => scheduled |
| 2017-05-23 19:07 | collazoandy4 | Note Added: 0096736 | |
| 2017-05-23 22:32 | collazoandy4 | Note Edited: 0096736 | bug_revision_view_page.php?bugnote_id=0096736#r15204 |
| 2017-05-24 20:05 | collazoandy4 | Relationship added | related to 0035270 |
| 2017-05-29 17:22 | aferraz | Relationship added | related to 0026959 |
| 2017-05-30 10:08 | hgbot | Checkin | |
| 2017-05-30 10:08 | hgbot | Note Added: 0097001 | |
| 2017-05-30 10:08 | hgbot | Status | scheduled => resolved |
| 2017-05-30 10:08 | hgbot | Resolution | open => fixed |
| 2017-05-30 10:08 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0e29b93a2d41205b1309cd6fde9f86cabbb47e91 [^] |
| 2017-05-30 10:09 | aferraz | Review Assigned To | => aferraz |
| 2017-05-30 10:09 | aferraz | Note Added: 0097003 | |
| 2017-05-30 10:09 | aferraz | Status | resolved => closed |
| 2017-05-30 10:09 | aferraz | Fixed in Version | => 3.0PR17Q3 |
| 2017-05-30 20:59 | hudsonbot | Checkin | |
| 2017-05-30 20:59 | hudsonbot | Note Added: 0097036 | |
| 2018-07-14 12:26 | dmitry_mezentsev | Relationship added | causes 0038799 |
|
Notes |
|
|
(0096736)
|
|
collazoandy4
|
2017-05-23 19:07
(edited on: 2017-05-23 22:32) |
|
As group admin role:
Go to Preference window and create a new record:
Property: Enable Stock Reservations
Value: Y
Log out and log in
Go to Sales Order window and create a new record:
Business Partner: Alimentos y Supermercados, S.A
Create a new record in Lines tab:
Product: Zumo de Piña 0,5L
Ordered Quantity: 15
Stock Reservation: Automatic
Complete the order
Go to Stock reservation window and check that a new reservation has been created:
Product: Zumo de Piña 0,5L
Quantity / Reserved Qty: 15
Released: 0
Status: Completed
Stock line with:
Quantity: 15
Released: 0
Reactivate the previous order created and change the ordered quantity to 10 and complete it
Check the reservation has been updated to:
Quantity / Reserved Qty: 10
Released: 0
Status: Completed
Stock line with:
Quantity: 10
Released: 0
Reactivate the order, change the ordered quantity to 5 and complete it
Check the reservation has been updated to:
Quantity / Reserved Qty: 5
Released: 0
Status: Completed
Stock line with:
Quantity: 5
Released: 0
Click on Manage Reservation and reserve 3 units
Check the reservation has been updated to:
Quantity: 5
Reserved Qty: 3
Status: Completed
Stock line with:
Quantity: 3
Released: 0
Reactivate the previous order created and change the ordered quantity to 1 and complete it
Check the reservation has been updated to:
Quantity / Reserved Qty: 1
Released: 0
Status: Completed
Stock line with:
Quantity: 1
Released: 0
Reactivate the previous order created and change the ordered quantity to 15 and complete it
Check the reservation has been updated to:
Quantity / Reserved Qty: 15
Released: 0
Status: Completed
Stock line with:
Quantity: 15
Released: 0
Go to Goods Shipment window and create a new record:
Business Partner: Alimentos y Supermercados, S.A
Clic on Create Lines From button and select the previous order created
Edit the line movement quantity to 5
Complete the Shipment
Check the reservation has been updated to:
Quantity / Reserved Qty: 15
Released: 5
Status: Completed
Stock line with:
Quantity: 15
Released: 5
Reactivate the previous order created and change the ordered quantity to 3
Check the error "Saving failed. Cannot modify an order line that has deliveries or invoices" is shown when saving the line
Cancel the edit and complete the order
Close the order and check the reservation has been updated to:
Quantity / Reserved Qty / Released: 5
Status: Closed
Stock line with:
Quantity: 5
Released: 5
|
|
|
|
(0097001)
|
|
hgbot
|
|
2017-05-30 10:08
|
|
Repository: erp/devel/pi
Changeset: 0e29b93a2d41205b1309cd6fde9f86cabbb47e91
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Tue May 23 10:49:51 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/0e29b93a2d41205b1309cd6fde9f86cabbb47e91 [^]
Fixes issue 35958: Wrong reservation when reactivating a sales order
When completing an order wich already has a reservation, the stock reservation
was updated causing a wrong reservation. Now the update of stock reservation is
made only if the order is not completed.
---
M src-db/database/model/functions/C_ORDER_POST1.xml
---
|
|
|
|
|
|
|
|
|
|