Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024620Openbravo ERP07. Sales managementpublic2013-08-29 02:432014-02-17 18:44
Reporterjonalegriaesarte 
Assigned Topramakrishnan 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP28Fixed in Version 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024620: Sales quotation is modifying qty reserved in m_storage_pending table and it shouldn't
DescriptionSales quotation is modifying qty reserved in m_storage_pending table and it shouldn't. Only sales order has to modify this field
Steps To Reproduce- 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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