Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038855Openbravo ERP03. Procurement managementpublic2018-06-28 12:212018-08-08 13:06
Reportermartinsdan 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version3.0PR18Q4 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket2906
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038855: Error in 'Purchase Order Report' is not user friendly
DescriptionThe error shown in 'Purchase Order Report' when there is no conversion rate between the selected currency and the document's currency is not user friendly:

Error executing SQL statement for : ReportPurchaseOrder
Steps To ReproduceIn https://livebuilds.openbravo.com/erp_pi_pgsql/ [^]

- Navigate to Purchase Order Report
- Select starting date 01-01-2018
- Select currency AED

The following error is shown:
Error executing SQL statement for : ReportPurchaseOrder
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038907 closed caristu DB errors which several OB messages are not correctly parsed in PG 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-06-28 12:21martinsdanNew Issue
2018-06-28 12:21martinsdanAssigned To => Triage Finance
2018-06-28 12:21martinsdanOBNetwork customer => Yes
2018-06-28 12:21martinsdanModules => Core
2018-06-28 12:21martinsdanTriggers an Emergency Pack => No
2018-06-28 12:36ngarciaIssue Monitored: networkb
2018-06-28 12:36ngarciaSupport ticket => 2906
2018-06-28 12:36ngarciaResolution time => 1531951200
2018-07-02 15:54SandrahuguetAssigned ToTriage Finance => AtulOpenbravo
2018-07-17 21:27collazoandy4Assigned ToAtulOpenbravo => collazoandy4
2018-07-17 21:27collazoandy4Statusnew => scheduled
2018-07-19 11:50dmiguelezAssigned Tocollazoandy4 => platform
2018-08-02 09:25caristuAssigned Toplatform => caristu
2018-08-02 10:26alostaleRelationship addedrelated to 0038907
2018-08-03 08:31caristuSummaryError in 'Purchase Order Report' => Error in 'Purchase Order Report' is not user friendly
2018-08-03 08:31caristuDescription Updatedbug_revision_view_page.php?rev_id=17485#r17485
2018-08-03 08:31caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17487#r17487
2018-08-03 08:34caristuReview Assigned To => caristu
2018-08-03 08:34caristuAssigned Tocaristu => alostale
2018-08-03 08:38hgbotCheckin
2018-08-03 08:38hgbotNote Added: 0106129
2018-08-03 08:38hgbotStatusscheduled => resolved
2018-08-03 08:38hgbotResolutionopen => fixed
2018-08-03 08:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/97100140eab316b83e37c1c539f7a2bb0a59c705 [^]
2018-08-03 08:39caristuNote Added: 0106130
2018-08-03 08:39caristuStatusresolved => closed
2018-08-03 08:39caristuFixed in Version => 3.0PR18Q4
2018-08-08 13:06hudsonbotCheckin
2018-08-08 13:06hudsonbotNote Added: 0106239

Notes
(0106129)
hgbot   
2018-08-03 08:38   
Repository: erp/devel/pi
Changeset: 97100140eab316b83e37c1c539f7a2bb0a59c705
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Aug 02 13:19:02 2018 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/97100140eab316b83e37c1c539f7a2bb0a59c705 [^]

fixes issue 38855: Error shown in Purchase Order Report is not user friendly

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/report/BaseReportActionHandler.java
M src/org/openbravo/service/db/DbUtility.java
---
(0106130)
caristu   
2018-08-03 08:39   
Code reviewed + tested OK.
(0106239)
hudsonbot   
2018-08-08 13:06   
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/bfd7a414183a [^]
Maturity status: Test