Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0040676
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2019-04-24 17:492019-05-21 15:16
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PriorityurgentResolutionfixedFixed in Version3.0PR19Q3
StatusclosedFix in branchFixed in SCM revisionca3cd4151b46
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToSandrahuguet
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040676: Valued Stock Report not properly working when movementDate has more precision than days and aggregated data

DescriptionThe queries in the Valued Stock report assume that the precision of the movementDate field is days, if it has a greater precision than that, the values shown in the report might not be correct.

This happens when there is aggregated data
Steps To ReproduceThe queries in the Valued Stock report assume that the precision of the movementDate field is days, if it has a greater precision than that, the values shown in the report might not be correct.

This happens when there is aggregated data
Proposed SolutionTruncate the movementDate to have only precision for days
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0040670 closedSandrahuguet Generate Aggregated Data Background process fail 
related to defect 0040623 closednonofrancisco Valued Stock Report with aggregated data not working when filtering by old data 
related to defect 0040722 closedcollazoandy4 MovementDate is filled with time and should contain only with the date 

-  Notes
(0111344)
hgbot (developer)
2019-04-26 09:07

 Repository: erp/devel/pi
Changeset: ca3cd4151b46a751f2f50e6024835614f66e45bd
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Apr 25 09:54:50 2019 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ca3cd4151b46a751f2f50e6024835614f66e45bd [^]

Fixes Issue 40676. Trunc the movement date in the query filters
as it can have precision greater than days, but the comparison
is always done at day level

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
M src/org/openbravo/materialmgmt/GenerateValuedStockAggregated_data.xsql
---
(0111350)
Sandrahuguet (developer)
2019-04-26 10:21

 Code review ok and tested in the customer environment and in F&B data
(0112000)
hudsonbot (developer)
2019-05-21 15: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/9b8f37d9d85e [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2019-04-24 17:49 dmiguelez New Issue
2019-04-24 17:49 dmiguelez Assigned To => dmiguelez
2019-04-24 17:49 dmiguelez Modules => Core
2019-04-24 17:49 dmiguelez Triggers an Emergency Pack => No
2019-04-25 09:59 dmiguelez Steps to Reproduce Updated View Revisions
2019-04-26 09:07 hgbot Checkin
2019-04-26 09:07 hgbot Note Added: 0111344
2019-04-26 09:07 hgbot Status new => resolved
2019-04-26 09:07 hgbot Resolution open => fixed
2019-04-26 09:07 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ca3cd4151b46a751f2f50e6024835614f66e45bd [^]
2019-04-26 10:14 dmiguelez Relationship added related to 0040670
2019-04-26 10:15 dmiguelez Relationship added related to 0040623
2019-04-26 10:21 Sandrahuguet Review Assigned To => Sandrahuguet
2019-04-26 10:21 Sandrahuguet Note Added: 0111350
2019-04-26 10:21 Sandrahuguet Status resolved => closed
2019-04-26 10:21 Sandrahuguet Fixed in Version => 3.0PR19Q3
2019-04-30 13:31 egoitz Issue cloned 0040722
2019-04-30 13:31 egoitz Relationship added related to 0040722
2019-05-21 15:16 hudsonbot Checkin
2019-05-21 15:16 hudsonbot Note Added: 0112000

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker