Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INTL and currency question
Message
De
02/09/2000 01:30:52
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
00411884
Message ID:
00412061
Vues:
14
Hi Chris,

I'm not sure the INTL toolkit has anything to do with this. What you have is a situation where you want to lock in the conversion rate with the transaction, and not have things reconverted each time you access them , right?

If this is the case, you have to pick a base currency, say USD, and the conversion rate. Convert *all* entries into USD and store that value, along with the conversion factor FROM the base currency to the transaction currency within the individual transaction and the currency type of the original transaction (if you're not doing so already).

If you do this, down the road you can report on the data any way you want because you have established a common basis for all financial data (USD) and the conversion rate is being fixed at the time of the transaction. So, God forbid, the English Pound collapses to $.10 but the 50 Pound transaction was when it was when 1 Pound = $1.50, then you'll "know" that the acutal value of the original transaction was $75 USD, and not $5.

Does this make sense?

>Not sure if this is an issue or not at this point but i thought i'd ask it anyway... and have not seen INTL but interested....
>
>How does INTL address currency changes over time or does it have just a single currency conversion value per currency? My concern is i dont want "cost" values in an "orders" database to change for historical information. If a customer paid 50 pounds for an item back in january and then, after making INTL currency setting changes later, how do i display the price they paid, not the latest "converted" amount?
>
>Suppose i ALREADY have the following orders entered:
>
>Item US $ Pounds OrderDate
>-------- ----- ------ ---------
>Heineken 24.00 24.48 Jan 1
>SamAdams 20.00 20.40 Aug 1
>
>Currencies (Jan-Aug):
>---------------------
>US : 1.00
>Pounds: 1.02
>
>Now, on Sept 1, i change the 'Pounds' exchange rate to 1.06:
>
>Currencies (Sept->):
>--------------------
>US : 1.00
>Pounds: 1.06
>
>If i then were to look at the 2nd order for SamAdams, would the price be 21.20 (the U.S. price times latest currency for Pounds)?
>
>Is this something my app has to address? Does INTL help? Offbase?
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform