Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014388Openbravo ERP07. Sales managementpublic2010-08-31 11:502010-09-13 12:38
Reportersivaraman 
Assigned Toadrianromero 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP20 
Target VersionFixed in Version 
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
Summary0014388: Print Record is not working for Sales Order
DescriptionIt is not possible to print Sales Order as it throws JRException. This misbehavior can be identified only with Oracle.
Steps To Reproduce1. Log on to Openbravo with 'Openbravo Admin' role
2. Go to Sales Management || Transactions || Sales Order
3. Open any Sales Order
4. Click 'Print Record'
5. A dialog box will be appeared with 'Yes' and 'No, just print it' options
6.a. Click 'Yes' and realize JRException is displayed on the screen
6.b. Click 'No, just print it' and realize Report processing failed
Proposed Solution
Additional Information
TagsRegression
Relationships
Attached Filespng error1.png (32,592) 2010-08-31 11:50
https://issues.openbravo.com/file_download.php?file_id=2998&type=bug
png

png error2.png (36,512) 2010-08-31 11:51
https://issues.openbravo.com/file_download.php?file_id=2999&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-08-31 11:50sivaramanNew Issue
2010-08-31 11:50sivaramanAssigned To => adrianromero
2010-08-31 11:50sivaramanFile Added: error1.png
2010-08-31 11:51sivaramanFile Added: error2.png
2010-08-31 12:15adrianromeroTag Attached: Regression
2010-08-31 12:30adrianromeroStatusnew => scheduled
2010-08-31 12:30adrianromerofix_in_branch => pi
2010-08-31 12:30adrianromeroPrioritynormal => immediate
2010-08-31 12:30adrianromerofix_in_branchpi =>
2010-08-31 13:43adrianromeroNote Added: 0030541
2010-08-31 14:00hgbotCheckin
2010-08-31 14:00hgbotNote Added: 0030542
2010-08-31 14:00hgbotStatusscheduled => resolved
2010-08-31 14:00hgbotResolutionopen => fixed
2010-08-31 14:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/88baea3562a9f0bed9bbecf27db659a9f4129fcb [^]
2010-08-31 14:03adrianromeroNote Added: 0030543
2010-09-02 09:50sureshbabuNote Added: 0030568
2010-09-02 09:50sureshbabuStatusresolved => closed
2010-09-02 09:51sureshbabuNote Deleted: 0030568
2010-09-02 09:51sureshbabuNote Added: 0030572
2010-09-03 19:43psarobeversion => 2.50MP20
2010-09-07 09:18hudsonbotCheckin
2010-09-07 09:18hudsonbotNote Added: 0030709
2010-09-13 12:38anonymoussf_bug_id0 => 3065192

Notes
(0030541)
adrianromero   
2010-08-31 13:43   
This error is a consequence of the following changeset: https://code.openbravo.com/erp/devel/pi/rev/13df5b8fc723 [^]
(0030542)
hgbot   
2010-08-31 14:00   
Repository: erp/devel/pi
Changeset: 88baea3562a9f0bed9bbecf27db659a9f4129fcb
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Aug 31 13:59:57 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/88baea3562a9f0bed9bbecf27db659a9f4129fcb [^]

Fixes issue 0014388: Print Record is not working for Sales Order
It has been wrapped the fields UOM, CURRENCY and VALUE with the TO_CHAR() function to unify the type accross the sentences in the UNION. This way the sentence works properly in Oracle.

---
M src/org/openbravo/erpReports/C_OrderLinesJR.jrxml
---
(0030543)
adrianromero   
2010-08-31 14:03   
* Testing the issue

Using Oracle and PostgreSQL as database engine try to print a sales order. It should generate a PDF document with the details of the order.

* Other areas affected

It has only been modified the SQL sentence of the sales report executed when printing sales order documents. No other areas affected.
(0030572)
sureshbabu   
2010-09-02 09:51   
verified, now sales order can be printed

Note: in the PDF file, the BP address value (Mafalda\n\nShunny shunshine\n11111\n\n\n) not rightly printed, i will raise a new issue for this.
(0030709)
hudsonbot   
2010-09-07 09:18   
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/88baea3562a9 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4390fe5213a4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18274.obx [^]