Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031041Openbravo ERP04. Warehouse managementpublic2015-10-05 12:432015-11-23 21:16
ReporterVictorVillar 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket37791
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031041: The inventory amount update is not working fine under some circunstancies
DescriptionThe inventory amount update is not working fine under some circunstancies
Steps To ReproduceAs group admin role,
   Go to inventory amount update
       España
       date: today
  Go to Lines tab:
      date: 03/06/2015
      Product: Zumo de Naranja
      Unit cost: 200
Process it. Realise that the following error appears but it should not, because there is stock.
Insuffient stock for Product 'Zumo de Naranja Bio 0,33L' with Attribute 'L0', UOM 'Unit' and Storage Bin 'Rn-0-0-0'
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0031026 closed aferraz wrong warehouse in the lines of the inventory amount update 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-10-05 12:43VictorVillarNew Issue
2015-10-05 12:43VictorVillarAssigned To => Triage Finance
2015-10-05 12:43VictorVillarOBNetwork customer => Yes
2015-10-05 12:43VictorVillarModules => Core
2015-10-05 12:43VictorVillarSupport ticket => 37791
2015-10-05 12:43VictorVillarResolution time => 1444255200
2015-10-05 12:43VictorVillarTriggers an Emergency Pack => No
2015-10-05 12:44VictorVillarRelationship addedrelated to 0031026
2015-10-06 13:03aferrazAssigned ToTriage Finance => aferraz
2015-10-06 13:03aferrazStatusnew => scheduled
2015-10-06 14:52psanjuanNote Added: 0080844
2015-10-09 11:02aferrazStatusscheduled => feedback
2015-10-19 12:11psanjuanNote Added: 0081071
2015-10-19 15:00psanjuanNote Edited: 0081071bug_revision_view_page.php?bugnote_id=0081071#r9716
2015-10-19 15:01psanjuanNote Edited: 0081071bug_revision_view_page.php?bugnote_id=0081071#r9717
2015-10-19 16:36aferrazStatusfeedback => scheduled
2015-10-19 17:15aferrazNote Added: 0081097
2015-10-19 17:17aferrazNote Edited: 0081071bug_revision_view_page.php?bugnote_id=0081071#r9719
2015-10-22 10:04psanjuanNote Edited: 0081097bug_revision_view_page.php?bugnote_id=0081097#r9799
2015-10-22 10:09psanjuanNote Edited: 0081097bug_revision_view_page.php?bugnote_id=0081097#r9800
2015-10-22 10:55psanjuanNote Edited: 0081097bug_revision_view_page.php?bugnote_id=0081097#r9809
2015-10-22 10:56psanjuanNote Added: 0081191
2015-10-26 09:53hgbotCheckin
2015-10-26 09:53hgbotNote Added: 0081294
2015-10-26 09:53hgbotStatusscheduled => resolved
2015-10-26 09:53hgbotResolutionopen => fixed
2015-10-26 09:53hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9a8285081a6988ce808bdd4c49d1794c65b4eeed [^]
2015-10-26 09:54dmiguelezReview Assigned To => dmiguelez
2015-10-26 09:54dmiguelezNote Added: 0081295
2015-10-26 09:54dmiguelezStatusresolved => closed
2015-11-23 21:16hudsonbotCheckin
2015-11-23 21:16hudsonbotNote Added: 0082156

Notes
(0080844)
psanjuan   
2015-10-06 14:52   
Issue verified with below error message:
Insuffient stock for Product 'Zumo de Naranja Bio 0,33L' with Attribute 'L582', UOM 'Unit' and Storage Bin 'RS-0-0-0'

however stock is = 69100
(0081071)
psanjuan   
2015-10-19 12:11   
(edited on: 2015-10-19 17:17)
When the closing and opening inventories created by an Inventory Amount Update booked in the past are being processed, it is not necessary to check the stock (same as with "Reservations"), as an opening inventory is going to be created for the same quantity as closing inventory.
(0081097)
aferraz   
2015-10-19 17:15   
(edited on: 2015-10-22 10:55)
Test plan:

Make sure F&B España has assigned a costing rule with Average Algorithm configured. Warehouse Dimension = No.

As group admin role,
   Go to inventory amount update. Create a new one for F&B España on current date.
  Go to Lines tab:
      enter reference date: 03/06/2015
      Select Product: Zumo de Naranja
      Enter a Unit cost: 200
Process it. Check that the process is completed successfully.
(0081191)
psanjuan   
2015-10-22 10:56   
Test Plan above verified.
Checked that the process now is completed successfully, because now the stock is not check as it does not make any sense. Both a closing and an opening inventory for both warehouse with same stock details have been created.
(0081294)
hgbot   
2015-10-26 09:53   
Repository: erp/devel/pi
Changeset: 9a8285081a6988ce808bdd4c49d1794c65b4eeed
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Oct 19 17:11:49 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9a8285081a6988ce808bdd4c49d1794c65b4eeed [^]

Fixes issue 31041: Insuffient stock error message when processing an inventory

Avoid "insufficient stock" error message when processing an Inventory Amount Update created in the past.
Now, when processing related closing and opening inventories, negative stock will not be checked.

---
M src/org/openbravo/materialmgmt/InventoryCountProcess.java
---
(0081295)
dmiguelez   
2015-10-26 09:54   
Code Review + Testing Ok
(0082156)
hudsonbot   
2015-11-23 21:16   
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/7b56bebaaa88 [^]
Maturity status: Test