Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009418Openbravo ERP07. Sales managementpublic2009-01-27 18:432009-06-17 12:05
Reporternetworkb 
Assigned Toareefbasha 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP6 
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
Summary0009418: 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 Reproduce1) Go to Sales Management || Analysis Tools || Sales Report by Partner and Product
2) If any of the products have a translation in Spanish, you will see it in Spanish.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0007159 closed gorkaion ReportSalesPartnerProduct_srpt.jrxml subreport should take into account session language 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-10 11:14gorkaionTypedefect => backport
2009-06-10 11:14gorkaionfix_in_branch => 2.40
2009-06-10 11:15gorkaionAssigned Togorkaion => rafaroda
2009-06-10 11:28rafarodaAssigned Torafaroda => areefbasha
2009-06-10 11:28rafarodaProposed Solution updated
2009-06-15 14:23hgbotCheckin
2009-06-15 14:23hgbotNote Added: 0017307
2009-06-15 14:23hgbotStatusscheduled => resolved
2009-06-15 14:23hgbotResolutionopen => fixed
2009-06-15 14:23hgbotFixed in SCM revision12384 => http://code.openbravo.com/erp/stable/2.40/rev/77b2613dfd4a87be22834f55a8968f0a70059df2 [^]
2009-06-17 09:39psarobeFixed in Version => 2.40MP6
2009-06-17 12:05psarobeStatusresolved => closed

Notes
(0017307)
hgbot   
2009-06-15 14:23   
Repository: erp/stable/2.40
Changeset: 77b2613dfd4a87be22834f55a8968f0a70059df2
Author: Areef Basha <areef.basha <at> openbravo.com>
Date: Mon Jun 15 17:50:14 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/77b2613dfd4a87be22834f55a8968f0a70059df2 [^]

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

---
M src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jrxml
---