Microsoft Dynamics GP Year End Release 2015 Analytical Accounting

November 13 | By Tracey Brinkman

Tags: |

Microsoft Dynamics GP Year End Release 2015 Analytical Accounting

If you are using Analytical Accounting (AA) data you need to review this document: Microsoft Dynamics GP Year End Release 2015 Analytical Accounting before it is time to close your year. Give yourself time to review the Analytical Accounting data prior to running the Year-End close process for General ledger.

This will be an important step if your financial reports pull any data from AA tables.  Please review the information below to help the year-end process for AA be smooth:

  • There are no changes in the 2015 Year-End Update specifically for Analytical Accounting.
  • The Year-End close process for Analytical Accounting is automatically integrated with the Year-End close process for General Ledger.  So there are no ‘separate’ steps that you need to run in Analytical Accounting to close it.
  • If your Financial reports need to pull data from AA tables, (such as Management Reporter Data Mart),  be sure to give yourself plenty of time to go through all the information in this article before you close the GL year.
  • If the AA data does not match GL data, and financial reports are pulled from AA tables, this could skew your Financial reports (if your AA tables are not consistent with GL) and you won’t balance to the GL Trial Balance reports.   Missing or duplicated data in the AA tables would skew the beginning balance entries created in the AA tables.  So the first step is to determine if your Financial reports use the AA tables or not.   If you use AA tables or Management Reporter, it is recommended to run through KB 2910626 to help look for mismatched data between AA and GL that should be corrected before closing the GL year.
  • There could be many reasons why your AA data doesn’t match the GL data.  ALL transactions from other modules also update the AA tables, whether or not the GL accounts are linked to AA or whether or not you put AA codes on the transactions.  All transactions need to be present in the AA tables if you are doing your financial reporting from AA tables.   Discrepancies can occur if there are any posting interruptions, data is being imported, AA is not installed on all machines, GL was closed on a machine in the past where AA was not installed, users are disabling AA if any posting interruptions with AA messages, multi-currency issues, and many more reasons.  Therefore, you should be continually using the scripts in KB 2910626 to monitor if there are any ongoing issues in your environment to ensure the data between AA and GL stays in synch if you are doing any financial reporting from AA tables.

There is not a separate process to close AA. It is recommended that you review and follow these KB articles prior to closing the GL year.

  • Run through the steps in KB 960356 – The Year End Close procedures for Analytical Accounting in Microsoft Dynamics GP.
  • If you are using Management Reporter (MR) for your reporting, you should also run through KB 2910626 –Financial Reports from Management Reporter do not match the General Ledger Trial Balance Reports in Microsoft Dynamics GP.

 

Note:  If you have any of the scripts saved locally in the past from these KB articles, be sure to re-download the scripts again so you have the most up to date versions of these scripts.

The GL Year End close process will affect the following in the AA tables:

  • Moves AA data from open tables (AAG30000-AAG30003) to the history tables (AAG40000-AAG40003)
  • Creates Balance Brought Forward (BBF) entries in the AAG30000 series tables
  • Consolidates balances and ties AA codes to the BBF entries for the AA dimensions that were marked to be included in the year-end close

 

In order to have AA codes tied to your beginning balances created by the GL year-end close, you must first verify that the following options are selected:

  1. In the Analytical Accounting Options window (Click Tools under Microsoft Dynamics GP |Setup | Company | Analytical Accounting | Options), mark the checkbox for ‘Include dimensions in the year end close’ and click OK.
  2. In the Transaction Dimension Maintenance window (Click Cards | Financial | Analytical Accounting | Transaction Dimension), select the AA dimension code you want a balance carried forward for, and mark the checkbox for ‘Consolidate balances during Year End close’ and click Save.  Do this for each Transaction Dimension you wish to have linked to the beginning balance entries create by the GL year end close process.

 

If this is the first time you are closing GL on a version of GP 10.0 SP2 or higher (with AA activated), you will be prompted to move AA data to history before the system will allow you to close the GL year.  The system will verify that the AA data is in the corresponding open/historical series of AA tables, as the GL data sits in the open/historical tables in GL.

If you run into this, you will receive a message stating You must consolidate transactions and transfer detail to history utility to close the year” during the GL Year End close, and then you can refer to the steps in KB 960356 on how to resolve this.  You should not need to run the Move to History Utility for AA more than the initial first time.  The Move to History utility was meant to be a one-time process to get the customer ‘caught up’ with getting historical AA tables populated, and then data should automatically close along with the GL year-end close process going forward.

There are no new features for AA in these versions.  However, the GL Year-End Closing window now includes a Reverse Historical Year

Reverse Historical Year feature

button to reopen a GL year yourself.  If the beginning balances are incorrect in AA, or you find data discrepancies with data from your historical years with the scripts in KB 2910626, you can use this new feature in GL to reopen the year, fix the AA data, and then reclose the year again to have the BBF entries recalculated correctly in the AA tables. 

Key points to remember:

  • Follow the steps in KB 960356 titled “The Year-End close procedures for Analytical Accounting in Microsoft Dynamics GP”.  This KB includes steps and SQL scripts to make sure the AA data matches GL data.  It also has steps to verify that the AA dimensions that you wish to be consolidated during the year-end close process are properly marked to create BBF entries, and steps on how to move data to history.  You should determine if your reporting tool uses AA tables or not.  Data Mart with Management Reporter now reads from AA tables, so it is more important than ever to make sure your AA data matches GL data.
  • New to Microsoft Dynamics GP 2015, the user can determine the data that is available to the Microsoft Dynamics Management Reporter Data Mart to help improve the performance and give the user control over the data selected.  Note that the latest release of Data Mart (CU10) does have the option to report with or without AA data.
  • Make sure the GL year-end close is performed at a workstation that has AA installed and activated, and that users know not to disable AA if they receive any messages.  Restore to the backup immediately, and make a screenprint of the AA error message if assistance is needed with the GL year-end close process.

 

For assistance with year-end close issues directly related to Analytical Accounting use the following link:

Microsoft Dynamics Support – https://mbs.microsoft.com/support/newstart.aspx (You will be required to log onto your CustomerSource account).

Assistance with year-end close issues directly related to Analytical Accounting should be logged under the categories below to ensure you reach the correct Support team:  (Please include a detailed description of the issue and a screenprint of any error messages received.)

–Support Topic Selection:   Financial – Analytical Accounting

—Sub-topic Selection:         Other

Content for this blog from Microsoft Dynamics GP Community: Microsoft Dynamics GP Year-End Release 2015: Analytical Accounting by: Cheryl Waswick

You can view the original blog at: https://community.dynamics.com/gp/b/dynamicsgp/archive/2015/11/12/2015gpyecaa

If you are an iSolutions Partners customer and would like to schedule time for us to assist you with your year end. Or if have any questions regarding Microsoft Dynamics GP Year End Release 2015 Analytical Accounting or other Year end questions, please contact us at: support@iSolutionsPartners.com.

You can view our previous blogs at: http://www.isolutionspartners.com/resources/dynamics-gp-blog-for-indiana-and-wisconsin/