Microsoft Business Solutions-Axapta 3.0 is now part of Microsoft Dynamics AX 3.0. All references to Microsoft Business Solutions-Axapta and Microsoft Axapta pertain to Microsoft Dynamics AX.
You try to open a Type A account view. The account view has a Column Set that has more than 18 columns, and the Line Set has more than one account. When you try to open this account view, a yellow warning triangle appears in the lower-left corner of the Microsoft Internet Explorer window, and the account view is not displayed. When you click the warning triangle to view more details, you receive the following error message:
Error: Syntax error
INSTALLATION: Single Tier or 2 Tier
To resolve this problem, obtain the latest service pack for Microsoft Business Solutions - Forecaster 6.7. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer:
This bug was corrected in Service Pack 4 of Microsoft Forecaster 6.7.
Steps to reproduce the behavior Create a version: Click Administration, and then start the Version Wizard. In the ID box, type 5B. In the Label box, type Benefits. Click Next. In the Year box, click 2005, and then click Next. Accept the default values for period 1 through period 12. Click Next. Click Finish. Create an Input Set that has 12 months: Click Administration, and then start the Input Set Wizard. In the Input Set ID box, type 5B13MNTH. Click Next. Select an existing Line Set. Create a new Column Set: Click New. Type a name for the Column Set, click to select the Input check box, and then click Next. Click Monthly Periods, and then click Next. In the Version box, click 5B. Add all the months from the left column to the right column. Click to select the Click to add total column check box, and then click Next. Accept the default in step 3b of the wizard, and then click Next. Click Finish, and then click Return to Input Set Wizard. Click Next. In the Version box, click 5B, and then click Next. Click Finish. Create a Line Set that has two accounts: Click Setup, and then start the Line Set Wizard. In the Line Set Name box, type Workcomp. Click to select the Account check box, and then click Next. Select two accounts, and then click Next. Click Finish. Modify the Column Set that you created in step 2 to add seven more columns. These columns can be calculated columns. Click Setup, and then open the Column Set worksheet. Select the Column Set. Click Insert, and then add seven columns. In the ID box, type an ID for the new columns. In the Label box, type a label for the new columns. Then, select X Calculated in the ColType column. Save the Column Set worksheet. Click Setup, and then start the Design Wizard. Type an ID and a description. Click Next. Click Standard View, and then click Next. Click Account Views, and then click Next. Select the Line Set and the Column Set that you created in steps 3 through 4, and then click Next. Accept the default values in step 4 of the wizard, and then click Next. Click Finish. Click Views, and then select the view that you created in step 5.
A yellow warning triangle appears in the lower-left corner of the Internet Explorer window, and the account view is not displayed.
You cannot make the account view appear, unless you use one of the following procedures:
You change the Line Set so that it includes only one account. You reduce the number of columns to 18 or fewer. You change the view to a Type P view.
Article ID: 902698 - Last Review: March 12, 2013 - Revision: 4.0
Applies to Microsoft Business Solutions for AnalyticsForecaster 6.7 Microsoft Dynamics GP 9.0 Microsoft Business Solutions–Great Plains 8.0 Microsoft Business Solutions–Great Plains 7.5 Microsoft Dynamics SL 6.5 Microsoft Business Solutions–Solomon 6.0 Microsoft Dynamics AX 3.0, when used with: Microsoft Business Solutions for AnalyticsForecaster 6.7
kbsolomonfrx kbgreatplainsfrx kbaxaptafrx kbmbsmigrate kbbug KB902698
Contact us for more help
Connect with Answer Desk for expert help.