And that's exactly what i ended up doing. Added a row in a table that will hold the currency symbol. The value depends on which country uses the application.
Agreed! But this application has been in existence for years and was used in US until this year where we have the application in other countries. Yes, its a flaw...