Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010758Openbravo ERP04. Warehouse managementpublic2009-09-25 08:412012-05-25 12:12
Reporterarunkumar 
Assigned Tonaiaramartinez 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP6 
Target VersionFixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010758: Results are not properly formatted in Warehouse control report.
DescriptionResults are not properly formatted in Warehouse control report.
Steps To ReproduceLogin as userA/userA
Perform Physical Inventory,Goods receipt and Goods shipment transactions.

Go to Warehouse Management || Analysis Tools || Warehouse Control Report
Click HTML Format.

Results are displayed but all are displayed in one table. But in Oracle context we have seperate tables for each and every transaction. For example Physical Inventory, Goods Shipment with document numbers. (Please refer the screenshots to identify the difference)
Proposed Solution
Additional Information
TagsOB3-Reviewed, VMA-Reviewed
Relationships
Attached Filesjpg OracleWareHouse.JPG (236,342) 2009-09-25 08:41
https://issues.openbravo.com/file_download.php?file_id=1785&type=bug
jpg

jpg PostgresWareHouse.JPG (214,592) 2009-09-25 08:42
https://issues.openbravo.com/file_download.php?file_id=1786&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-09-25 08:41arunkumarNew Issue
2009-09-25 08:41arunkumarAssigned To => rafaroda
2009-09-25 08:41arunkumarFile Added: OracleWareHouse.JPG
2009-09-25 08:42arunkumarFile Added: PostgresWareHouse.JPG
2009-09-29 23:09psarobeStatusnew => scheduled
2009-09-29 23:09psarobefix_in_branch => pi
2010-02-11 18:05rafarodaAssigned Torafaroda => adrianromero
2011-06-03 11:00dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:11dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-10-29 20:48psarobeTag Attached: OB3-Reviewed
2012-02-15 19:04iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 17:27vmromanosTag Attached: VMA-Reviewed
2012-05-10 12:13gorka_gilAssigned Tovmromanos => mirurita
2012-05-14 09:15naiaramartinezAssigned Tomirurita => naiaramartinez
2012-05-14 09:24naiaramartinezNote Added: 0048606
2012-05-18 14:46hgbotCheckin
2012-05-18 14:46hgbotNote Added: 0048771
2012-05-18 14:46hgbotStatusscheduled => resolved
2012-05-18 14:46hgbotResolutionopen => fixed
2012-05-18 14:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/77280833bda6581d8c7cc010a5d0783810d62dfc [^]
2012-05-18 14:52miruritaNote Added: 0048773
2012-05-18 14:52miruritaStatusresolved => closed
2012-05-18 14:52miruritaFixed in Version => 3.0MP12
2012-05-25 12:12hudsonbotCheckin
2012-05-25 12:12hudsonbotNote Added: 0049166

Notes
(0048606)
naiaramartinez   
2012-05-14 09:24   
Test Plan:
  Go to Warehouse Control Report and press 'HTML Format' button.
  Notice that there are separate tables for each and every transaction.
(0048771)
hgbot   
2012-05-18 14:46   
Repository: erp/devel/pi
Changeset: 77280833bda6581d8c7cc010a5d0783810d62dfc
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon May 14 09:31:01 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/77280833bda6581d8c7cc010a5d0783810d62dfc [^]

fixed bug 10758 Change Warehouse Control Report.Add Coalesce in order to
get c_project.value when this is not null. If this is null get ''.

---
M src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl_data.xsql
---
(0048773)
mirurita   
2012-05-18 14:52   
code review + testing OK

It was only failing in PostgreSQL. Now same result in both databases.
(0049166)
hudsonbot   
2012-05-25 12:12   
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/5401e185a8b0 [^]

Maturity status: Test