We used multi currency in our system with 2 different display format. For example, if user want to print one thousand four hundred, the amount in EUR and USD will be printed like this :

EUR 1.400,00 & USD 1,400.00

We can not change this settings as it is correct in report like purchase order and sales order.

However, if we print other report that exported to Excel, then we have a problem when the figures are in the same column. We can't do any data manipulation in the Excel.

I understand that this setting is set using session ttaad1106m000 and is applied to all report once it changed.

Any suggestion to solve the problem are appreciated.

Copy the report to ur customized VRC . Edit the report field . In the field Lang / curr (expr) , some values like tdpur040.ccur may be specified , instead write "USD" or "EUR" . The currency u specify will apply to all the values for that report field in the report .

U can also try char expression of length < 20 ( like "bx?"USD":supccur") in order to get the fix currency format when printing to excel and dynamic expression when printing to other device.

This u will have to do for all reports where u have the problem.