Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0014388
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2010-08-31 11:502010-09-13 12:38
ReportersivaramanView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision88baea3562a9
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50MP20SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0014388: 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
TagsRegression
Attached Filespng file icon error1.png [^] (32,592 bytes) 2010-08-31 11:50


png file icon error2.png [^] (36,512 bytes) 2010-08-31 11:51

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0030541)
adrianromero (manager)
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 (developer)
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 (manager)
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 (reporter)
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 (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-08-31 11:50 sivaraman New Issue
2010-08-31 11:50 sivaraman Assigned To => adrianromero
2010-08-31 11:50 sivaraman File Added: error1.png
2010-08-31 11:51 sivaraman File Added: error2.png
2010-08-31 12:15 adrianromero Tag Attached: Regression
2010-08-31 12:30 adrianromero Status new => scheduled
2010-08-31 12:30 adrianromero fix_in_branch => pi
2010-08-31 12:30 adrianromero Priority normal => immediate
2010-08-31 12:30 adrianromero fix_in_branch pi =>
2010-08-31 13:43 adrianromero Note Added: 0030541
2010-08-31 14:00 hgbot Checkin
2010-08-31 14:00 hgbot Note Added: 0030542
2010-08-31 14:00 hgbot Status scheduled => resolved
2010-08-31 14:00 hgbot Resolution open => fixed
2010-08-31 14:00 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/88baea3562a9f0bed9bbecf27db659a9f4129fcb [^]
2010-08-31 14:03 adrianromero Note Added: 0030543
2010-09-02 09:50 sureshbabu Note Added: 0030568
2010-09-02 09:50 sureshbabu Status resolved => closed
2010-09-02 09:51 sureshbabu Note Deleted: 0030568
2010-09-02 09:51 sureshbabu Note Added: 0030572
2010-09-03 19:43 psarobe version => 2.50MP20
2010-09-07 09:18 hudsonbot Checkin
2010-09-07 09:18 hudsonbot Note Added: 0030709
2010-09-13 12:38 anonymous sf_bug_id 0 => 3065192


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker