Transaction dimensions and transaction dimension codes do not display in the Transaction Dimension lookup window 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.
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

Symptoms


When you click the Trx Dimension lookup button in the Account Access to Transaction Dimension Codes window in Microsoft Dynamics GP and Microsoft Business Solutions – Great Plains 8.0, transaction dimensions and transaction dimension codes do not display.

Resolution


To resolve this problem, follow these steps:

  1. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

    Method 1: For SQL Server Desktop Engine

    If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

    Method 2: For SQL Server 2000

    If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    Method 3: For SQL Server 2005

    If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
  2. Run the following statement against the company database to see if any dimension IDs are linked to the Accounting Class:
    select * from AAG00202 a join AAG00400 b on a.aaTrxDimID = b.aaTrxDimID
    If results are returned, dimensions codes are linked to the class ID. Dimension codes must be linked to a Class ID for transaction dimensions and transaction dimension codes to display in the Transaction Dimension lookup window.
  3. If no results were returned in step 2, then link the dimension codes to the Class ID in the Accounting Class Link window. To open the Accounting Class Link window, on the Cards menu, point to Financial, point to Analytical Accounting, and then click Accounting Class Link. Select a Class ID and mark to link the accounts as appropriate.
  4. In the Accounting Class Maintenance window, select an Analysis Type for each Trx Dimension linked to the Class ID. This window is on the Cards menu, point to Financial, point to Analytical Accounting, and then click Accounting Class. Click to select one of the following options for the Analysis Type field:
    • Required
    • Optional
    • Fixed
  5. Click Save.

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.