Walt,
Thanks for your thoughts. However, they WANT the data to be in two currencies. They
want to know how much person X paid in Canadian dollars, and how much person Y paid in
USD. IT's just that the conversion needs to happen later at some point if we want to
add those two payments together (which we do.)
Matthew
At 04:49 PM 9/20/01 -0400, you wrote:
>How about converting them before data entry. A small app that only allows
>entering a conversion factor (saved global) and a converted amount field
>that can be copied and pasted should do it. I have seen extensions that put
>a calendar icon next to a field and allow the user to click in the date.
>Money converters might be out there.
>
>> -----Original Message-----
>> From: Matthew Scholtz [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, September 20, 2001 3:53 PM
>> To: TechRocks Support
>> Subject: [support] Dual currency
>>
>>
>> Hello All,
>>
>> Anyone out there modified their Ebase to deal with dual currency?
>>
>> I've working with a group now that works across-the-border with
>> Canada and accepts both donations and program fees in USD and
>> CAD. No problem to mark the individual payments with the
>> appropriate currency. The trick is how to aggregate and do other
>> calculations when you have two different units. So I've put in a
>> changable exchange rate, and am planning on having Ebase convert
>> all amounts to USD before aggregating.
>>
>> I know how to do this, but wondering if anyone has traveled down
>> this path before. There seems to be a lot to change to make the
>> aggregation happen (find fields, reports, etc. etc. etc.) and
>> would be nice to not have to hunt them all down. Looking for
>> words of wisdom from veterans.
>>
>> Also: anyone run Analyzer or ClickStats on Ebase 102 or 103
>> lately and would be willing to send me a copy of the resulting
>> db? (contact me off-list if so)
>>
>> TIA much,
>> Matthew
>>
>>
>> Matthew Scholtz
>> Database and Non-Profit Technology Consultant
>> Bellingham, WA
>>
>> Also associated with NPower, Seattle
>> www.npower.org
>>
>> ------------------
>> Reminder to each recipient: To change your list account preferences, go to
>> http://email.sparklist.com/scripts/lyris.pl?enter=support and
>> enter the email address you used to subscribe to the ebase
>> support list:: [EMAIL PROTECTED]
>>
>> To unsubscribe send a blank email to [EMAIL PROTECTED]
>> ---------------------------------------------------------------------
>> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>> ---------------------------------------------------------------------
>>
>>
>
>
>------------------
>Reminder to each recipient: To change your list account preferences, go to
>http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email
>address you used to subscribe to the ebase support list:: [EMAIL PROTECTED]
>
>To unsubscribe send a blank email to [EMAIL PROTECTED]
>---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>---------------------------------------------------------------------
>
>
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
