Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040676Openbravo ERP04. Warehouse managementpublic2019-04-24 17:492019-05-21 15:16
Reporterdmiguelez 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q3 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040676: 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
Additional Information
TagsNo tags attached.
Relationships
related to defect 0040670 closed Sandrahuguet Generate Aggregated Data Background process fail 
related to defect 0040623 closed nonofrancisco Valued Stock Report with aggregated data not working when filtering by old data 
related to defect 0040722 closed collazoandy4 MovementDate is filled with time and should contain only with the date 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-04-24 17:49dmiguelezNew Issue
2019-04-24 17:49dmiguelezAssigned To => dmiguelez
2019-04-24 17:49dmiguelezModules => Core
2019-04-24 17:49dmiguelezTriggers an Emergency Pack => No
2019-04-25 09:59dmiguelezSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=18673#r18673
2019-04-26 09:07hgbotCheckin
2019-04-26 09:07hgbotNote Added: 0111344
2019-04-26 09:07hgbotStatusnew => resolved
2019-04-26 09:07hgbotResolutionopen => fixed
2019-04-26 09:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ca3cd4151b46a751f2f50e6024835614f66e45bd [^]
2019-04-26 10:14dmiguelezRelationship addedrelated to 0040670
2019-04-26 10:15dmiguelezRelationship addedrelated to 0040623
2019-04-26 10:21SandrahuguetReview Assigned To => Sandrahuguet
2019-04-26 10:21SandrahuguetNote Added: 0111350
2019-04-26 10:21SandrahuguetStatusresolved => closed
2019-04-26 10:21SandrahuguetFixed in Version => 3.0PR19Q3
2019-04-30 13:31egoitzIssue cloned0040722
2019-04-30 13:31egoitzRelationship addedrelated to 0040722
2019-05-21 15:16hudsonbotCheckin
2019-05-21 15:16hudsonbotNote Added: 0112000

Notes
(0111344)
hgbot   
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   
2019-04-26 10:21   
Code review ok and tested in the customer environment and in F&B data
(0112000)
hudsonbot   
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