Get the proper currency format for a multi-currency, multi-language report

Description

When you want to create a multi-currency, multi-language report in Jasper, there's no easy way to get the currency formatted according to the customer language with the currency from the invoice.

Environment

None

Activity

Show:
Diego Ruiz
January 16, 2017, 11:03 PM

In Jasper Report edit an expression that needs to be formatted as described with the following code:

org.compiere.util.DisplayType.getCurrencyFormat("en_US", "EUR").format(46.20) //Replace the values with the ones you need

to get a result like EUR46.20 in your report

Take the language value from the business partner or the client and the currency iso code from the currency in the invoice.

Best Regards,
Diego Ruiz

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Carlos Ruiz

Reporter

Diego Ruiz