Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0002509Openbravo ERP07. Sales managementpublic2008-01-16 06:002008-12-15 19:53
user71 
iperdomo 
normalminoralways
closedfixed 
5
 
2.40 
No
Core
No
0002509: Dollar Symbol in reports when currency is Indian Rupee
I have taken a report on sales invoices, the transactions that i have done is getting correctly, but it is always getting the total amount in the "dollar Symbol($)" at the end, even though i have selected the currency as "Indian Rupee(INR)".
 
(Example: Check Sales invoice, when print button is pressed)
 
And i have observed in all the reports, the dollar symbol is coming the same.
 
And,the address that is printing is same for all the Business partners.
No tags attached.
related to backport 0004560 closed rafaroda [OBN] Dollar Symbol in reports when currency is Indian Rupee 
Issue History
2008-06-13 19:29cromeroStatusnew => scheduled
2008-06-13 19:58cromeroTarget Version => 2.40
2008-08-01 18:27plujanRelationship addedrelated to 0004560
2008-08-01 18:31marvintmAssigned Tomarvintm => iperdomo
2008-08-01 18:31svnbotCheckin
2008-08-01 18:31svnbotNote Added: 0008466
2008-08-01 18:31svnbotStatusscheduled => resolved
2008-08-01 18:31svnbotResolutionopen => fixed
2008-08-01 18:31svnbotsvn_revision => 6130
2008-12-15 19:53psarobeRegression testing => No
2008-12-15 19:53psarobeStatusresolved => closed

Notes
(0006098)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1872519 [^]
(0003016)
rafaroda   
2008-01-16 17:06   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1892190
Originator: NO

Hi,

Thank you for reporting this bug. Could you please give more information of your configuration following Openbravo bug reporting guidelines? http://wiki.openbravo.com/wiki/index.php/Bug_Reporting_Guidelines [^]

Did you perform the Initial Client Setup using Indian Rupee?

Kind regards,

Rafa Roda Palacios
Openbravo Team
(0003017)
user71   
2008-01-17 05:15   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1922171
Originator: YES

And i have selected Indian Rupee as a currency initial client setup also, fine it is working in whole application.
But, when i take the reports, the dollar symbol is appearing.
(0003018)
rafaroda   
2008-01-17 08:50   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1892190
Originator: NO

Could you please expose which version of Openbravo ERP and which database are you using?
(0003019)
user71   
2008-01-18 10:53   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1922171
Originator: YES

Sorry, for troubling u!
I am using openbravo 2.35 Version and Oracle 10g Express edition as a Database.

Thanks,
Naveen chanda
(0003020)
user71   
2008-01-22 13:50   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1922171
Originator: YES

Environment:
Version :2.35,
Database:oracle 10g xpress edition,
Yes, i have performed initial client setup with currency taken as Indian Rupee(INR), and it is done successfully.
The dollar symbol is coming when i press print button in sale order or sales invoice for a particular customer it shows end as dollar symbol.And it is same in the Purchase order also.

i am attaching a document file with printouts , please have a look.
Thanks,
Naveen Chanda





File Added: Bug in sales order.doc
(0003021)
user71   
2008-01-25 07:19   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1058384
Originator: NO

I'm having the same problem :)

How would I just apply this patch to an otherwise 2.35-MP1 system? I'm even quite happy to be able to switch off just the currency symbol and add it manually with ireport as I've customised the report extensively already.

Thanx

Anton
(0003022)
user71   
2008-01-25 08:30   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1922171
Originator: YES

Hi,
As u have give a comment on this issue(abt $ symbol) that u have done , will u give me the steps to customize the report that u have done.
It's urgent for me ...

Thanks,
Naveen Chanda.
(0003023)
user71   
2008-01-26 10:11   
(edited on: 2008-06-12 09:24)
Logged In: YES
user_id=1058384
Originator: NO

I did it!!!! :) (With bucketloads of help from katratxo on IRC, thanx!)
 

I modified 2.35 maintenance pack 1 as I don't want to run live on the svn ssources


After a normal install:

Checkout the svn sources:

svn co https://openbravo.svn.sourceforge.net/svnroot/openbravo/trunk [^] AppsOpenbravo

copy /the-svn-checkout/AppsOpenbravo/src/org/openbravo/erpReports/RptC_Invoice* to /the-normal-install/AppsOpenbravo/src/org/openbravo/erpReports

edit AppsOpenbravo/src/org/openbravo/base/secureApp/HttpSecureAppServlet.java

Find the lines:

      DecimalFormat NumberFormat = new DecimalFormat(variables.getSessionValue("#AD_ReportNumberFormat"), dfs);
      designParameters.put("NUMBERFORMAT", NumberFormat);

and change them to:

      DecimalFormat numberFormat = new DecimalFormat(variables.getSessionValue("#AD_ReportNumberFormat"), dfs);
      designParameters.put("NUMBERFORMAT", numberFormat);

Then I did in the normal install:

ant compile

I then edited the new version of RptC_Invoice.jrxml with ireport (http://www.jasperforge.org/jaspersoft/opensource/business_intelligence/ireport/ [^])
and copied it into /the-normal-install/AppsOpenbravo/src/org/openbravo/erpReports.

Then:

ant compile.src
ant war
ant deploy

restarted tomcat and the $ signs are gone!

Anton
(0008466)
svnbot   
2008-08-01 18:31   
Repository: openbravo
Revision: 6130
Author: iperdomo
Date: 2008-08-01 18:31:56 +0200 (Fri, 01 Aug 2008)

Fixes issue 2509

---
U branches/r2.3x/src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
---

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