Openbravo Issue Tracking System - Openbravo ERP |
View Issue Details |
|
ID | Project | Category | View Status | Date Submitted | Last Update |
0029571 | Openbravo ERP | 04. Warehouse management | public | 2015-04-13 12:58 | 2015-07-02 11:51 |
|
Reporter | ngarcia | |
Assigned To | jorge-garcia | |
Priority | urgent | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | |
Platform | | OS | 5 | OS Version | |
Product Version | | |
Target Version | | Fixed in Version | pi | |
Merge Request Status | |
Review Assigned To | umartirena |
OBNetwork customer | |
Web browser | |
Modules | Core |
Support ticket | |
Regression level | |
Regression date | |
Regression introduced in release | |
Regression introduced by commit | |
Triggers an Emergency Pack | No |
|
Summary | 0029571: In Physical Inventory Lines, Book Quantity is not updated to 0 by Update Quantity process if product has a mandatory attribute |
Description | In Physical Inventory Lines, Book Quantity is not updated to 0 by Update Quantity process if product has a mandatory attribute |
Steps To Reproduce | As group admin role:
Create a Product and set an attribute set to it, that is defined as Require At Least One Value
Create a Goods Receipt for that product, assign an attribute set value and complete it
Create a physical inventory and add that product with Quantity Count = Book Quantity. Do not complete it
Create a Goods Shipment in order to leave the stock of the product to 0. Complete it
Launch the Update Quantity process in the Physical Inventory and check the Book Quantity is not updated to 0
Increase the Quantity Count and process the inventory
Check the stock of the product is not the value introduced in the Quantity Count field but the difference between Quantity Count and Book Quantity |
Proposed Solution | It should be analyzed if that records should not be deleted from the M_STORAGE_DETAIL table or if the Update Quantity should update the Book Quantity to 0 when there is not an associated record in the M_STORAGE_DETAIL table |
Additional Information | |
Tags | No tags attached. |
Relationships | related to | defect | 0020159 | 3.0MP11 | closed | jecharri | Product with mandatory attribute should not generate lines without attribute in m_storage_detail | related to | defect | 0028459 | | closed | eduardo_Argal | It is necessary a modulescript to solve stock inconsistencies | related to | defect | 0030033 | | closed | aferraz | Create Inventory Count List process does not insert products without stock if product has a mandatory attribute |
|
Attached Files | |
|
Issue History |
Date Modified | Username | Field | Change |
2015-04-13 12:58 | ngarcia | New Issue | |
2015-04-13 12:58 | ngarcia | Assigned To | => Sandrahuguet |
2015-04-13 12:58 | ngarcia | Modules | => Core |
2015-04-13 12:58 | ngarcia | Resolution time | => 1430949600 |
2015-04-13 12:58 | ngarcia | Triggers an Emergency Pack | => No |
2015-04-13 12:59 | ngarcia | Issue Monitored: networkb | |
2015-04-13 12:59 | ngarcia | Relationship added | related to 0020159 |
2015-04-13 13:06 | ngarcia | Proposed Solution updated | |
2015-04-14 12:48 | Triage Finance | Assigned To | Sandrahuguet => Triage Finance |
2015-04-17 14:32 | jorge-garcia | Status | new => scheduled |
2015-04-17 14:32 | jorge-garcia | Assigned To | Triage Finance => jorge-garcia |
2015-04-21 09:14 | jorge-garcia | Note Added: 0076643 | |
2015-05-04 17:37 | hgbot | Checkin | |
2015-05-04 17:37 | hgbot | Note Added: 0076959 | |
2015-05-04 17:37 | hgbot | Status | scheduled => resolved |
2015-05-04 17:37 | hgbot | Resolution | open => fixed |
2015-05-04 17:37 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/aa5e62559ffb22c55a560cbfcc07e17d0eccbae3 [^] |
2015-05-04 17:37 | hgbot | Checkin | |
2015-05-04 17:37 | hgbot | Note Added: 0076960 | |
2015-05-04 17:40 | umartirena | Review Assigned To | => umartirena |
2015-05-04 17:40 | umartirena | Note Added: 0076961 | |
2015-05-04 17:40 | umartirena | Status | resolved => closed |
2015-05-04 17:40 | umartirena | Fixed in Version | => pi |
2015-05-07 22:17 | hudsonbot | Checkin | |
2015-05-07 22:17 | hudsonbot | Note Added: 0077200 | |
2015-05-07 22:17 | hudsonbot | Checkin | |
2015-05-07 22:17 | hudsonbot | Note Added: 0077201 | |
2015-05-27 16:33 | ngarcia | Relationship added | related to 0030033 |
2015-07-02 11:51 | ngarcia | Relationship added | related to 0028459 |
Notes |
|
(0076643)
|
jorge-garcia
|
2015-04-21 09:14
|
|
Test Plan
As group admin role:
Create a Product and set an attribute set to it, that is defined as Require At Least One Value
Create a Goods Receipt for that product, assign an attribute set value and complete it
Create a physical inventory and add that product with Quantity Count = Book Quantity. Do not complete it
Create a Goods Shipment in order to leave the stock of the product to 0. Complete it
Launch the Update Quantity process in the Physical Inventory and check the line of that product is deleted because there is no stock at the moment |
|
|
(0076959)
|
hgbot
|
2015-05-04 17:37
|
|
Repository: erp/devel/pi
Changeset: aa5e62559ffb22c55a560cbfcc07e17d0eccbae3
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Mon Apr 20 18:14:19 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/aa5e62559ffb22c55a560cbfcc07e17d0eccbae3 [^]
Fixed issue 29571: Book Quantity is not updated to 0 by Update Quantity process
In Physical Inventory Lines, Book Quantity is not updated to 0 by Update
Quantity process if product has a mandatory attribute.
The decided solution is to delete the lines from the physical inventory in two
cases: if the product of the line doesn't had an associated record in the
m_storage_detail table, or if the quantity on hand is equal to 0 or the order
quantity is equal to 0 or null.
---
M src-db/database/model/functions/M_INVENTORY_LISTUPDATE.xml
---
|
|
|
(0076960)
|
hgbot
|
2015-05-04 17:37
|
|
Repository: erp/devel/pi
Changeset: f83615a66bb3c90e9dd3890408bfc6cbe69363a9
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon May 04 17:24:03 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f83615a66bb3c90e9dd3890408bfc6cbe69363a9 [^]
Related to bug 29571: Code Review
[1]: Fix copyright
[2]: Return number of deleted lines
---
M src-db/database/model/functions/M_INVENTORY_LISTUPDATE.xml
---
|
|
|
(0076961)
|
umartirena
|
2015-05-04 17:40
|
|
|
|
|
|
|
|
|