Hi All,

I have an account in the GL where the source balance does not equal the home balance, but the account is in Canadian dollars - the home currency.

How could these two numbers ever have became different? It's not off by much, so i don't really feel like finding out where it went wrong (apparently it's been that way for a bit). How can i make the source and home balance match? It wouldn't let me do a currency reval for the home currency (which makes sense i guess) and the int check came up clean.

Thanks, and have a great weekend!

You indicated that the integrity check is clean. Likely this scenario is not checked for, as home currency accounts do not have currency records.

Normal processing should not have source and home currencies different for the home currency. I presume this is a balance sheet account, because income statement accounts would reset at year end. If the account does not have the MultiCurrency option selected, then this scenario is impossible - unless this account used to be a multicurrency account and was 'repaired' to not have this option.

If this account is a multicurrency account, there will be a multicurrency record for every supported currency for this account. The Net Changes for every fiscal period should match home and source.

If you wanted to search for the potential cause, and you have GridView and keep enough years of detailed history, you could create a View and filter for just that account and where the source and home currency amounts are not equal. If the detail still exists, you can find your answer.

It is a multicurrency account, and is a balance sheet account. There is CDN$ and US$ going into it. Unfortunately we do not have gridview, but i could dump all the transactions into excel via Crystal reports.

If I find the error in the current years data, that will be easy to fix with the toolkit (just change it and repost). But what if the entry is in a prior year?

Can I do a journal entry somehow to just write this amount off?