Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012205Openbravo ERP04. Warehouse managementpublic2010-02-10 15:002018-01-31 10:27
Reporterrafaroda 
Assigned ToTriage Omni WMS 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS30OS VersionProfessional Appliance
Product Version2.50MP10 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012205: Allow Physical Inventory with previous date
DescriptionIf you want to do a Physical Inventory with a previous date, on the Book Quantity appears the actual stock.
Steps To Reproduce-As Openbravo Admin go to Warehouse Management || Analysis Tools || Stock Report.
-Select Marble and realize that there are 240 units.

-Go to Procurement Management || Transactions || Goods Receipt
-Create a new record:
   -Product: Marble.
   -Quantity: 60.
-Save and complete.

-Go to Warehouse Management || Transactions || Physical Inventory
-Create a new record with a previous date, save and go to lines.
-Create a new record:
  -Product: Marble.
-Realize that on Book Quantity appears the actual stock. (300)
Proposed SolutionThe Book Quantity is calculated based on the current stock of the product when the inventory line is created. But is never recalculated if, while the inventory is in draft status, there has been transactions with dates prior the movement date of the physical inventory before.

When the Physical Inventory is processed the book quantity should be recalculated based on the movement date set on the header, including all the movements of that date.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00120422.50MP12 closed rafaroda The Book Quantity on Physical Inventory is not correct 
has duplicate feature request 0020995 closed jonalegriaesarte Physical inventory does not work properly when the date is different from now 
related to design defect 0035209 scheduled collazoandy4 Negative average cost after validating a costing rule in the past 
blocks feature request 0022895 new dmiguelez It would be fine to create a new costing rule taking into account stock in the past 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-10 15:00rafarodaNew Issue
2010-02-10 15:00rafarodaAssigned To => gorkaion
2010-02-10 15:00rafarodaIssue generated from0012042
2010-02-10 15:00rafarodaRelationship addedrelated to 0012042
2010-02-10 17:45gorkaionAssigned Togorkaion => rmorley
2010-02-10 17:45gorkaionProposed Solution updated
2012-07-11 18:48VictorVillarRelationship addedhas duplicate 0020995
2013-01-25 13:14VictorVillarRelationship addedblocks 0022895
2014-04-09 02:31eintelauIssue Monitored: eintelau
2016-05-19 13:47ngarciaIssue Monitored: ngarcia
2016-08-31 00:51IntegritasIssue Monitored: Integritas
2017-02-09 11:54ngarciaAssigned Tormorley => Triage Finance
2017-02-09 11:56ngarciaRelationship addedrelated to 0035209
2018-01-31 10:27ngarciaTriggers an Emergency Pack => No

There are no notes attached to this issue.