Does anyone have experience/suggestions for work-around processes to handle foreign currency? I have a US client who is using the following process for acceptance of Canadian checks & credit cards from their Canadian members/customers. The process is working fine for them, but is time-consuming, so I wondered if there are any alternative methods.

Canadian amounts are determined based on the exchange rate on the day of payment -- but all are entered into iMIS as US Dollars. A customer record with ID "EXCHG01" has been created in iMIS for recording the gain or loss on the exchange rate.