Managing Exchange Rates

Intro

Exchange rates determine the price of one country’s currency expressed in another country’s currency. Exchange rates are used to calculate the value of a security denominated in one currency while presented in another currency for reporting purposes. You can add an exchange rate to the Arc Suite database and review/edit existing exchange rates on the “Exchange Rates” page.

Certain functionality in this application area requires you to have one or more . For more information about any given right (i.e., what functionality it governs, etc.), please see the “Available User Rights” topic.

Tasks

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Exchange Rates” item.

      “Exchange Rates” page
    3. Use the “Source” drop-down list at upper-left of the page to specify the exchange rate source with which the new exchange rate will be associated.

    4. Use the “Time Zone” drop-down list at upper-left of the page to specify the time zone with which the new exchange rate will be associated.

      “(GMT) Dublin, Edinburgh, Lisbon, London” is selected by default.

    5. Use the “Date/Time” at upper-left of the page to specify the date and time with which the new exchange rate will be associated.
      1. If the date/time with which the new exchange rate will be associated is among those listed, select it.

      2. If the date/time you’re looking for isn’t in the list click the “Add” button at right of the “Date/Time” field .

        “Add a Date/Time” dialogue
        1. Click the “Date” button at right of the “Date” field to select the desired date from the calendar that displays.
        2. Click the “Time” button at right of the “Time” field to select a time from among those that display.

        3. Click the “Accept” button at lower-right of the dialogue.

    6. Use the “Type” drop-down list at upper-left of the page to specify the type of the new exchange rate (i.e., “Closed/Open” or “Average”).

    7. Click the “Search” button at right of the “Date/Time” field.

    8. Click the “Add” at lower-left of the grid to add a new exchange rate, if an exchange rate does not already exist that meets the specified search criteria.
      “Add/Edit Exchange Rate” dialogue
      1. Specify the “From Currency” for the exchange rate definition.
      2. Specify the “To Currency” for the exchange rate definition.
      3. Enter the “Exchange Rate” value.

      4. Click the “Accept” button at lower-right of the dialogue.

      Use the “Sample Conversion” section at lower-right of the page to test the conversion of any given value from one currency to another, based on the exchange rates currently displayed in the “Listing” grid.

      1. Click the “From Currency” drop-down list at upper-left of the section to specify the currency on which the conversion will be based.
      2. Click the “To Currency” drop-down list at upper-right of the section to specify the currency to which the specified value will be converted.
      3. Enter any value in the “Value” field.

      4. Click the “Convert” button at right of the “Value” field.

    9. Click the “Save” button at lower-right of the page.

    Exchange rate information can be loaded utilizing the secure FTP site process. See the “Transferring Load Files via Secure FTP” topic for details on using this method.

    • Be sure to select and upload the source data to the ExchangeRates for the type of source file you’re using in the FTP directory for your respective environment.
      FTP client (“ExchangeRates” load file drop folder)

    • The system automatically rejects any import that contains one or more records associated with a “Closed” account period.

    As an alternative to manually entering exchange rate information one record at a time via the associated application page, you can import multiple exchange rate records at once using an Excel (XLS) source file. Follow these steps to do so:

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Exchange Rates” item.

      “Exchange Rates” page

    3. Click the “Get import template” at lower-right of the pane where existing items are listed to retrieve an Excel import file template.
      “File Download” dialogue (Exchange Rates data import)
      1. Click the “Open” button to open the template within Microsoft Excel.
      2. Or, click the “Save” button, and then specify a local or network directory in which to store the template.
    4. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “ExchangeRateImport_20101231.xls”).
    5. Populate your new file with information for as many exchange rate records as you’d like to import, and then save it (see the “Exchange Rates Import File Structure” table for specifics).

    6. Click the “Import data” at lower-right of the pane where existing items are listed to import data contained in your Excel source file.
      “Exchange Rates” dialogue

      This button is disabled if “Average” is the specified exchange rate “Type”.

      1. Select your import file using the “Browse” at right of the “File” field.
        “Exchange Rates” dialogue (import file and options selection)

      2. Specify the you’d like to use.
        1. Click the “Time Zone” drop-down list below the “File” field to select the time zone with which the new exchange rate(s) will be associated.

        2. Specify whether only new records in your file should be imported to the database, or whether any records it has that match existing database records should also be imported.

          Existing records will be overwritten by those contained in your file if you choose the latter option!

      3. Click the “Preview” button at lower-right of the “Options” section.

      4. Click the “Accept” button at lower-right of the dialogue.

    You can go to the dataload “Archive” page at any time to see the result of the import process by clicking the corresponding “View Details” link.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Exchange Rates” item.

      “Exchange Rates” page
    3. Use the “Source” drop-down list at upper-left of the page to specify the exchange rate source with which the exchange rate is associated.
    4. Use the “Time Zone” drop-down list at upper-left of the page to specify the time zone with which the exchange rate is associated.
    5. Use the “Date/Time” drop-down list at upper-left of the page to specify the date and time with which the exchange rate is associated.
    6. Use the “Type” drop-down list at upper-left of the page to specify the type of the exchange rate (i.e., “Closed/Open” or “Average”).

    7. Click the “Search” button at right of the “Date/Time” field.

    8. Click the “Edit” at lower-left of the grid after selecting the record representing the desired set of currencies to view/edit its exchange rate.
      “Add/Edit Exchange Rate” dialogue
      1. Specify the “From Currency” for the exchange rate definition.
      2. Specify the “To Currency” for the exchange rate definition.
      3. Enter the “Exchange Rate” value.

      4. Click the “Accept” button at lower-right of the dialogue.

      Use the “Sample Conversion” at lower-right of the page to test the conversion of any given value from one currency to another, based on the exchange rates currently displayed in the “Listing” grid.
      1. Click the “From Currency” drop-down list at upper-left of the section to specify the currency on which the conversion will be based.
      2. Click the “To Currency” drop-down list at upper-right of the section to specify the currency to which the specified value will be converted.
      3. Enter any value in the “Value” field.

      4. Click the “Convert” button at right of the “Value” field.

    9. Click the “Save” button at lower-right of the page if any updates were made.

    A listing of records, with certain associated information, can be exported from the application database to any of several different file formats (DOC, HTM, XML, etc.). Follow the steps below to perform a data export.

    1. Click the “Export data” at lower-right of the pane where existing items are listed to export data from the grid.

      1. Select the next to the file format to which you’d like the data saved.

        •  .XML

        •  .DOC

        •  .CSV

        •  .HTM

        •  .TXT

      2. Click the “Accept” button at lower-right of the dialogue.

        1. Specify a local or network directory in which to store the file, and provide a “File name”.
        2. Click the “Save” button.

    This button is disabled if “Average” is the specified exchange rate “Type”.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Exchange Rate Sources” item.

      “Exchange Rate Sources” page

    3. Click the “Add” button at lower-right of the page.

    4. Enter a “Name”, “Code” and “Description” for the new exchange rate source, either in the cells of the new row at left of the page, or in the fields of the “Detail” pane at right.

    5. Click the “Save” button at lower-right of the page.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Exchange Rate Sources” item.

      “Exchange Rate Sources” page
    3. Select the desired exchange rate source from the “Listing” pane at left of the page.

    4. Review and edit information for the item in the “Detail” pane at right of the page, or directly in the cells of the “Listing” pane at left of the page.

    5. Click the “Save” button at lower-right of the page if any updates were made.

    A listing of records, with certain associated information, can be exported from the application database to any of several different file formats (DOC, HTM, XML, etc.). Follow the steps below to perform a data export.

    1. Click the “Export data” at lower-right of the pane where existing items are listed to export data from the grid.

      1. Select the next to the file format to which you’d like the data saved.

        •  .XML

        •  .DOC

        •  .CSV

        •  .HTM

        •  .TXT

      2. Click the “Accept” button at lower-right of the dialogue.

        1. Specify a local or network directory in which to store the file, and provide a “File name”.
        2. Click the “Save” button.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Currencies” item.

      “Currencies” page

    3. Click the “Add” button at lower-right of the page.

    4. Enter a “Currency Code”, “Symbol” and “Description” for the new currency, either in the cells of the new row at left of the page, or in the fields of the “Detail” pane at right.

    5. Click the “Save” button at lower-right of the page.

    As an alternative to manually entering currency information one record at a time via the associated application page, you can import multiple currency records at once using an Excel (XLS) source file. Follow these steps to do so:

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Currencies” item.

      “Currencies” page

    3. Click the “Get import template” at lower-right of the pane where existing items are listed to retrieve an Excel import file template.
      “File Download” dialogue (Currencies data import)
      1. Click the “Open” button to open the template within Microsoft Excel.
      2. Or, click the “Save” button, and then specify a local or network directory in which to store the template.
    4. Use Excel’s “Save As...” command to create your data import file, giving it a unique and meaningful name (e.g., “CurrencyImport_20101231.xls”).
    5. Populate your new file with information for as many currency records as you’d like to import, and then save it (see the “Currencies Import File Structure” table for specifics).

    6. Click the “Import data” at lower-right of the pane where existing items are listed to import data contained in your Excel source file.
      “Currencies Import” dialogue

      1. Select your import file using the “Browse” at right of the “File” field.
        “Currencies Import” dialogue (import file and options selection)

      2. Specify the you’d like to use.

        1. Specify whether only new records in your file should be imported to the database, or whether any records it has that match existing database records should also be imported.

          Existing records will be overwritten by those contained in your file if you choose the latter option!

      3. Click the “Preview” button at lower-right of the “Options” section.

      4. Click the “Accept” button at lower-right of the dialogue.

    1. Expand the Environment Administration “Settings” .

      1. Click the “Home” button at the top of the application window to return to the landing page.

      2. Select “Environment Administration” from the .
        Landing page, “Environment Administration” selection

      3. Click the “Settings” menu to view available items.

    2. Click the “Currencies” item.

      “Currencies” page

    3. Select the desired item from the “Listing” pane at left of the page.

    4. Review and edit information for the item in the “Detail” pane at right of the page, or directly in the cells of the “Listing” pane at left of the page.

    5. Click the “Save” button at lower-right of the page if any updates were made.

    A listing of records, with certain associated information, can be exported from the application database to any of several different file formats (DOC, HTM, XML, etc.). Follow the steps below to perform a data export.

    1. Click the “Export data” at lower-right of the pane where existing items are listed to export data from the grid.

      1. Select the next to the file format to which you’d like the data saved.

        •  .XML

        •  .DOC

        •  .CSV

        •  .HTM

        •  .TXT

      2. Click the “Accept” button at lower-right of the dialogue.

        1. Specify a local or network directory in which to store the file, and provide a “File name”.
        2. Click the “Save” button.