Multicurrency - receipt rate override

SOLVED

Hi

First up, anyone know where I can get a copy of the manuals for multicurrency?  We are using v5.6a.

I am trying to work out how the rate override works in AR receipts.  We enter the invoice (using an average rate), and then when we receive the money into our bank account, we enter it using the rate from the bank on the day.  We go into the Rate Override screen and the in the Customer Rate section we enter the rate type (BK for bank), the date the money was received and then rate used, which then calculates the customer amount.

The issue is that the date reverts to the last one saved in the currency table for rate type BK.  And this can be 2 or 3 years ago.  The rate we enter saves - so the amount is correct, but when we look back at the transaction it looks like we have used the incorrect rate.

We don't want to have to maintain all the bank rates used, as it would mean we have to enter the rates into the currency tables before we enter the receipt (I can't see a way of doing this at the time of entering the receipt).

Can we just enter the rates in the Rate Override screen? How do we get the date to show correctly?

Cheers

Anna

Parents Reply Children
  • 0 in reply to Jay Converse Acumen

    Thanks Jay - that gave me some info.

    I am trying to check that our setup is correct (and it varies throughout our 3 companies).

    So trying to understand the relationship between things - ie we only report to one tax agency (in our functional currency) but when I set up the customer group for a customer in another currency, it warns me that the Reporting Currency doesn't match the Source Currency - should I be adding a tax group or not?

    This is just one example - is there anything that explains why, when and how things should be set up?  This was originally set up by our consultants and it appears to be inconsistent between companies and currencies (not sure they totally understood it) - but we have had a few issues with things looking weird, so want to get it correct.

    Thanks

    Anna