Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0045650 | Openbravo ERP | 07. Sales management | public | 2020-12-24 14:14 | 2021-01-14 17:57 |
|
| Reporter | ngarcia | |
| Assigned To | dmiguelez | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | PR21Q2 | |
| Merge Request Status | approved |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 20257 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0045650: Wrong qtyreserved in m_storage_pending table when a sales order is processed and voided |
| Description | Wrong qtyreserved in m_storage_pending table when a sales order is processed and voided |
| Steps To Reproduce | As group admin role:
Create a new product
Add a sales price list to it
Create a new sales order
Add the product on its lines
Process it (not book it) and check the status changes to Under Way
Check the qtyreserved column in the m_storage_pending table for that product changes to the quantity ordered
Void it
Check the qtyreserved column in the m_storage_pending table for that product changes to the quantity ordered but in negative. This is wrong |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2020-12-24 14:14 | ngarcia | New Issue | |
| 2020-12-24 14:14 | ngarcia | Assigned To | => Triage Finance |
| 2020-12-24 14:14 | ngarcia | OBNetwork customer | => OBPS |
| 2020-12-24 14:14 | ngarcia | Modules | => Core |
| 2020-12-24 14:14 | ngarcia | Support ticket | => 20257 |
| 2020-12-24 14:14 | ngarcia | Resolution time | => 1610578800 |
| 2020-12-24 14:14 | ngarcia | Triggers an Emergency Pack | => No |
| 2020-12-24 14:15 | ngarcia | Issue Monitored: networkb | |
| 2021-01-12 13:38 | dmiguelez | Note Added: 0125389 | |
| 2021-01-12 13:39 | dmiguelez | Note Added: 0125390 | |
| 2021-01-13 09:24 | hgbot | Merge Request Status | => open |
| 2021-01-13 09:24 | hgbot | Note Added: 0125405 | |
| 2021-01-14 09:58 | vmromanos | Status | new => scheduled |
| 2021-01-14 09:58 | vmromanos | Assigned To | Triage Finance => dmiguelez |
| 2021-01-14 17:57 | hgbot | Merge Request Status | open => approved |
| 2021-01-14 17:57 | hgbot | Resolution | open => fixed |
| 2021-01-14 17:57 | hgbot | Status | scheduled => closed |
| 2021-01-14 17:57 | hgbot | Fixed in Version | => PR21Q2 |
| 2021-01-14 17:57 | hgbot | Note Added: 0125470 | |
| 2021-01-14 17:57 | hgbot | Note Added: 0125471 | |
|
Notes |
|
|
|
Test Plan:
Log in as F&B Admin
Go to Product Window and create a new record with:
- Organization: F&B US
- Name: Test
- SearchKey: Test
Move to Price Tab and create a new record with:
- Price List version: General Sales
- Unit Price: 10
- List Price: 10
Go to Sales Order window and create a new record with:
- Organization: F&B US
- Business Partner: Healthy Food Supermarkets
Move to lines and create a new record with:
- Product: Test
- Ordered Quantity: 1
Click on Book button, select the 'Process' option and then click Ok
Check the status of the Document is 'Under Way'
In the database check that qtyreserved column of the m_storage_pending is 1.
Use this query (to be adapted):
select qtyreserved
from m_storage_pending
where m_product_id = 'PRODUCT_ID';
In the application, with the same Sales Order, click on Book button and select 'Void' as the option and click ok.
In the database check that qtyreserved column of the m_storage_pending is 0.
Use the previous query |
|
|
|
|
|
|
|
(0125405)
|
|
hgbot
|
|
2021-01-13 09:24
|
|
|
|
|
(0125470)
|
|
hgbot
|
|
2021-01-14 17:57
|
|
|
|
|
(0125471)
|
|
hgbot
|
|
2021-01-14 17:57
|
|
|