The balances need to be updated in the AAA_99 set of data files.
1) Verify the option to calculate the balances is set. Select Investments (Accounts in 7.5) | Investment & Account Options. Verify that Calculate Balances for: [x] Investment Accounts is checked.2) Update the balances. Select Investments (Accounts in 7.5) | Enter Prices to Update Securities. Enter Dec 31 99 as the evaluation date. Select OK for the first security. Now the security will appear. The Dec 31 99 price should already be on the screen since the Security Portfolio Analysis report showed the correct price. If not enter the correct price per share. The new balance should already be 'Calculated'. If not then just cursor down to the next field to get the new 'Calculated' balance. Now just select Next (Page Down key) to go to the next security. Continue until the last security is updated.
(Note: Optional select Automatic to automatically go thru the securities that have already been priced.)
Now run the Balance Sheet report. The balances will be updated.
Now in the AAA_00 files, select Update Starting Balances to update to the Starting balances for 2000 to the ending balances for 99.
Notes:
Entering the price per share in the A/L info screen does NOT update the balances. This is done in the Enter Prices to Update Securities screen.
The Security Portfolio Analysis report showed the prices entered in the A/L screen. The Market Value for the report was calculated from the Price per Share times Number of Shares. When this amount is not equal to the Balance then an indication will appear in the next column. Either a "P" or a "B". The footnote says that "P" is "Price per share x Number of Shares " is used. The "B" is "Balance". So when this appear then the Balance does NOT equal the Price per share x Number of Shares.
This allows for people who want to keep the Balance Sheet at cost but obtain market value security reports.
Let me know if this does not explain the situation and the solution for you.
[This message has been edited by John (edited 09-12-2001).]