0004910: Physical Inventory: When changing the storage bin, but leaving the book quantity there, a minus quantity is the result

Description

Warehouse Management || Transactions || Physical Inventory || Header >> Lines

When I was doing a Physical Inventory for a product, I had to select a storage bin when selecting the product. However, when I selected the product, I choose the product from the wrong storage bin.
The storage bin I selected from has a book quantity of 3438. I changed the storage bin to the correct one (which was also in another warehouse), but left the book quantity there.
I selected quantity count to 38 and saved the line.
I was expecting the 38 quantity to appear in the customer stock report, but it didn't. I spoke with Asier and we found out that the system was doing something incorrect and considered that the product now had a minus quantity of 3400 instead of positive of 38.
We did another Physical Inventory for a very large quantity to outbalance the 3400 minus and bring it back to a plus quantity, since the Customer Stock Report only shows positive quantities, but even after doing that the product didn't appear in the report. It seemed like the logic was completely broken.

Steps To Reproduce

I recreated the problem with another product and the exact same problem appeared.
The product movement report showed that the new location (which had 0 of that product in it before) has a inventory regulation of -3400 units.

Proposed Solution

The problem is that I could change the storage bin (by clicking the selector next to the field and selecting the correct bin), but it didn't wipe out the book quantity which is actually related to the old bin.

The logic should be that the book quantity should be updated also, or that you have to reselect the product, but this time from the correct bin.

Tags

comsup_sprint5

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0004375

closed

AinhoaPagola

Physical Inventory: When changing the storage bin, but leaving the book quantity there, a minus quantity is the result

Notes
(0012645) svnbot (reporter) 2009-01-26 17:46	Repository: openbravo Revision: 12276 Author: AinhoaPagola Date: 2009-01-26 17:46:18 +0100 (Mon, 26 Jan 2009) Fixes bug 0004910 Callout created for location and attribute changes in physical inventory lines. --- A branches/r2.40/src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Locator.java A branches/r2.40/src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Locator_data.xsql U branches/r2.40/src-db/database/sourcedata/AD_CALLOUT.xml U branches/r2.40/src-db/database/sourcedata/AD_COLUMN.xml U branches/r2.40/src-db/database/sourcedata/AD_MODEL_OBJECT.xml U branches/r2.40/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12276&sc=1 [^]

(0014981) sureshbabu (reporter) 2009-03-26 08:33	retested working fine

Issue History
Date Modified	Username	Field	Change
2008-09-09 17:26	anonymous	New Issue
2008-09-09 17:26	anonymous	Assigned To	=> gorkaion
2008-09-09 17:26	anonymous	Status	new => scheduled
2008-09-09 17:26	anonymous	fix_in_branch	=> 2.40
2009-01-09 11:11	rafaroda	Assigned To	gorkaion => AinhoaPagola
2009-01-26 17:46	svnbot	Checkin
2009-01-26 17:46	svnbot	Note Added: 0012645
2009-01-26 17:46	svnbot	Status	scheduled => resolved
2009-01-26 17:46	svnbot	Resolution	open => fixed
2009-01-26 17:46	svnbot	svn_revision	=> 12276
2009-01-29 11:51	AinhoaPagola	Tag Attached: comsup_sprint5
2009-03-03 17:32	psarobe	Fixed in Version	=> 2.40MP3
2009-03-24 11:01	psarobe	Fixed in Version	2.40MP3 => 2.40MP4
2009-03-26 08:33	sureshbabu	Regression testing	=> No
2009-03-26 08:33	sureshbabu	Status	resolved => closed
2009-03-26 08:33	sureshbabu	Note Added: 0014981