Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006790Openbravo ERP07. Sales managementpublic2009-01-08 08:092009-02-20 12:14
Reporterrafaroda 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionpiFixed in Versionpi 
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
Summary0006790: Shipment Report does not work in trunk
DescriptionDue to Material Transaction Report labeling project merge [1], Shipment Report stopped to work in trunk.

[1] https://dev.openbravo.com/websvn/openbravo/?rev=8967&sc=1 [^]
Steps To Reproduce1) Go to 'Sales Management || Analysis Tools || Shipment Report'
2) Execute the report without dates and you will get:
07:47:10 [http-8883-4] ERROR org.openbravo.erpCommon.ad_reports.ReportShipmentEditionJR - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: syntax error at or near ")"
3) Execute the report with dates and you will get:
07:46:50 [http-8883-4] ERROR org.openbravo.erpCommon.ad_reports.ReportShipmentEditionJR - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: operator does not exist: character varying = integer
Proposed Solution
Additional Information
Tagscomsup_sprint3
Relationships
related to feature request 00005502.50 closed vmromanos Material Transaction Report does not have clear labelling for shipments versus receipts 
Attached Filespng ShipmentReport.png (22,756) 2009-01-08 08:11
https://issues.openbravo.com/file_download.php?file_id=621&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-01-08 08:09rafarodaNew Issue
2009-01-08 08:09rafarodaAssigned To => rafaroda
2009-01-08 08:09rafarodasf_bug_id0 => 2493381
2009-01-08 08:09rafarodaRegression testing => No
2009-01-08 08:09rafarodaRelationship addedrelated to 0000550
2009-01-08 08:11rafarodaFile Added: ShipmentReport.png
2009-01-08 08:14svnbotCheckin
2009-01-08 08:14svnbotNote Added: 0011969
2009-01-08 08:14svnbotStatusnew => resolved
2009-01-08 08:14svnbotResolutionopen => fixed
2009-01-08 08:14svnbotsvn_revision => 11698
2009-01-08 10:47svnbotCheckin
2009-01-08 10:47svnbotNote Added: 0011974
2009-01-08 10:47svnbotsvn_revision11698 => 11705
2009-01-08 15:55rafarodaTag Attached: comsup_sprint3
2009-02-20 12:14sureshbabuStatusresolved => closed
2009-02-20 12:14sureshbabuNote Added: 0013824
2009-02-20 12:14sureshbabuFixed in Version => trunk

Notes
(0011969)
svnbot   
2009-01-08 08:14   
Repository: openbravo
Revision: 11698
Author: rafaroda
Date: 2009-01-08 08:14:01 +0100 (Thu, 08 Jan 2009)

Fixes bug 0006790 Now Shipment Report works in trunk.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/InoutEdition_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportShipmentEditionJR.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=11698&sc=1 [^]
(0011974)
svnbot   
2009-01-08 10:47   
Repository: openbravo
Revision: 11705
Author: rafaroda
Date: 2009-01-08 10:47:20 +0100 (Thu, 08 Jan 2009)

Fixes bug 0006790 Now Shipment Report works in trunk (part 2).

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionEdition.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=11705&sc=1 [^]
(0013824)
sureshbabu   
2009-02-20 12:14   
Retested in context 79.125.56.185/openbravotrunk