Exchange Rates
From UG
Contents |
Info
Business Needs and Requirements
Solution
See interface on Fig below.
Location: Acc > Currencies and Exchange Rates
Office specific or Global?
- These components (except Manage Currencies!) are office specific - see an "Office" dropdown
Currencies
Summary
Here is a table of currencies that can be used for calculations in the CT2. This table is shared by all Jaguar offices.
User Interface and Functionality
- See example on Figure 1
- Typical CT2 interface.
View All Table
- attributes listed:
- all, see Entities and Attributes
- sort by:
- name
- paging:
- none
Add
- Click "Add".
- Form in Pop-up will appear
- All fields are blank
Edit
- Select one item on the list and click "Edit"
- Form in Pop-up will appear.
Remove
- Select one item on the list and click "Remove"
- System presents message:
- "Are you sure you want to delete all selected Currencies? [Y, N]"
- If currency is already in use then System presents message:
- "You cannot delete this Currency as it is used in the system. [OK]"
Entities and Attributes
Currency entity has the following attributes:
- Abbreviation
- - meaning: currency code, this will show up on invoices, etc
- - format: 3 chars, caps, letters only
- - example: USD
- - unique
- Name
- - meaning: full currency name
- - format: 0 to 50 chars, mixed case
- - example: US Dollars
Special Cases and Misc
Look And Feel
Figures
Figure 1: Manage Currencies. View and Edit.
DB
Exchange Rates and View Exchange Rates
Summary
Exchange Rate is a number assigned to an ordered pair of currencies (Currency1, Currency2). Example: (USD, GBP, 0.63).
In finance, the exchange rates between two currencies specifies how much one currency is worth in terms of the other (wiki).
Each Jaguar Office has its own Exchange Rates.
User Interface and Functionality
CT2 User can view and edit the Exchange Rates on the separate tabs of Currencies And Exchange Rates Home:
- View - on View Exchange Rates tab
- Edit - on Exchange Rates tab
View
- For each currency X in the system displays all pairs (currency Y, exchange rate from X to Y ) for current office. See Figure 1
- columns:
- Currency From (X)
- Currency To (Y)
- Exchange Rate
Edit
- see Figure 2
- steps:
- select "Currency From:" from the dropdown list
- edit whole and decimal parts for required Currency To
- click "Save All Changes"
- (re)defining exchange rate from X to Y would automatically (re)define exchange rate from Y to X
- (In other words, if X is set then Y will be automatically re-calculated as Y=1/X. And vice versa).
Entities and Attributes
- Currency From
- available currencies in the system
- Currency To
- available currencies in the system
- whole part of exchange rate
- integer from 0 to 9999999
- decimal part of exchange rate
- integer from 0 to 99