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
---------------------------------------------------------------------
