Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0024620
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2013-08-29 02:432014-02-17 18:44
ReporterjonalegriaesarteView Statuspublic 
Assigned Topramakrishnan 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9f1d2c0629be
ProjectionnoneETAnoneTarget Version3.0MP28
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tojonalegriaesarte
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0024620: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0028459 closededuardo_Argal It is necessary a modulescript to solve stock inconsistencies 
related to defect 0032392 closedmarkmm82 Wrong value in qtyreserved column of m_storage_pending when creating an order from a sales quotation 

-  Notes
(0060807)
jonalegriaesarte (reporter)
2013-08-29 02:43

 An script to fix the data should be provided as part of the solution
(0061055)
jonalegriaesarte (reporter)
2013-09-10 17:14

 Sorry, i was talking about sales quotation
(0061326)
hgbot (developer)
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 (developer)
2013-09-21 06:12

 Reopened to add review assigned to
(0061329)
hgbot (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
2013-10-01 18:57

 verified
(0061515)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2013-08-29 02:43 jonalegriaesarte New Issue
2013-08-29 02:43 jonalegriaesarte Assigned To => jonalegriaesarte
2013-08-29 02:43 jonalegriaesarte Modules => Core
2013-08-29 02:43 jonalegriaesarte Triggers an Emergency Pack => No
2013-08-29 02:43 jonalegriaesarte Note Added: 0060807
2013-09-10 17:14 jonalegriaesarte Note Added: 0061055
2013-09-16 10:28 jonalegriaesarte Assigned To jonalegriaesarte => pramakrishnan
2013-09-16 13:47 jonalegriaesarte Summary Budget 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:47 jonalegriaesarte Description Updated View Revisions
2013-09-16 13:47 jonalegriaesarte Steps to Reproduce Updated View Revisions
2013-09-18 12:02 jonalegriaesarte Priority normal => urgent
2013-09-21 06:10 hgbot Checkin
2013-09-21 06:10 hgbot Note Added: 0061326
2013-09-21 06:10 hgbot Status new => resolved
2013-09-21 06:10 hgbot Resolution open => fixed
2013-09-21 06:10 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2c3353417fc384df218417d4bb645d6690ecbd9d [^]
2013-09-21 06:12 pramakrishnan Note Added: 0061327
2013-09-21 06:12 pramakrishnan Status resolved => new
2013-09-21 06:12 pramakrishnan Resolution fixed => open
2013-09-21 06:12 pramakrishnan Review Assigned To => jonalegriaesarte
2013-09-21 06:12 pramakrishnan Status new => scheduled
2013-09-21 06:13 pramakrishnan Status scheduled => resolved
2013-09-21 06:13 pramakrishnan Resolution open => fixed
2013-09-21 08:33 hgbot Checkin
2013-09-21 08:33 hgbot Note Added: 0061329
2013-09-21 09:04 hgbot Checkin
2013-09-21 09:04 hgbot Note Added: 0061330
2013-09-21 14:36 hudsonbot Checkin
2013-09-21 14:36 hudsonbot Note Added: 0061331
2013-09-23 12:30 hudsonbot Checkin
2013-09-23 12:30 hudsonbot Note Added: 0061349
2013-09-23 12:30 hudsonbot Checkin
2013-09-23 12:30 hudsonbot Note Added: 0061350
2013-10-01 18:25 maite Note Added: 0061511
2013-10-01 18:25 maite Status resolved => new
2013-10-01 18:25 maite Resolution fixed => open
2013-10-01 18:55 hgbot Checkin
2013-10-01 18:55 hgbot Note Added: 0061512
2013-10-01 18:55 hgbot Status new => resolved
2013-10-01 18:55 hgbot Resolution open => fixed
2013-10-01 18:55 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/2c3353417fc384df218417d4bb645d6690ecbd9d [^] => http://code.openbravo.com/erp/devel/pi/rev/9f1d2c0629bef9ad6ace082679022c3ceb41604f [^]
2013-10-01 18:57 maite Note Added: 0061513
2013-10-01 18:57 maite Status resolved => closed
2013-10-02 02:18 hudsonbot Checkin
2013-10-02 02:18 hudsonbot Note Added: 0061515
2014-02-17 18:44 ngarcia Issue Monitored: ngarcia
2014-12-19 12:57 VictorVillar Relationship added related to 0028459
2016-04-04 11:41 aferraz Relationship added related to 0032392

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker