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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004375

Openbravo ERP

04. Warehouse management

public

2008-07-10 19:41

2009-04-21 11:04

Reporter

RenateNieuwkoop

Assigned To

AinhoaPagola

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.35

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0004375: 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.

Additional Information