How can the $ sign be displayed instead of the USD currency code?

baobao

In several countries it is common business practice to display the currency symbol, such as '£', '?' or '$', in an invoice instead of the currency code, e.g. GBP, EUR or USD.Some of those currencies are predefined in the system with the currency code as 'Code' in the 'Currencies - Setup' (Administration -> Set Up -> Financials -> Currencies).


However, once a currency has been linked to a Business Partner or been defined as either 'Local currency' (LC) or 'System Currency' (SC) or a transaction has taken place there is no possibility to change the code of a currency. However, the 'International Code' can be modified.When the currency symbol is defined in the 'International code' field it can be used it in the Print Layout Designer.


To update a print out to include the currency symbol rather than its code:
1.         Open the print template of the document in question.
2.         Go to Print Layout Designer -> Display Document Properties ->General tab
3.         Select the option 'Foreign'.  

  
When the document is printed out the currency symbol is displayed instead of its code.
Some fields like the 'Gross Price' will not have the currency code changed to the currency sign.


In order to provide the partner with an invoice with the correct currency symbol, the PLD template of the invoice can be modified to display the currency symbol instead of the currency code, e.g. $ instead of USD.
Each field which should contain a currency symbol needs to be modified. To do this:
-          Create a text field to display the currency symbol. Set the field as 'invisible' and set is measurements to '0'.
-          Locate the field 'Unique_ID' (General tab of the Field's Properties) of the field to be modified.
-          Create a Formula field.
-        Insert the following formula:
-        Concat(Concat(Amount(A), ' '),B)
-        Replace A by the field Id of the field with Price and currency code
-        Replace B with the field Id of the text field you created at the first step.
Explanation of the formula:
The command 'Amount( )' will only keep the amount figure from a field where the Price and the Currency are displayed together, for example. USD10 will become 10.
The command 'Concat( , )' will combine the information into one sentence, for example: Concat (Amount(USD10), 'A ') will combine to be USD10A .
The ' ' will bring a space between the amount and the symbol.
-        If 10 USD needs to become 10 $ then the 'Concat( , ) statement would read: Concat(Concat(Amount(10 USD), ' '),$)
-        If the currency symbol is required be before the amount figure (e.g. $ 10) then in the formula the 'A' and 'B' need to be inverted, e.g. Concat(Concat(Amount(B), ' '),A)