2652 rfsa

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.

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

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 start date and the date the next or new exchange rates is entered or updated should be the end date.

• For these shipments the end date for the old rate will be the same as the start date for the new rate.

Also, if the operator goes in to edit and exchange rate and hits the save button it should follow the same rule, even if no change it made to the exchange rate. The intend to update the exchange rates weekly and they want it to show as updated even if it has not been changed. 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 01-Jan-2011 valid to 08-Jan-2011 new rate 0.58

Week 2

Curr from Eur Curr To USD valid from 08-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 shorten Currency to Curr. Also MO has requested, the currency abbreviation (USD) in these columns be centered to make it easier to read.

Example

Example / design suggestion for history tab view