bank reconciliation in foreign currency

navdev3
navdev3 Member Posts: 32
I am convinced that I am missing something. What is the procedure for reconciling a bank that is in a foreign currency?

I have read somewhere that we should run the adjust exchange rate batch job after entering an exchange rate, before doing the bank rec. I have done so and found postings in the realized/unrealized loss/gain GL accounts. However, it doesn't have an impact on any of the numbers on my bank rec form at all.

I have a bank rec that was balanced. A new exchange rate was entered and I can no longer get it balanced. I can see that the GL ($) balance is converted to GL balance using the most recent exchange rate. However, a number of the checks and deposits listed were entered before the exchange rate change and therefore they were posted to the GL with a different amount than what we are calculating now. I can explain the numbers (mostly) but I cannot find the Navision published procedure for handling bank reconciliations for foreign currency. I don't want to just assume that the remaining difference is due to the exchange.