HomeWikiFinancial Code TablesDaily Exchange Rate

11.3. Daily Exchange Rate

  • Exchange rates conversions can be captured daily.
  • When an exchange rate is required, the system first checks the Daily Exchange Rate table to confirm if an exchange rate is already available for the current date and the requested conversion. If there is no exchange rate, the system prompts the user to enter an exchange rate, once an exchange rate it entered it is stored on the Daily Exchange code table for future allocation.

    To Add a Record:

    Click the New button on the toolbar, the New button on the toolbar becomes impressed (to indicate you are in new-mode) and the cursor focus is placed on the first field in the edit area. Enter the respective information in the fields available in the edit area and click Save on the toolbar to add the new record to the list.

    Note: Use the TAB key and SHIFT+TAB to move the cursor between fields in the edit area.

    To Edit a Record:

    Select the record from the list (the record is populated in the edit area — the edit area is the area at the top of the form where new can be added or amended). When the record is populated in the edit area, click the Edit button on the toolbar. Edit the information as required and click Save on the toolbar to update the changes (the record is saved and returned to the list).

    Note: Use the TAB key and SHIFT+TAB to move the cursor between fields in the edit area.

    To Save a Record:

    After editing or creating a new record, click the Save button on the toolbar to save the changes. The record will be added to the list and the edit area will return to New mode for the next record to be created or you can select an existing record from the list for editing.

    To Delete a Record:

    Select the record from the list (the record becomes populated in the edit area), click the Edit button on the toolbar to access edit-mode. Click the Delete button on the toolbar to delete the record.

    Working with inactive records:

    If a deleted record has not been used within the system it will be permanently deleted. If the record has been used within the system before it is deleted, on deletion it will be flagged as 'inactive', this means it will remain visible on the code table for reporting and auditing purposes but will not be available in future selections within the system. An inactive record can be re-activated by changing the record status to active when in edit mode (the status option is only available once a record has been flagged 'inactive').

    Other Tips for working with Code Tables:

    Terms and Definitions

    Date The date for exchange rates
    Currency from The currency to be converted from. Records displayed here are linked to the Currency code table.
     Currency to The currency to be converted to. Records displayed here are linked to the Currency code table.
    Exchange rate applied The conversion to be applied. Only numeric values can be captured here (4 decimal places are allowed).

     

    This page was: Helpful | Not Helpful