Currency Picture

Setup > Configuration > System > Advanced Options and Settings

To change the currency picture (display), select Setup > Configuration > System > Advanced Options and Settings.

It is very important to make sure you have a negative sign or parenthesis to specify negative values. If you fail to do so, negative numbers will display as positive numbers and errors can occur.

Token	Meaning
@N	Indicate a number
~sign~	Optional - Show a sign
-	Optional - Show the negative sign to the left
xx	Number of digits to left
.	Decimal point
xx	Number of digits to right
~sign~	Optional - Show the negative sign to the right

 

Dollar/Euro	Result	Format
@N$-14.2B	$-2,347.25	Leading dollar sign, blank if zero
@N~€~-14.2B	€-2,347.25	Leading Euro sign, blank if zero
@N$14.2-	$2,347.25-	Leading dollar sign, trailing minus when negative
@N$(14.2)	$(2,347.25)	Leading dollar sign, in parens when negative
@N-14	112,347	Whole Number currency

 

Int'l Currency	Result	Format
@N~£~14.2	£1,240.50	United Kingdom
@N~kr~14'2	kr1.430,50	Norway
@N14_'2~ mk~	1 430,50 mk	Finland
@N14'2~ kr~	1.430,50 kr	Sweden

Number Pictures

Picture	Result
@N-13	1,123,456
@N-13.2	1,234,456.10
@N13.2-	2,347.25-
@N(13.2)	(2,347.25)