Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031036Openbravo ERP04. Warehouse managementpublic2015-10-02 14:562015-10-20 11:28
ReporterVictorVillar 
Assigned Toaferraz 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0PR16Q1Fixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031036: Wrong on hand quantity calculation in Inventory Amount Update
DescriptionWrong on hand quantity calculation in Inventory Amount Update
Steps To ReproduceAs group admin role,
  Create a new product
 Create a purchase order for today
 Create the goods receipt related: movement date = today
    qty: 10000


Create a purchase order. Date: one month ago
 Create the goods receipt related: movement date = one month ago
    qty: 200

Launch the costing background process and check that is finished successfully.

Go to Inventory Amount Update window,
  define a date between the first movement date (one moth ago) and the second one (today). Select the product and check that the qty on hand is 0 and should be 200. Only if the "Fix Backdated Transaction" check = No.

Check the query getStockOnMovementDate in the CostAdjustmentUtils.java
   
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-02 14:56VictorVillarNew Issue
2015-10-02 14:56VictorVillarAssigned To => Triage Finance
2015-10-02 14:56VictorVillarModules => Core
2015-10-02 14:56VictorVillarResolution time => 1444082400
2015-10-02 14:56VictorVillarTriggers an Emergency Pack => No
2015-10-05 12:44VictorVillarRelationship addedrelated to 0031026
2015-10-05 13:45aferrazAssigned ToTriage Finance => aferraz
2015-10-05 13:45aferrazStatusnew => scheduled
2015-10-06 11:01aferrazNote Added: 0080837
2015-10-09 11:02aferrazStatusscheduled => feedback
2015-10-13 11:56vmromanosTarget Version3.0PR15Q4 => 3.0PR16Q1
2015-10-19 12:15psanjuanNote Added: 0081073
2015-10-19 12:40psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=9702#r9702
2015-10-19 12:41psanjuanNote Edited: 0081073bug_revision_view_page.php?bugnote_id=0081073#r9704
2015-10-19 14:58psanjuanNote Edited: 0081073bug_revision_view_page.php?bugnote_id=0081073#r9714
2015-10-20 10:06psanjuanNote Edited: 0081073bug_revision_view_page.php?bugnote_id=0081073#r9720
2015-10-20 11:10psanjuanNote Edited: 0081073bug_revision_view_page.php?bugnote_id=0081073#r9721
2015-10-20 11:10psanjuanStatusfeedback => scheduled
2015-10-20 11:10psanjuanStatusscheduled => resolved
2015-10-20 11:10psanjuanResolutionopen => no change required
2015-10-20 11:10psanjuanFixed in SCM revision => documentation
2015-10-20 11:28VictorVillarReview Assigned To => VictorVillar
2015-10-20 11:28VictorVillarStatusresolved => closed

Notes
(0080837)
aferraz   
2015-10-06 11:01   
Test plan:

As group admin role:

 Create a new product

Create a purchase order for today
Create the goods receipt related: movement date = today
  qty: 10000

Create a purchase order. Date: one month ago
Create the goods receipt related: movement date = one month ago
    qty: 200

Launch the costing background process and check that is finished successfully.

Go to Inventory Amount Update window
Define a date between the first movement date (one moth ago) and the second one (today).
Select the product and check that the qty on hand is 200.

Run Stock Report with the same date and product and realize the stock is the same.
(0081073)
psanjuan   
2015-10-19 12:15   
(edited on: 2015-10-20 11:10)
This is not an issue (defect).

Inventory Amount Update wiki article improved as it explains now that the stock shown will be Ok if the "Fix backdated transaction" flag is active.

Review this wiki article: http://wiki.openbravo.com/wiki/Inventory_Amount_Update#Lines [^]