After upgrading to 2010 R4 I ran a net worth report yesterday and found that the numbers went totally haywire. Most of the accounts went to zero and others like my house value went to the original purchase price. This report was a saved report which I also had a print out from Christmas week when I was running 2009 R7. My immediate reaction was to think that 2010 has a limited number of accounts that can be included in the report. Thus I deleted a large chunk of reports and found the report came out clean. Eventually I isolated the problem to a single account. Which by the way did not appear on the 2009 R7 report as it was a CD that was opened on 12/29/09. The transactions I found were:
1) Date - 1/6/2010 Payee - Opening Balance Category - [account name] Amount 0.00 2) Date - 12/29/2009 Payee - Savings Category - [xxx Checking] Amount - $xxxxWhat I had done was wait several days (1/6) and created the account via "new Account" and download from the FI.
The net worth was a monthly for Last Year
When I edited the first entry to change the date from 1/6/10 to 12/29/09 the problem went away and all is working correctly.
My questions are:
1) what is the purpose of the first entry? In the past when I noticed if, I have considered deleting it. 2) am I correct in assuming that when the date on the opening balance is after the funding transfer that I should change the date.Art