Sam.Martin wrote:
My Company had used multiple currencies (CAD & USD) previously
and just moved the company with the CAD to a different
environment. I was not there during that time and am not aware
of the issues that could have driven them to move a company to
another environment to solve the issues.

Can anyone share with me their experiences, good or bad, with
using multiple currencies and the "Gotchas" that might have made
this endeavor fail?

FWiW: Is it possible there was\is a tendency to go outside of the application itself, to query the data in its databases directly; e.g. to produce summary reports? If so, that could be difficult without some well defined VIEWs to ease obtaining of /accurate/ information about currency values. For example: A simple query that sums a column which stores rows with multiple currencies, but which is defined with a primitive numeric data type, will give an obviously bogus answer. When assured all currencies are consistent [e.g. running two separate installations, each with its own currency], such an issue will not present itself in accessing the database of the application, outside of that application.

Regards, Chuck

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].