Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010758Openbravo ERP04. Warehouse managementpublic2009-09-25 08:412012-05-25 12:12
arunkumar 
naiaramartinez 
normalmajorhave not tried
closedfixed 
5
2.50MP6 
3.0MP12 
Core
No
0010758: Results are not properly formatted in Warehouse control report.
Results are not properly formatted in Warehouse control report.
Login 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)
OB3-Reviewed, VMA-Reviewed
jpg 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
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