Format Currency Dialog Box

To accommodate companies located or doing business in countries other than the United States, Vision provides default currency formats for reports, checks, and other Vision output based on your settings in Regional and Language Options in Microsoft Windows. In certain cases, Vision provides the Format Currency dialog box so you can modify those default currency formats to meet special requirements.

In Reporting, you can modify the default currency formats for individual reports and for individual report columns. The Layout tab on the Options dialog box displays the default currency format for the report. That format, in turn, becomes the default format for each currency field on the report. You can modify the default format on the Layout tab, and you can modify the format for individual columns on the Columns tab. In either case, you change the settings on the Format Currency dialog box.

To review or change your settings for Windows, display the Windows Control Panel and double-click Regional and Language Options.

Location

To display the dialog box, complete the following steps:

  1. From the Vision Navigation menu, click Reporting and click the type of report.
  2. In the Reports grid, click the Options column for the report.
  3. Click .
  4. On the Options dialog box, select one of the following actions:
    Option Description
    To change the format for the report Click the Layout tab, and click in Currency in the Default Formats group box. (For the Key Financial Metrics report, click the Metrics tab.)
    To change the format for an individual column Click the Columns tab, click the Format grid column for the report column, and then  click .

Contents

Field Description
Type This field displays Currency. You cannot change it.
Sample This field displays the formats for positive amounts, negative amounts, and zero amounts. As you select formatting options, Vision updates these samples based on your selections.
Use default number of decimal places Select this option to use the default number of decimal places. To use a different number of decimal places, clear that check box and specify the number of decimal places in Decimal places. (Note that in some cases, Vision uses a fixed number of decimal places for a report column. If you specify a different number, it has no effect on those columns.)
Decimal places If you do not select Use default number of decimal places, select or enter the number of decimal places in Decimal places. (Note that in some cases, Vision uses a fixed number of decimal places for a report column. If you specify a different number, it has no effect on those columns.)
Digit grouping Select from the following digital grouping options:
  • 123456789Vision does not group digits.
  • Default groupingVision groups digits using the default grouping for the applicable culture. For example, if the culture for the report displayed in the Override regional settings field on the Layout tab is English (United States), this option is 123,456,789.
Negative number Specify how you want the report to indicate negative amounts:
  • Sign on front Vision displays a minus sign before the amount.
  • Sign on back Vision displays a minus sign after the amount.
  • Parentheses Vision displays the amount within parentheses.
Zero number Specify how you want the report to indicate zero amounts: display 0, display a short dash (-), or leave the space blank
  • 0Vision displays 0.
  • -Vision displays a short dash.
  • Do not displayVision leaves the space blank.
Currency symbol: Display If you use the Multicurrency feature, select from the following options for displaying currency symbols or currency codes with amounts:
  • Use currency symbol — Vision displays a currency symbol with amounts ($, for example).
  • Use currency code — Vision displays a three-character currency code with amounts (USD, for example).
  • Do not display — Vision does not display a currency symbol or code with amounts.
Currency symbol: Location If you use the Multicurrency feature and you select Use currency symbol or Use currency code in Display in the Currency symbol group box, select from the following location options for the currency symbol or code:
  • Left — Vision displays the currency symbol or code to the left of the amount.
  • Right — Vision displays the currency symbol or code to the right of the amount.
OK Click this button to close the Format Currency dialog box and apply the formatting options.
Cancel Click this button to close the Format Currency dialog box and discard any changes you made to the formatting options.
Help Click this button to display a help topic for the Format Currency dialog box.