How to key Beginning Balances for Dimension Codes in Analytical Accounting for Microsoft Dynamics GP
This article explains how to change or offset the beginning balance for Analytical Accounting codes in Microsoft Dynamics GP.
Applies to: Microsoft Dynamics GP
Original KB number: 2966091
As of Microsoft Dynamics GP 10.0 SP2, you have the option to consolidate balances for AA dimension codes in Analytical Accounting. Basically when the GL year-end close process is performed for General Ledger, the same journal entry is posted to the Analytical Accounting tables, and AA dimension codes are tied to this journal entry to roll the balance forward for the AA dimension codes at the same time.
However, there are times that you may want to enter new beginning balances, edit beginning balances, or offset existing balances for the AA dimension codes.
Edit Analysis only allows you to change AA dimension codes on current year transactions. You aren't able to change AA codes on historical year transactions. This is by design.
To change beginning balances for AA codes, consider the following options:
Option 1 - Reopen GL year and edit AA codes on transactions from prior year
Since Edit Analysis only allows you to change AA codes on current year transactions, you can reopen the GL year, which will automatically move the corresponding transactions in the AA tables at the same time. You can then use Edit Analysis to add/delete/edit the AA codes on transactions in any transactions in an open year status. When finished, you can reclose the GL year again to have the balances consolidated and carried forward to the next year.
To edit transactions in an open year status, follow these steps:
Reopen the GL year(s) using one of these methods: (that is, move data from the historical GL/AA tables back to the open GL/AA tables)
- For Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 2010, and Microsoft Dynamics GP 2013 SP2 and prior (12.00.1570 and prior versions), you will need to open an advisory service to have a Microsoft Support Engineer reopen the GL year for you via SQL scripting.
- For Microsoft Dynamics GP 2013 R2 (12.00.1745) and higher versions, new functionality is available to reopen the year(s) yourself. To do this, select Tools under Microsoft Dynamics GP, point to Routines, point to Financial and select Year-End Closing. In the Year-End Closing window, select the Reverse Historical Year button, the latest historical year will be listed and select Process. You must reopen the years back to the year that you need.
Once the year is in open status, select Transactions, point to Financial, point to Analytical Accounting, and select Edit Analysis.
Enter the respective open Year for the journal entry.
Select the Journal Entry number to edit.
Use the Look Up button next to the Distribution line number to edit.
Edit the Analytical Accounting codes as needed. You can add/edit/remove AA information on transactions.
Once the AA codes are edited as needed, reclose the GL year to have the data move back to history again and roll the balances forward. (See The Year-end close procedures for Analytical Accounting in Microsoft Dynamics GP for more information how to mark the dimension codes to be consolidated during the year-end process.)
Option 2 - Key Offsetting journal entry to affect the balance brought forward for the AA dimension
If you do not have transactional detail, or you simply need to offset the current balance, you can key an offsetting journal entry as follows:
Select Transactions, point to Financial and select General.
Enter a general journal entry that will debit and credit the same GL account, so these entries offset each other in General Ledger.
Enter the AA codes to the respective debit or credit as needed.
You can date the journal entry to be the last day of the last closed year. (If you use the last day of the prior year, the system will let you post to the most recent historical year, and it will roll that balance forward for the AA code, but you will not be able to make any changes to the AA data once it is posted. Or you can choose to use the first day of the new year or any date in the new year, but then it will be a part of a period balance and you will need to remember that for reporting purposes. However, since it's an open year, you can continue to edit the AA data on it until the year is closed.)
Verify the balance for the AA code is now correct.
The debit and credit will offset each other in reporting, but the AA data is only tied to one side which provides the AA code balance. The distribution record is needed in the AA and GL tables, so that the AA codes have a header record and supporting transaction for it, but yet offset the GL account at the same time. Any recent SQL scripts (fix scripts for Financial Reports from Management Reporter do not match the General Ledger Trial Balance Reports in Microsoft Dynamics GP) or check links for AA will require a supporting transaction in both AA and GL, or else these processes will remove the AA data completely.