Thanks for all the replies which have confirmed my thoughts that it unfortunately isnt possible in Dynamics SL. It was living in hope I had missed something.
We will be using the following process (base currency NZD and supplier invoice is in AUD)
- enter AP Voucher in AUD - this will be converted using the current spot rate
- on payment enter a manual check against the AUD bank account using the actual exchange rate provided by the bank - this will calculate the realised exchange gain. To ensure this is the same we will be entering the manual check after the payment is made.
- as we only hold funds in NZD - create 2 cash transactions using a non-demoninated clearing account. One to transfer the money from NZD bank account to the clearing account and the other to transfer the money to the AUD bank account (using the actual exchange rate of the payment)
This means we can perform a bank reconcilation on the NZD bank account. The AUD bank acount and clearing accounts should both have a zero balance.
Currently our volume is relatively small but we may look to automate the cash account transaction generation through a customisation.
