The Year and the Period list options are blank when you try to create a Distribution Query or a Multilevel Query in Analytical Accounting in Microsoft Dynamics GP


Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Symptoms


When you try to create a Distribution Query or a Multilevel Query in Analytical Accounting in Microsoft Dynamics GP and Microsoft Business Solutions - Great Plains 8.0, the drop-down lists for the Year: and the Period: are blank in the Distribution Query Wizard-Finish window or the Multilevel Query Wizard-Finish window.

Cause


This problem occurs if the reporting periods are not populated in Analytical Accounting. The AAG00500 table stores the calendar information or reporting periods for Analytical Accounting and this table is blank.

Resolution


To resolve this problem, populate the AAG00500 table. The Analytical Accounting reporting periods are built from the company Fiscal Periods Setup window. A trigger exists in the SY40101 table in the company database that will prompt an insert statement to the AAG00500 table when you calculate the company Fiscal Period Setup window.



To populate the AAG00500 table, follow these steps:
  1. Follow the appropriate step:
    • In Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Company, and then click Fiscal Periods.
    • In Microsoft Dynamics GP 9.0 and Microsoft Business Solutions – Great Plains 8.0, on the Tools menu, point to Setup, point to Company, and then click Fiscal Periods.
  2. Click Calculate, and then click OK.
  3. A message box will appear that says "All years will be created again. This may take some time." Click OK.
  4. Another message box will appear that says "These changes will cause period balances to be incorrect. You will have to reconcile the General Ldeger, Payables Management and Receivables Management Modules." Click OK.
  5. The reporting periods or AAG00500 table in Analytical Accounting will now be populated and so the Year and Period list options will now be available in the Multilevel and Distribution queries..

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

References