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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004375
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2008-07-10 19:412009-04-21 11:04
ReporterRenateNieuwkoopView Statuspublic 
Assigned ToAinhoaPagola 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision12267
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.35SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionWarehouse 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 ReproduceI 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 SolutionThe 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.
Tagscomsup_sprint5
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0004910 closedAinhoaPagola Physical Inventory: When changing the storage bin, but leaving the book quantity there, a minus quantity is the result 

-  Notes
(0008277)
psarobe (manager)
2008-07-11 12:31

 Hi Renate,

The bug has been change to minor because is not very common what you are doing. Said this we are agree with your solution. When changing the storage bin, a call-out will calculate the new "Quantity count" and "Book Quantity" depending in two things: Product and Attribute. So if for that product and attribute in that new storage bin doesn't exit anything the new value for "Quantity count" and "Book Quantity" will be 0
(0008278)
psarobe (manager)
2008-07-11 12:43

 One more thing. The reason why the ERP has allowed you to have negative stock is because your configuration allows to happen this.

Please go to General set->Client->Information and verify that the flag Allows negative stock is marked...that would the reason
(0012637)
svnbot (reporter)
2009-01-26 17:02

 Repository: openbravo
Revision: 12267
Author: AinhoaPagola
Date: 2009-01-26 17:01:49 +0100 (Mon, 26 Jan 2009)

Fixes bug 0004375 Callout created for location and attribute changes in physical inventory lines.

---
A trunk/src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Locator.java
A trunk/src/org/openbravo/erpCommon/ad_callouts/SL_Inventory_Locator_data.xsql
U trunk/src-db/database/sourcedata/AD_CALLOUT.xml
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
U trunk/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
U trunk/src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12267&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-07-10 19:41 RenateNieuwkoop New Issue
2008-07-10 19:41 RenateNieuwkoop Assigned To => cromero
2008-07-10 19:41 RenateNieuwkoop sf_bug_id 0 => 2015256
2008-07-11 12:31 psarobe Note Added: 0008277
2008-07-11 12:31 psarobe Severity major => minor
2008-07-11 12:43 psarobe Note Added: 0008278
2008-07-14 10:28 cromero Status new => scheduled
2008-07-14 10:28 cromero Assigned To cromero => gorkaion
2008-07-14 10:28 cromero fix_in_branch => trunk
2008-12-18 19:04 AinhoaPagola Assigned To gorkaion => AinhoaPagola
2009-01-26 17:02 svnbot Checkin
2009-01-26 17:02 svnbot Note Added: 0012637
2009-01-26 17:02 svnbot Status scheduled => resolved
2009-01-26 17:02 svnbot Resolution open => fixed
2009-01-26 17:02 svnbot svn_revision => 12267
2009-01-29 11:50 AinhoaPagola Tag Attached: comsup_sprint5
2009-04-21 11:04 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker