Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025301Openbravo ERP03. Procurement managementpublic2013-12-11 02:232014-03-31 13:26
Reporterjonalegriaesarte 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR14Q2Fixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket25291
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025301: Purchase order is reserving quantity. This is generating an issue when changing the stocked flag in product definition
DescriptionPurchase order is reserving quantity. This is generating an issue when changing the stocked flag in product definition
Steps To Reproduce- Create a product, type item and stocked
- Create a purchase order
- Change the product type and the stocked flag. Error is shown
Proposed SolutionIn the scenario as mentioned in steps to reproduce, a message could be displayed as Product could not be updated. There are Pending PO associated with the product. Reactivate them prior to update product.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-12-11 02:23jonalegriaesarteNew Issue
2013-12-11 02:23jonalegriaesarteAssigned To => jonalegriaesarte
2013-12-11 02:23jonalegriaesarteModules => Core
2013-12-11 02:23jonalegriaesarteOBNetwork customer => Yes
2013-12-11 02:23jonalegriaesarteSupport ticket => 25291
2013-12-11 02:23jonalegriaesarteTriggers an Emergency Pack => No
2014-01-07 12:51jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-01-10 12:36AtulOpenbravoAssigned Topramakrishnan => AtulOpenbravo
2014-01-10 12:37AtulOpenbravoStatusnew => scheduled
2014-01-10 12:37AtulOpenbravofix_in_branch => pi
2014-01-14 09:43AtulOpenbravoNote Added: 0063391
2014-01-14 09:45AtulOpenbravofix_in_branchpi =>
2014-01-14 09:45AtulOpenbravoProposed Solution updated
2014-02-20 12:42AtulOpenbravoNote Added: 0064390
2014-02-20 13:00AtulOpenbravoNote Edited: 0063391bug_revision_view_page.php?bugnote_id=0063391#r5470
2014-02-20 14:13AtulOpenbravoNote Added: 0064402
2014-02-20 17:20AtulOpenbravoNote Edited: 0064402bug_revision_view_page.php?bugnote_id=0064402#r5474
2014-03-11 13:15jonalegriaesarteResolution time => 1395270000
2014-03-21 06:14AtulOpenbravoReview Assigned To => jonalegriaesarte
2014-03-21 06:21hgbotCheckin
2014-03-21 06:21hgbotNote Added: 0065323
2014-03-21 06:21hgbotStatusscheduled => resolved
2014-03-21 06:21hgbotResolutionopen => fixed
2014-03-21 06:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/18e0d8ef18cef4a28d371cfdf59ac7c6aec200d9 [^]
2014-03-21 08:23hgbotCheckin
2014-03-21 08:23hgbotNote Added: 0065331
2014-03-21 08:25hgbotCheckin
2014-03-21 08:25hgbotNote Added: 0065332
2014-03-21 08:25hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/18e0d8ef18cef4a28d371cfdf59ac7c6aec200d9 [^] => http://code.openbravo.com/erp/devel/pi/rev/ca8c20bc2f674b70161dbfec85b328fab7dcc7ce [^]
2014-03-21 15:59hudsonbotCheckin
2014-03-21 15:59hudsonbotNote Added: 0065363
2014-03-21 15:59hudsonbotCheckin
2014-03-21 15:59hudsonbotNote Added: 0065365
2014-03-21 15:59hudsonbotCheckin
2014-03-21 15:59hudsonbotNote Added: 0065366
2014-03-31 13:26jonalegriaesarteNote Added: 0065612
2014-03-31 13:26jonalegriaesarteStatusresolved => closed
2014-03-31 13:26jonalegriaesarteFixed in Version => PR14Q2

Notes
(0063391)
AtulOpenbravo   
2014-01-14 09:43   
(edited on: 2014-02-20 13:00)
We have following flows in the system.
- When a purchase order is booked for a product, Ordered Quantity in M_Storage_Pending keeps track of Pending Quantity yet to be received.
- When a Sales Order is booked for a product, Reserved Quantity in M_Storage_Peding keeps tracks of Pending Quantity yet to be shipped.
- If there are Pending Purchase Order & Sales Order Quantities or Stocked Quantities for a products we cannot do the following.

1 ] Set Active Flag = No.
2 ] Set Stocked Flag=No.
3 ] Change Uom of product
4 ] Change Attribute set already assigned to product.

To change above information then product should have
1 ] No Stock.
2 ] No Pending Purchase Order.
3 ] No Pending Sales Order.
(0064390)
AtulOpenbravo   
2014-02-20 12:42   
Test Plan
- Create a product, type item and stocked.
- Create a purchase order, create a line with above product and process it.
- Change the product type or stocked flag, realize that message is shown as "Product could not be updated, There are Pending Purchase Orders associated with the product. Please reactivate those, prior to update product information."
(0064402)
AtulOpenbravo   
2014-02-20 14:13   
(edited on: 2014-02-20 17:20)
Alternate Test Plans.

1 ] Create a product A.
2 ] Enter a physical inventory for product A with Quantity Count = 100 and process it.
3 ] Enter a Sales Order with line of product A with ordered Qty = 100.
4 ] Generate a Shipment for above Sales Order and process it.
5 ] Enter Return From Customer with above Goods Shipment and returned qty as 10.
6 ] Go to product A, try to update Uom or Stocked flag or Active flag or Attribute Set. Message is displayed "Product could not be updated. There are associated Return From Customer transaction associated with the product. Reactivate them prior to update product information."
(0065323)
hgbot   
2014-03-21 06:21   
Repository: erp/devel/pi
Changeset: 18e0d8ef18cef4a28d371cfdf59ac7c6aec200d9
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Mar 17 14:05:04 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/18e0d8ef18cef4a28d371cfdf59ac7c6aec200d9 [^]

Fixes Issue 25301

---
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0065331)
hgbot   
2014-03-21 08:23   
Repository: erp/devel/pi
Changeset: f25d4926a29a5925a06e07be160e065654f50448
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Mar 21 12:52:37 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f25d4926a29a5925a06e07be160e065654f50448 [^]

Backout Issue 25301 Wrong fix pushed to pi

---
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0065332)
hgbot   
2014-03-21 08:25   
Repository: erp/devel/pi
Changeset: ca8c20bc2f674b70161dbfec85b328fab7dcc7ce
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Mar 17 15:55:36 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ca8c20bc2f674b70161dbfec85b328fab7dcc7ce [^]

Fixes Issue 25301 PO is reserving Qty, cannot update stock flag in product.

---
M src-db/database/model/triggers/M_PRODUCT_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0065363)
hudsonbot   
2014-03-21 15:59   
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/e18c6c3d258e [^]
Maturity status: Test
(0065365)
hudsonbot   
2014-03-21 15:59   
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/e18c6c3d258e [^]
Maturity status: Test
(0065366)
hudsonbot   
2014-03-21 15:59   
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/e18c6c3d258e [^]
Maturity status: Test
(0065612)
jonalegriaesarte   
2014-03-31 13:26   
Working fine, following the test plan.