When you upgrade your Microsoft Business Solutions-Great Plains Dexterity-based application to version 8.0, there are several issues to consider beyond the standard upgrade process. This article contains tips and references for upgrading your Great Plains Dexterity-based application to Great Plains 8.0 Dexterity.

More Information

  • Great Plains 8.0 navigation changes include the removal of the Palettes navigation window and the removal of the fixed toolbar. These items have been replaced with menus, commands, lists, and toolbars that you can customize.

  • In prior versions, system series windows were hidden from the navigation model. The system series windows could not be added by the user to the Shortcuts toolbar or to the Palettes navigation window. In Great Plains 8.0, you can control whether a form can be added to the Shortcuts toolbar by adding the SHORTCUT constant as a form-level constant.

  • The AutoComplete feature is a new feature in Great Plains 8.0 Dexterity. To use the AutoComplete feature, you must set the field property of the AutoComplete feature to true. This property can be set for all string key fields that have lookup buttons.

  • Great Plains 8.0 Dexterity supports Microsoft Windows XP themes, and it rounds the corners of buttons. If your lookup window uses buttons in columns, you have to draw two-dimensional boxes around the buttons. You also have to change the Appearance property of the buttons to 3D Highlight. You may want to reduce the size of the buttons by one pixel in each direction so that the buttons fit perfectly in the boxes that you draw around them.

    Note Press CTRL + UP ARROW to increase the pixel size. Press CTRL + DOWN ARROW to decrease the pixel size.

  • The value of the SOP Type field in the tables no longer has a direct relationship to the SOP Type list in the windows. The value does not have a direct relationship because of the addition of the Fulfillment Orders document type when you are registered for Advanced Distribution.

  • Great Plains 8.0 examines the Microsoft SQL Server permissions of a user to decide whether the user can perform certain actions in the database such as creating tables or adding users. You can use two new Great Plains 8.0 Dexterity functions to verify that a user has the rights to perform an action.

    The following is the syUserIsDBO funtion.

    function returns boolean O_fIsUserDBO;
    in'User ID'I_sUserID;

    The following is the syUserInRole function.

    function returns boolean O_fUserInRole;
    in'User ID'I_sUserID;
    optional in 'Intercompany ID'I_sDatabase;

    In each function, the values for the I_sRole parameter can be any one of the following constants. You can use the following constants for fixed server roles:




    You can use the following constants for fixed database roles:





    The value for the I_sDatabase parameter can be any one of the following:

    • The company ID of the company master table for company databases

    • The company ID of global variables for the current company database

    • The name of the SQL Server system database


For additional information, see the following sections of the Great Plains Integration guide. The Integration guide is installed with Great Plains 8.0 Dexterity.

  • For additional information about the navigation changes in Great Plains 8.0, see Part 5,"Navigation" and Part 6, "Lists." Also, see the sample Develop.cnk file that is installed with Dexterity for a demonstration of the requirements.

  • For more information about how to add shortcuts by using form-level constants, see Chapter 24, "Shortcuts."

  • For more information about the AutoComplete feature, see Chapter 20, "Data entry conventions."

  • For more information about lookup buttons, see Chapter 16, "Lookups."

For additional information about how to develop for the new SOP Type fulfillment order, click the following article number to view the article in the Microsoft Knowledge Base:

886738 Three scripts that you can use to access the SOP Type field in the Sales Order Processing module by using Dexterity

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!