Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007159Openbravo ERP07. Sales managementpublic2009-01-27 18:432009-06-10 11:14
Reporternetworkb 
Assigned Togorkaion 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
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
Summary0007159: ReportSalesPartnerProduct_srpt.jrxml subreport should take into account session language
DescriptionIf you look at ReportSalesPartnerProduct_srpt.jrxml query, you will see that language is not variable (es_ES). It should take into account the session language.

SELECT C_ORDER.C_BPARTNER_ID, AD_COLUMN_IDENTIFIER(to_char('M_PRODUCT'),
to_char(M_PRODUCT_ID), to_char('es_ES')) AS PRODUCT, SUM(C_ORDERLINE.LINENETAMT) as
LINENETAMT
FROM C_ORDER, C_ORDERLINE
WHERE C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID
AND ISSOTRX = 'Y'
AND C_ORDER.C_BPARTNER_ID = $P{PARTNER}
GROUP BY C_ORDERLINE.M_PRODUCT_ID, C_ORDER.C_BPARTNER_ID
ORDER BY C_ORDER.C_BPARTNER_ID
Steps To Reproduce
Proposed Solution
Additional Information
Tagscomsup_sprint5
Relationships
depends on backport 0009418 closed areefbasha ReportSalesPartnerProduct_srpt.jrxml subreport should take into account session language 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-27 18:43networkbNew Issue
2009-01-27 18:43networkbAssigned To => rafaroda
2009-01-27 18:43networkbsf_bug_id0 => 2540884
2009-01-27 18:43networkbRegression testing => No
2009-01-28 08:36rafarodaAssigned Torafaroda => gorkaion
2009-01-28 16:03svnbotCheckin
2009-01-28 16:03svnbotNote Added: 0012738
2009-01-28 16:03svnbotStatusnew => resolved
2009-01-28 16:03svnbotResolutionopen => fixed
2009-01-28 16:03svnbotsvn_revision => 12384
2009-02-06 01:17gorkaionTag Attached: comsup_sprint5
2009-04-21 11:04psarobeStatusresolved => closed
2009-06-10 11:13gorkaionStatusclosed => new
2009-06-10 11:13gorkaionResolutionfixed => open
2009-06-10 11:14gorkaionIssue Monitored: gorkaion
2009-06-10 11:14gorkaionIssue End Monitor: gorkaion
2009-06-10 11:14gorkaionStatusnew => scheduled
2009-06-10 11:14gorkaionfix_in_branch => pi
2009-06-10 11:14gorkaionStatusscheduled => resolved
2009-06-10 11:14gorkaionResolutionopen => fixed
2009-06-10 11:14gorkaionStatusresolved => closed

Notes
(0012738)
svnbot   
2009-01-28 16:03   
Repository: openbravo
Revision: 12384
Author: gorkaion
Date: 2009-01-28 16:03:42 +0100 (Wed, 28 Jan 2009)

Fixed bug 7159. Added the LANGUAGE parameter in the subreport so the product description is correctly translated.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jasper
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jrxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12384&sc=1 [^]