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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027992
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2014-10-27 18:412014-12-30 23:27
ReportercaristuView Statuspublic 
Assigned Toreinaldoguerra 
PriorityurgentResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revisiona65bafad9865
ProjectionnoneETAnoneTarget Version3.0PR15Q1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket31989
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027992: Create Inventory Count List is not adding products with attribute set under some circumstances

DescriptionCreate Inventory Count List process is not adding products with attribute set if the same product already exists in the physical inventory lines.
Steps To Reproduce1) Create a new product with Lot as attribute set
2) To generate stock for our product, create a new physical inventory with two lines
   - Line 1: product: our product, lot name 1, quantity 100
   - Line 2: product: our product, lot name 2, quantity 0
3) Process the physical inventory
4) Create a new physical inventory
5) Use the Create Inventory Count List button:
   - Product search key: our product search key
   - Inventory Quantity: 0

   A line with our product with lot name 2 is added.
   
6) Use the Create Inventory Count List button again
   - Product search key: our product search key
   - Inventory Quantity: > 0

  Notice that a line with our product with lot name 1 is not added.
Proposed SolutionIn the "m_inventory_listcreate" the following select is avoiding the product with different attribute set to be added:

...
 AND NOT EXISTS
        (SELECT *
        FROM M_InventoryLine l
        WHERE l.M_Inventory_ID=v_Record_ID
          AND l.M_Product_ID=s.M_Product_ID
          AND l.M_Locator_ID=s.M_Locator_ID
        )
...

The attribute_set_id should be take into account too.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0071540)
reinaldoguerra (viewer)
2014-11-11 02:52

 Test plan used:
1- Login into Openbravo ERP
2- Go to product window and create a new one with Lot as attribute set.
3- Go to physical inventory window and create a new record with two lines.
   Line 1 - Product: our product, Lot name: 1, Quantity: 100
   Line 2 - Product: our product, Lot name: 2, Quantity: 0
4- Click Process Inventory Count button
5- Create a new physical inventory header
6- Use the Create Inventory Count List button:
   Product search key: our product search key
   Inventory Quantity: 0
7- Realize that a line with our product with lot name 2 is added.
8- Use the Create Inventory Count List button again
   Product search key: our product search key
   Inventory Quantity: > 0
9- Notice that a line with our product with lot name 1 is added.
(0072562)
hgbot (developer)
2014-12-16 16:22

 Repository: erp/devel/pi
Changeset: a65bafad9865ac84c3158730848bcab744df22ee
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Tue Dec 16 16:21:31 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a65bafad9865ac84c3158730848bcab744df22ee [^]

Fixes bug 27992: Create Inventory Process should take into account attributes

'Create Inventory Count List' process in Physical Inventory it was not adding products with attribute set if the same product already exists in the physical inventory lines. This was because there was a select that was avoiding to select the products with different attribute set. The attribute_set_id has been added to this select to take into account these ones.

---
M src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml
---
(0072564)
umartirena (viewer)
2014-12-16 16:25

 Code review and Testing Done.

Issue was fixed by Reinaldo Guerra.
(0073223)
hudsonbot (viewer)
2014-12-30 23:27

 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/6525fe229e06 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-10-27 18:41 caristu New Issue
2014-10-27 18:41 caristu Assigned To => AtulOpenbravo
2014-10-27 18:41 caristu OBNetwork customer => Yes
2014-10-27 18:41 caristu Modules => Core
2014-10-27 18:41 caristu Support ticket => 31989
2014-10-27 18:41 caristu Resolution time => 1417734000
2014-10-27 18:41 caristu Triggers an Emergency Pack => No
2014-10-27 18:41 caristu Issue Monitored: networkb
2014-11-10 17:23 reinaldoguerra Assigned To AtulOpenbravo => reinaldoguerra
2014-11-10 17:23 reinaldoguerra Status new => scheduled
2014-11-11 02:52 reinaldoguerra Note Added: 0071540
2014-12-16 16:22 hgbot Checkin
2014-12-16 16:22 hgbot Note Added: 0072562
2014-12-16 16:22 hgbot Status scheduled => resolved
2014-12-16 16:22 hgbot Resolution open => fixed
2014-12-16 16:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a65bafad9865ac84c3158730848bcab744df22ee [^]
2014-12-16 16:25 umartirena Review Assigned To => umartirena
2014-12-16 16:25 umartirena Note Added: 0072564
2014-12-16 16:25 umartirena Status resolved => closed
2014-12-16 16:25 umartirena Fixed in Version => pi
2014-12-30 23:27 hudsonbot Checkin
2014-12-30 23:27 hudsonbot Note Added: 0073223

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker