Currency symbols do not display

If you are using an Access database, and have input values using the money or smallmoney data types, Proficy Portal will not display the currency symbol when showing values in the Statement Builder.

The Currency field type is specific to the Access database. Since the Proficy Portal Statement Builder is based on SQL, it has no concept of currency. The Proficy Portal Statement Builder will display the result as a decimal value.