Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022983Openbravo ERP04. Warehouse managementpublic2013-02-05 18:142013-02-28 22:28
ReporterVictorVillar 
Assigned Tojecharri 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP21Fixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket18673
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022983: Wrong query in Valued Stock Report
DescriptionWrong query in Valued Stock Report. On subquery ZZ it should be added

(A.QTY <> 0 OR A.Suma <> 0)) ZZ

instead of A.QTY <> 0) ZZ
Steps To ReproduceWrong query in Valued Stock Report. On subquery ZZ it should be added

(A.QTY <> 0 OR A.Suma <> 0)) ZZ

instead of A.QTY <> 0) ZZ
Proposed SolutionWrong query in Valued Stock Report. On subquery ZZ it should be added

(A.QTY <> 0 OR A.Suma <> 0)) ZZ

instead of A.QTY <> 0) ZZ
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff issue_22983.diff (756) 2013-02-07 22:30
https://issues.openbravo.com/file_download.php?file_id=5950&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-02-05 18:14VictorVillarNew Issue
2013-02-05 18:14VictorVillarAssigned To => dmiguelez
2013-02-05 18:14VictorVillarModules => Core
2013-02-05 18:14VictorVillarOBNetwork customer => Yes
2013-02-05 18:14VictorVillarSupport ticket => 18673
2013-02-05 18:14VictorVillarResolution time => 1374271200
2013-02-05 18:14VictorVillarTriggers an Emergency Pack => No
2013-02-05 18:15VictorVillarIssue Monitored: networkb
2013-02-06 12:12dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-02-07 22:10jecharriAssigned Tojonalegriaesarte => jecharri
2013-02-07 22:29jecharriStatusnew => scheduled
2013-02-07 22:29jecharrifix_in_branch => pi
2013-02-07 22:30jecharriFile Added: issue_22983.diff
2013-02-07 22:37jecharriNote Added: 0056275
2013-02-11 12:20hgbotCheckin
2013-02-11 12:20hgbotNote Added: 0056322
2013-02-11 12:20hgbotStatusscheduled => resolved
2013-02-11 12:20hgbotResolutionopen => fixed
2013-02-11 12:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c2faeaac0dbd029171d4abc0a80fcf87141f66fa [^]
2013-02-20 04:49hudsonbotCheckin
2013-02-20 04:49hudsonbotNote Added: 0056556
2013-02-28 22:28VictorVillarReview Assigned To => VictorVillar
2013-02-28 22:28VictorVillarNote Added: 0056864
2013-02-28 22:28VictorVillarStatusresolved => closed

Notes
(0056275)
jecharri   
2013-02-07 22:37   
Issue resolved.
Pending to unfreeze pi
(0056322)
hgbot   
2013-02-11 12:20   
Repository: erp/devel/pi
Changeset: c2faeaac0dbd029171d4abc0a80fcf87141f66fa
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Feb 07 22:28:51 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c2faeaac0dbd029171d4abc0a80fcf87141f66fa [^]

Fixes issue 22983: Wrong query in Valued Stock Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql
---
(0056556)
hudsonbot   
2013-02-20 04:49   
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/d828167a9e83 [^]

Maturity status: Test
(0056864)
VictorVillar   
2013-02-28 22:28   
Verified