If you want the correct Rate Date to show then you need to enter a rate for that date. The date you see is the matched rated date - even though you override the date.

so the process to enter a foreign currency receipt would be:

Common Services - Currency - Currency Rates - select correct table, enter rate

Accounts Receivable - A/R Transactions - A/R Receipt Batch - create new - enter details, Rate Override, enter rate type.

Repeat for each time a foreign currency receipt is received.

Seems a bit of a waste of time - I would have thought a Rate Override would do just that - allow you to override the default rate (which should include the date - or use the date from the receipt).  Why does it need to be entered into the Currency Rates first?  Especially since we don't actually need to keep track of these rates.

so the process to enter a foreign currency receipt would be:

Common Services - Currency - Currency Rates - select correct table, enter rate

Accounts Receivable - A/R Transactions - A/R Receipt Batch - create new - enter details, Rate Override, enter rate type.

Repeat for each time a foreign currency receipt is received.

Seems a bit of a waste of time - I would have thought a Rate Override would do just that - allow you to override the default rate (which should include the date - or use the date from the receipt).  Why does it need to be entered into the Currency Rates first?  Especially since we don't actually need to keep track of these rates.

Only if you insist on seeing the rate date = your receipt date. If you ignore the rate date (OCD?) then you can simply override the rate and be done with it.

Thanks - we have decided to delete all those rates out of the table (since we don't look at them anyway) and the date now shows correctly - it just looked like it had been done wrong if the date was wrong. We have three companies and it was correct in one - as there wasn't anything set up in that rate table.

Where can I find a manual for multicurrency - doesn't seem to be in our manuals. Interested in making sure our setup is correct - for tax, etc.

Thanks

Anna

Press F1 from the Sage 300 desktop, search for multicurrency.

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

Hi, just want to make sure - is it ok to use multicurrency but not have the information (rates) in currency table - so we we enter an invoice, purchase, receipt or payment for a transaction in a different currency, we need to manually enter the rate.

Thanks

Anna

Yes, but FWIW not a single one of my multicurrency clients does that.