2652 rfsa

[edit] Info

0002652: (Acc Misc) Adding a history or date range to exchange rates

Right now CT is setup to add current exchange rates only. Once a new exchange rate is entered it creates a history of the old or previous exchange rate, but it does not show the date range the old exchange rate was valid for. It only indicates the date the exchange rate was entered or updated. It is now required that operators have the ability to add old exchange rates for a specified date range.

[edit] Example

For the end of August no one entered exchange rates in NY. Now when operators require the exchange rates for this time frame, they have no way of getting this information. So MO would like to be able to go in and enter these missing exchange rates. In order for her to be able to do this she will need an option to enter a valid date range. Note: It should not be required to enter a date range.

Example

Updating the exchange rate from AUD to CHR for August 24, 2010 to August 30, 2010. Design suggestion

[edit] Business requirements

The system should be able show the date range in the Exchange rate history tab.

It should show the start date and end date of the exchange rate.

For any exchange rates that a date range is not entered or for exchange rates that are already in the system:

• The date the exchange rate is or was entered should be the end date for the current exchange rate. The start date should be the following day or day after this is updated.

Also, if the operator goes in to edit an exchange rate and hits the save button it should follow the same rule, even if no change is made to the actual exchange rate. They intend to update the exchange rates weekly and they want it to show as updated once saved even if it has not changed from the previous rate. Right now if no change is made to the exchange rate, it does not note the update in the system.

Example

Week 1 the exchange rate from Eur to USD is 0.58 and Week 2 the exchange rate is the same, it should show.

Week 1

Curr from EUR Curr To USD valid from 02-Jan-2011 valid to 08-Jan-2011 new rate 0.58

Week 2

Curr from Eur Curr To USD valid from 09-Jan-2011 valid to 15-Jan-2011 new rate 0.58

It is not longer required to show the time of the update, just the date.

Note - In order to make room for two extra columns, you can abbreviate Currency to Curr. Also MO has requested, the currency abbreviation (USD) in these columns be centered to make it easier to read.

[edit] Example

Example / design suggestion for history tab view