Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028890Openbravo ERP04. Warehouse managementpublic2015-02-06 15:352015-02-23 05:11
ReporterVictorVillar 
Assigned Toumartirena 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0PR15Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2014-10-28
Regression introduced in release3.0PR14Q4
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/c58e4664c86607f5de979a3dc177b70751d2044f [^]
Triggers an Emergency PackNo
Summary0028890: Valued stock report is showing wrong qty after a manual cost adjustment
DescriptionValued stock report is showing wrong qty after a manual cost adjustment
Steps To ReproduceAs group admin role,
Create a new product
Introduce a new Costing register: España - Cost: 5, warehouse: blank


Go to Goods REceipt:
select the product created before.
qty: 100
Complete it.

Go to Transactions tab of the Product window:
  select the transaction created before.
  Click on Manual Cost Adjustment button
Accounting date: today + 20 days
transaction cost: 550

Realise that the Costing background finishes succesfully.

Go to Valued Stock Report:
date: today
the values are correct

Launch again the Valued stock report:
date: Today+20days+1 day

Realise that the qty is 200, and it is wrong. It should be 100
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by defect 0027995 closed dmiguelez Valued Stock Report filtered by Transaction Cost Dates 
causes defect 0029111 closed umartirena Valued Stock Report does not display data while filtering by Product Category 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-02-06 15:35VictorVillarNew Issue
2015-02-06 15:35VictorVillarAssigned To => Sandrahuguet
2015-02-06 15:35VictorVillarModules => Core
2015-02-06 15:35VictorVillarResolution time => 1425596400
2015-02-06 15:35VictorVillarRegression level => Production - QA Approved
2015-02-06 15:35VictorVillarRegression date => 2014-10-28
2015-02-06 15:35VictorVillarRegression introduced in release => 3.0PR14Q4
2015-02-06 15:35VictorVillarRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/c58e4664c86607f5de979a3dc177b70751d2044f [^]
2015-02-06 15:35VictorVillarTriggers an Emergency Pack => No
2015-02-06 15:35VictorVillarIssue Monitored: networkb
2015-02-08 10:33eintelauIssue Monitored: eintelau
2015-02-09 08:48SandrahuguetAssigned ToSandrahuguet => umartirena
2015-02-11 10:25hgbotCheckin
2015-02-11 10:25hgbotNote Added: 0074350
2015-02-11 10:25hgbotStatusnew => resolved
2015-02-11 10:25hgbotResolutionopen => fixed
2015-02-11 10:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3eb4cc22528301c45de404f17e32ad1bbd741cfe [^]
2015-02-11 13:11umartirenaNote Added: 0074351
2015-02-13 14:02hgbotCheckin
2015-02-13 14:02hgbotNote Added: 0074450
2015-02-18 08:41SandrahuguetReview Assigned To => Sandrahuguet
2015-02-18 09:51SandrahuguetNote Added: 0074576
2015-02-18 09:51SandrahuguetStatusresolved => closed
2015-02-18 09:51SandrahuguetFixed in Version => 3.0PR15Q2
2015-02-18 09:52SandrahuguetNote Added: 0074577
2015-02-18 09:52SandrahuguetNote Deleted: 0074576
2015-02-18 13:07dmitry_mezentsevRelationship addedcaused by 0027995
2015-02-23 05:11hudsonbotCheckin
2015-02-23 05:11hudsonbotNote Added: 0074747
2015-02-23 05:11hudsonbotCheckin
2015-02-23 05:11hudsonbotNote Added: 0074754
2015-03-03 16:06dmitry_mezentsevRelationship addedcauses 0029111

Notes
(0074350)
hgbot   
2015-02-11 10:25   
Repository: erp/devel/pi
Changeset: 3eb4cc22528301c45de404f17e32ad1bbd741cfe
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Wed Feb 11 10:24:41 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3eb4cc22528301c45de404f17e32ad1bbd741cfe [^]

Fixes bug 28890: Valued Stock Report shows correct qty with cost adjustments.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0074351)
umartirena   
2015-02-11 13:11   
The previous changeset has been backed out because the query was failing in Oracle:

https://code.openbravo.com/erp/devel/pi/rev/5c0fb19ddc23 [^]
(0074450)
hgbot   
2015-02-13 14:02   
Repository: erp/devel/pi
Changeset: c3acd6c8dc33ba02445f373a0c0a03d054931f3c
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Thu Feb 12 09:06:42 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c3acd6c8dc33ba02445f373a0c0a03d054931f3c [^]

Related to Bug 28890: Valued Stock Report shows correct qty with Cost Adjusments

The query is working in Postgres and in Oracle

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0074577)
Sandrahuguet   
2015-02-18 09:52   
Code review + testing OK
(0074747)
hudsonbot   
2015-02-23 05:11   
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/6856352d7235 [^]
Maturity status: Test
(0074754)
hudsonbot   
2015-02-23 05:11   
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/6856352d7235 [^]
Maturity status: Test