Microsoft Dynamics GP Year End Release 2011 – Analytical Accounting Year End Close

Closing the GL year when using Analytical Accounting (AA) is seamless.  This blog should give you an idea of what should happen when closing GL with Analytical Accounting.


Analytical Accounting is integrated with the GL closing process.  What this means is when you close your GL year, the AA data will move from the open tables (AAG30000-AAG30003) to the history tables (AAG40000-AAG40003).  In order to have the BBF entries created in the AA tables, you must verify that the following options are selected:

• Analytical Accounting Options window (Administration area page under Setup | Company | Analytical Accounting) – ‘Include dimensions in the year end close’
• Transaction Dimension Maintenance window (Financial area page under Cards | Analytical Accounting) – ‘Consolidate balances during year end close’


If you have not closed your GL year (with AA activated) after installing a service pack later than SP2 for version 10.0, you may receive a message stating "You must consolidate transactions and transfer detail to history utility to close the year".  There was code added to the closing process that will verify the historical years in Fiscal Period Setup and compare them to the years in the AA open tables.  If there is AA data in the AAG3000X series of tables for a historical year, you will receive the error. 

You will need to process the utility ‘Move Data to History’ on the Financial area page under Utilities | Analytical Accounting for all years that are historical.  When you open the Transfer Transaction Data to History window, the first year that needs to be moved will be populated.  You are not able to update the year.  There are 3 options available which are listed below with a description.

1. Transfer transaction detail to history – this will move the detail records from open to history and not include BBF data.  You must ensure there are no BBF entries in the AA tables otherwise you will not be able to select this option.
2. Consolidate transactions and transfer detail to history – this will move the detail records from open to history and create BBF entries.  However, you must have the options mentioned previously selected in order for BBF entries to be created.
3. Print transfer preview report only – this will allow you to view the transactions that will be moved without actually moving the data.


You should complete the documented steps for closing the GL year that can be found in KB888003 titled “Year-End Closing procedures for General Ledger in Microsoft Dynamics GP”.  You can then follow the steps in KB960356 titled “The year-end close procedures for Analytical Accounting in Microsoft Dynamics GP 10.0 Service Pack 2 and in later versions”.  There is not a separate year end close procedure for Analytical Accounting that needs to be completed, so the KB mentions the setup that should be completed if you want BBF entries created. 


Assistance for Analytical Accounting Year End Close
Microsoft Dynamics GP Blog -
Microsoft Dynamics Community -
Microsoft Dynamics Support -


Assistance with year-end close issues directly related to Analytical Accounting should be logged under Analytical Accounting instead of GL, otherwise the request could be routed to the incorrect team. 
--Support Topic Selection: Financial – Analytical Accounting
---Sub-topic Selection: Other

Please be sure to enter a detailed description of the issue you have or a screen print of the error received.


Year-end closing procedures for the Analytical Accounting module in Microsoft Dynamics GP;EN-US;960356

****New for the 2011 year, there is a Year-End Video!!!!****
Check it out....SO COOL!

Additional Content Provided by Sivakumar Venkataraman
Year End Close in Analytical Accounting

Year End Close Issue with AA – Workaround


Be sure to check back to the Year-End Schedule post for current posted blogs and upcoming blog posts related to Year-End Closing for Dynamics GP.


Good luck and have a great Year-End!
Christine G.

Comments (1)

  1. David Musgrave says:

    See the following post for a list of all the related Year End articles:…/2011-us-payroll-year-end-updates-for-gp-10-and-gp-2010-are-now-available.aspx

Skip to main content