The beginning balance -- One sided entry KB 865712

SYMPTOMS
The beginning balance for the current year does not balance in the general ledger in Microsoft Dynamics GP or in Microsoft Business Solutions - Great Plains.

CAUSE
This problem may occur if the ending balance for the previous year does not balance.

RESOLUTION
To resolve this problem, follow these steps.

#1 make sure that you have a complete backup copy of the database that you can restore if a problem occurs. Additionally, make sure that all other users exit the company
#2 Open the Fiscal Periods Setup window.
#3 In the Fiscal Periods Setup window, open a period in the previous fiscal year, and then click OK.
#4 In the General Ledger Setup window, click to select the Posting to History check box. To do this, use the appropriate step:
In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Financial, and then click General Ledger.
In Microsoft Dynamics GP 9.0 or in earlier versions, point to Setup on the Tools menu, point to Financial, and then click General Ledger.
In the Maintain History area, click to clear the Accounts check box.
Click to clear the Transactions check box.
#5 Open the Multicurrency Setup window. In the Maintain History area, click to clear the General Ledger Account check box.
#6 Open the Account Maintenance window.Create a dummy account number in the Account Maintenance window. For example, type 999-999-99 in the Account box.
In the Posting Type area, click Balance Sheet. This step makes sure that the Retained Earnings account will not be updated when you close the year.
In the Category list, click Nonfinancial Accounts. This step makes sure that the account will not be included in the financial statements. The Nonfinancial Accounts category will keep this account off the Quick Financial statements. However, the account will appear in other General Ledger reports. Therefore, we recommend that you use a number sequence such as 9999-999-99 for the dummy account number so that you can exclude this account from most statements.
Click Save.
#7 On the Transactions menu, point to Financial, and then click General.
Enter a transaction, and then post the transaction to the account that is out of balance and to the dummy account that you created in step 9.
In the Transaction Date field, type a date for the transaction that is in the historical year.
Use the appropriate step:
If you use Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
If you use SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
If you use SQL Server Desktop Engine (also known as MSDE 2000), start Support Administrator Console. To do this, click Start, point to Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.
Run the following statement against the company database.
select ACTINDX from GL00100 where ACTNUMBR_1 = XXX
Notes
The XXX placeholder represents the first three numbers of the account that you created in step 9.
Make sure that the account that you created in step 9 is the only account that is returned when you run this query.
To delete the transaction from the history, run the following statement against the company database.
delete GL20000 where ACTINDX = XXX
Note The XXX placeholder is the number that is returned from the query that you run in step 17.
To clear the balance information on the dummy account, you must run the Reconcile utility on the oldest open year. To do this, use one of the following methods:
In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Utilities, point to Financial, and then click Reconcile.
In Microsoft Dynamics GP 9.0 or in earlier versions of Microsoft Dynamics GP, point to Utilities on the Tools menu, point to Financial, and then click Reconcile.
The transaction is now a one-sided transaction, and the balance should be correct.

To delete the dummy account, follow these steps:
On the Cards menu, point to Financial, and then click Account.
In the Account field, type the dummy account number.
Click Delete.
If you want to maintain history, follow these steps:
In the Maintain History area in the General Ledger Setup window, click to select the Accounts check box, and then click to select the Transactions check box.
In the Maintain History area in the Multicurrency Setup window, click to select the Accounts check box, and then click to select the Transactions check box.