Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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..

↑ Back to the top

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.

↑ Back to the top

References

↑ Back to the top

Keywords: kbexpertiseinter, kbmbsmigrate, kbexpertisebeginner, kbmbspartner, kbnoloc, kbprb, kbmbsquickpub, kb, kbtshoot, kbsurveynew, kbnomt

↑ Back to the top

Article Info
Article ID : 968055
Revision : 3
Created on : 3/30/2017
Published on : 3/30/2017
Exists online : False
Views : 70