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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0025301
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajorhave not tried2013-12-11 02:232014-03-31 13:26
ReporterjonalegriaesarteView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version3.0PR14Q2
StatusclosedFix in branchFixed in SCM revisionca8c20bc2f67
ProjectionnoneETAnoneTarget Version3.0PR14Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Tojonalegriaesarte
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0063391)
AtulOpenbravo (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (developer)
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 (reporter)
2014-03-31 13:26

 Working fine, following the test plan.

- Issue History
Date Modified Username Field Change
2013-12-11 02:23 jonalegriaesarte New Issue
2013-12-11 02:23 jonalegriaesarte Assigned To => jonalegriaesarte
2013-12-11 02:23 jonalegriaesarte Modules => Core
2013-12-11 02:23 jonalegriaesarte Triggers an Emergency Pack => No
2014-01-07 12:51 jonalegriaesarte Assigned To jonalegriaesarte => pramakrishnan
2014-01-10 12:36 AtulOpenbravo Assigned To pramakrishnan => AtulOpenbravo
2014-01-10 12:37 AtulOpenbravo Status new => scheduled
2014-01-10 12:37 AtulOpenbravo fix_in_branch => pi
2014-01-14 09:43 AtulOpenbravo Note Added: 0063391
2014-01-14 09:45 AtulOpenbravo fix_in_branch pi =>
2014-01-14 09:45 AtulOpenbravo Proposed Solution updated
2014-02-20 12:42 AtulOpenbravo Note Added: 0064390
2014-02-20 13:00 AtulOpenbravo Note Edited: 0063391 View Revisions
2014-02-20 14:13 AtulOpenbravo Note Added: 0064402
2014-02-20 17:20 AtulOpenbravo Note Edited: 0064402 View Revisions
2014-03-11 13:15 jonalegriaesarte Resolution time => 1395270000
2014-03-21 06:14 AtulOpenbravo Review Assigned To => jonalegriaesarte
2014-03-21 06:21 hgbot Checkin
2014-03-21 06:21 hgbot Note Added: 0065323
2014-03-21 06:21 hgbot Status scheduled => resolved
2014-03-21 06:21 hgbot Resolution open => fixed
2014-03-21 06:21 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/18e0d8ef18cef4a28d371cfdf59ac7c6aec200d9 [^]
2014-03-21 08:23 hgbot Checkin
2014-03-21 08:23 hgbot Note Added: 0065331
2014-03-21 08:25 hgbot Checkin
2014-03-21 08:25 hgbot Note Added: 0065332
2014-03-21 08:25 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/18e0d8ef18cef4a28d371cfdf59ac7c6aec200d9 [^] => http://code.openbravo.com/erp/devel/pi/rev/ca8c20bc2f674b70161dbfec85b328fab7dcc7ce [^]
2014-03-21 15:59 hudsonbot Checkin
2014-03-21 15:59 hudsonbot Note Added: 0065363
2014-03-21 15:59 hudsonbot Checkin
2014-03-21 15:59 hudsonbot Note Added: 0065365
2014-03-21 15:59 hudsonbot Checkin
2014-03-21 15:59 hudsonbot Note Added: 0065366
2014-03-31 13:26 jonalegriaesarte Note Added: 0065612
2014-03-31 13:26 jonalegriaesarte Status resolved => closed
2014-03-31 13:26 jonalegriaesarte Fixed in Version => PR14Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker