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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009418
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementminoralways2009-01-27 18:432009-06-17 12:05
ReporternetworkbView Statuspublic 
Assigned Toareefbasha 
PriorityimmediateResolutionfixedFixed in Version2.40MP6
StatusclosedFix in branch2.40Fixed in SCM revision77b2613dfd4a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009418: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0007159 closedgorkaion ReportSalesPartnerProduct_srpt.jrxml subreport should take into account session language 

-  Notes
(0017307)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-06-10 11:14 gorkaion Type defect => backport
2009-06-10 11:14 gorkaion fix_in_branch => 2.40
2009-06-10 11:15 gorkaion Assigned To gorkaion => rafaroda
2009-06-10 11:28 rafaroda Assigned To rafaroda => areefbasha
2009-06-10 11:28 rafaroda Proposed Solution updated
2009-06-15 14:23 hgbot Checkin
2009-06-15 14:23 hgbot Note Added: 0017307
2009-06-15 14:23 hgbot Status scheduled => resolved
2009-06-15 14:23 hgbot Resolution open => fixed
2009-06-15 14:23 hgbot Fixed in SCM revision 12384 => http://code.openbravo.com/erp/stable/2.40/rev/77b2613dfd4a87be22834f55a8968f0a70059df2 [^]
2009-06-17 09:39 psarobe Fixed in Version => 2.40MP6
2009-06-17 12:05 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker