Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0024620Openbravo ERP07. Sales managementpublic2013-08-29 02:432014-02-17 18:44
jonalegriaesarte 
pramakrishnan 
urgentmajorhave not tried
closedfixed 
5
 
3.0MP28 
jonalegriaesarte
Core
No
0024620: Sales quotation is modifying qty reserved in m_storage_pending table and it shouldn't
Sales quotation is modifying qty reserved in m_storage_pending table and it shouldn't. Only sales order has to modify this field
- Check qty reserved in m_storage_pending table for one product
- Create a new Sales quotation with one line using the same product
- Book it
- Check qty reserved in m_storage_pending table for the product
No tags attached.
related to defect 0028459 closed eduardo_Argal It is necessary a modulescript to solve stock inconsistencies 
related to defect 0032392 closed markmm82 Wrong value in qtyreserved column of m_storage_pending when creating an order from a sales quotation 
Issue History
2013-08-29 02:43jonalegriaesarteNew Issue
2013-08-29 02:43jonalegriaesarteAssigned To => jonalegriaesarte
2013-08-29 02:43jonalegriaesarteModules => Core
2013-08-29 02:43jonalegriaesarteTriggers an Emergency Pack => No
2013-08-29 02:43jonalegriaesarteNote Added: 0060807
2013-09-10 17:14jonalegriaesarteNote Added: 0061055
2013-09-16 10:28jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2013-09-16 13:47jonalegriaesarteSummaryBudget is modifying qty reserved in m_storage_pending table and it shouldn't => Sales quotation is modifying qty reserved in m_storage_pending table and it shouldn't
2013-09-16 13:47jonalegriaesarteDescription Updatedbug_revision_view_page.php?rev_id=5027#r5027
2013-09-16 13:47jonalegriaesarteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5029#r5029
2013-09-18 12:02jonalegriaesartePrioritynormal => urgent
2013-09-21 06:10hgbotCheckin
2013-09-21 06:10hgbotNote Added: 0061326
2013-09-21 06:10hgbotStatusnew => resolved
2013-09-21 06:10hgbotResolutionopen => fixed
2013-09-21 06:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2c3353417fc384df218417d4bb645d6690ecbd9d [^]
2013-09-21 06:12pramakrishnanNote Added: 0061327
2013-09-21 06:12pramakrishnanStatusresolved => new
2013-09-21 06:12pramakrishnanResolutionfixed => open
2013-09-21 06:12pramakrishnanReview Assigned To => jonalegriaesarte
2013-09-21 06:12pramakrishnanStatusnew => scheduled
2013-09-21 06:13pramakrishnanStatusscheduled => resolved
2013-09-21 06:13pramakrishnanResolutionopen => fixed
2013-09-21 08:33hgbotCheckin
2013-09-21 08:33hgbotNote Added: 0061329
2013-09-21 09:04hgbotCheckin
2013-09-21 09:04hgbotNote Added: 0061330
2013-09-21 14:36hudsonbotCheckin
2013-09-21 14:36hudsonbotNote Added: 0061331
2013-09-23 12:30hudsonbotCheckin
2013-09-23 12:30hudsonbotNote Added: 0061349
2013-09-23 12:30hudsonbotCheckin
2013-09-23 12:30hudsonbotNote Added: 0061350
2013-10-01 18:25maiteNote Added: 0061511
2013-10-01 18:25maiteStatusresolved => new
2013-10-01 18:25maiteResolutionfixed => open
2013-10-01 18:55hgbotCheckin
2013-10-01 18:55hgbotNote Added: 0061512
2013-10-01 18:55hgbotStatusnew => resolved
2013-10-01 18:55hgbotResolutionopen => fixed
2013-10-01 18:55hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/2c3353417fc384df218417d4bb645d6690ecbd9d [^] => http://code.openbravo.com/erp/devel/pi/rev/9f1d2c0629bef9ad6ace082679022c3ceb41604f [^]
2013-10-01 18:57maiteNote Added: 0061513
2013-10-01 18:57maiteStatusresolved => closed
2013-10-02 02:18hudsonbotCheckin
2013-10-02 02:18hudsonbotNote Added: 0061515
2014-02-17 18:44ngarciaIssue Monitored: ngarcia
2014-12-19 12:57VictorVillarRelationship addedrelated to 0028459
2016-04-04 11:41aferrazRelationship addedrelated to 0032392

Notes
(0060807)
jonalegriaesarte   
2013-08-29 02:43   
An script to fix the data should be provided as part of the solution
(0061055)
jonalegriaesarte   
2013-09-10 17:14   
Sorry, i was talking about sales quotation
(0061326)
hgbot   
2013-09-21 06:10   
Repository: erp/devel/pi
Changeset: 2c3353417fc384df218417d4bb645d6690ecbd9d
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Thu Sep 19 23:05:29 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/2c3353417fc384df218417d4bb645d6690ecbd9d [^]

Fixes Issue 24620: Sales quotation is modifying qty reserved in m_storage_pending

When the sales quotation is booked or reactivated, the quantity should not be updated in the m_storage_pending table and
when the sales quotation is converted into sales order, the quantity should be updated in the m_storage_pending table.

---
M src-db/database/model/functions/C_ORDER_POST1.xml
M src/org/openbravo/erpCommon/ad_process/ConvertQuotationIntoOrder.java
---
(0061327)
pramakrishnan   
2013-09-21 06:12   
Reopened to add review assigned to
(0061329)
hgbot   
2013-09-21 08:33   
Repository: erp/devel/pi
Changeset: 01f8501c029ece79c28a84fcac43e26187b35b2d
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Sat Sep 21 12:02:05 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/01f8501c029ece79c28a84fcac43e26187b35b2d [^]

Related to Issue 24620 : Update reserved quantity in orderline.

---
M src/org/openbravo/erpCommon/ad_process/ConvertQuotationIntoOrder.java
---
(0061330)
hgbot   
2013-09-21 09:04   
Repository: erp/devel/pi
Changeset: 493e408197e0a5215eed2816ab8c68a5f2c1eac4
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Sat Sep 21 12:31:14 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/493e408197e0a5215eed2816ab8c68a5f2c1eac4 [^]

Related to Issue 24620 : Do not update quantity reserved in storage pending for discount rows.

---
M src/org/openbravo/erpCommon/ad_process/ConvertQuotationIntoOrder.java
---
(0061331)
hudsonbot   
2013-09-21 14:36   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/158aca8ccebd [^]

Maturity status: Test
(0061349)
hudsonbot   
2013-09-23 12:30   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5c14f4f0e8ce [^]

Maturity status: Test
(0061350)
hudsonbot   
2013-09-23 12:30   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5c14f4f0e8ce [^]

Maturity status: Test
(0061511)
maite   
2013-10-01 18:25   
"qtyordered" in M_STORAGE_PENDING is not properly updated when registering a Purchase Order. Problem is that v_DocSubTypeSO for Purchase Order document type is null so coalesce is needed for v_DocSubTypeSO in line

IF ((v_DocStatus<>'IP' OR v_DocAction<>'CO') AND v_DocSubTypeSO<>'OB') THEN
(0061512)
hgbot   
2013-10-01 18:55   
Repository: erp/devel/pi
Changeset: 9f1d2c0629bef9ad6ace082679022c3ceb41604f
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Tue Oct 01 18:55:13 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9f1d2c0629bef9ad6ace082679022c3ceb41604f [^]

Fixes issue 0024620: Sales quotation is modifying qty
reserved in m_storage_pending table and it shouldn't

---
M src-db/database/model/functions/C_ORDER_POST1.xml
---
(0061513)
maite   
2013-10-01 18:57   
verified
(0061515)
hudsonbot   
2013-10-02 02:18   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/4fb884db1a7e [^]

Maturity status: Test