Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011473Openbravo ERP09. Financial managementpublic2009-11-24 13:092010-01-22 00:00
Reportergorkaion 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.50MP8 
Target Version2.50MP10Fixed in Version2.50MP10 
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
Summary0011473: Withholding report doesn't export to pdf
DescriptionThe withholding report doesn't export the results to pdf. The same issue has been reproduced in pi with postgresql.

This is the error message:
      
Error:
The number is not correct.You may check the data
Steps To ReproduceGo to: Financial Management || Accounting || Analysis Tools || Withholding Report || Withholding Report

Set any date range and and press the print icon.
Proposed SolutionIt is an UUID related issue. The client and org filter is not quoting the IDs.

This is part of the query that fails.

 WHERE AD_OrgInfo.AD_Client_ID IN (1000000) AND AD_OrgInfo.AD_Org_ID IN (0)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-24 13:09gorkaionNew Issue
2009-11-24 13:09gorkaionAssigned To => rafaroda
2009-11-27 17:47rafarodaAssigned Torafaroda => dalsasua
2009-11-27 17:47rafarodaPriorityimmediate => urgent
2009-11-27 17:47rafarodaStatusnew => scheduled
2009-12-14 02:42hgbotCheckin
2009-12-14 02:42hgbotNote Added: 0022727
2009-12-14 02:42hgbotStatusscheduled => resolved
2009-12-14 02:42hgbotResolutionopen => fixed
2009-12-14 02:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ffba35c94a861fb480f294835025aa7228e55c3a [^]
2009-12-15 04:56hudsonbotCheckin
2009-12-15 04:56hudsonbotNote Added: 0022791
2010-01-20 12:09psarobeStatusresolved => closed
2010-01-20 12:09psarobeFixed in Version => 2.50MP10
2010-01-22 00:00anonymoussf_bug_id0 => 2936679

Notes
(0022727)
hgbot   
2009-12-14 02:42   
Repository: erp/devel/pi
Changeset: ffba35c94a861fb480f294835025aa7228e55c3a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Dec 14 02:42:20 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ffba35c94a861fb480f294835025aa7228e55c3a [^]

Fixes issue 11473: Withholding report doesn't export to pdf

---
M src/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.java
---
(0022791)
hudsonbot   
2009-12-15 04:56   
---
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/e7ad8a48210d [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/obx/core/OpenbravoERP-2.50CI.15705.obx [^]
---