Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0029571Openbravo ERP04. Warehouse managementpublic2015-04-13 12:582015-07-02 11:51
ngarcia 
jorge-garcia 
urgentmajoralways
closedfixed 
5
 
pi 
umartirena
Core
No
0029571: In Physical Inventory Lines, Book Quantity is not updated to 0 by Update Quantity process if product has a mandatory attribute
In Physical Inventory Lines, Book Quantity is not updated to 0 by Update Quantity process if product has a mandatory attribute
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
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
No tags attached.
related to defect 00201593.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 
Issue History
2015-04-13 12:58ngarciaNew Issue
2015-04-13 12:58ngarciaAssigned To => Sandrahuguet
2015-04-13 12:58ngarciaModules => Core
2015-04-13 12:58ngarciaResolution time => 1430949600
2015-04-13 12:58ngarciaTriggers an Emergency Pack => No
2015-04-13 12:59ngarciaIssue Monitored: networkb
2015-04-13 12:59ngarciaRelationship addedrelated to 0020159
2015-04-13 13:06ngarciaProposed Solution updated
2015-04-14 12:48Triage FinanceAssigned ToSandrahuguet => Triage Finance
2015-04-17 14:32jorge-garciaStatusnew => scheduled
2015-04-17 14:32jorge-garciaAssigned ToTriage Finance => jorge-garcia
2015-04-21 09:14jorge-garciaNote Added: 0076643
2015-05-04 17:37hgbotCheckin
2015-05-04 17:37hgbotNote Added: 0076959
2015-05-04 17:37hgbotStatusscheduled => resolved
2015-05-04 17:37hgbotResolutionopen => fixed
2015-05-04 17:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/aa5e62559ffb22c55a560cbfcc07e17d0eccbae3 [^]
2015-05-04 17:37hgbotCheckin
2015-05-04 17:37hgbotNote Added: 0076960
2015-05-04 17:40umartirenaReview Assigned To => umartirena
2015-05-04 17:40umartirenaNote Added: 0076961
2015-05-04 17:40umartirenaStatusresolved => closed
2015-05-04 17:40umartirenaFixed in Version => pi
2015-05-07 22:17hudsonbotCheckin
2015-05-07 22:17hudsonbotNote Added: 0077200
2015-05-07 22:17hudsonbotCheckin
2015-05-07 22:17hudsonbotNote Added: 0077201
2015-05-27 16:33ngarciaRelationship addedrelated to 0030033
2015-07-02 11:51ngarciaRelationship addedrelated 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   
Code Review + Testing OK
(0077200)
hudsonbot   
2015-05-07 22:17   
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/a1817f84bd8b [^]
Maturity status: Test
(0077201)
hudsonbot   
2015-05-07 22:17   
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/a1817f84bd8b [^]
Maturity status: Test