Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Creating new custom fields and entity in GP 2010

Posted on by 600

Hello Everyone,

Please help me how to create a new entity as well as new custom fields in GP 2010 version.

Any help will be appreciated…

Regards,

Priya.

*This post is locked for comments

  • soma Profile Picture
    soma 24,406 on at
    RE: Creating new custom fields and entity in GP 2010

    Are you independently open GP? or Open from dexterity Test Mode?

  • Sathish Sivakumar Profile Picture
    Sathish Sivakumar 3,732 on at
    RE: Creating new custom fields and entity in GP 2010

    Hi Soma,

    I am following the steps which you gave. Thanks a lot Soma.

    But I am facing some problem,

    Once I finished creating the table in Dexterity. In debug I select "Test Mode". It shows like this

    4188.image-_2800_2_2900_.jpg

    After that I pressed "Yes". But I couldn't find any screen on it. So I opened the dynamics GP and ran as "SA" user.

    In product field I couldn't find the "Dynamics.dic" option there and also I cannot see the table which I created. I had attached the screenshot also

    Is there any error on it or I am going on wrong way?

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Creating new custom fields and entity in GP 2010

    After created the table in dexterity, you need create the tables in SQL via GP. Go to the Test mode from dexterity(Debug-->Test Mode) or click ctl+T from your development.

    1. Login  in to GP with sa user id.

    2. In GP, go to SQL maintenance window(MS Dynamics GP/Dynamics.dic-->Maintenance-->SQL).

    3. From this window, choose the company database(as below) if the table series is not "System" otherwise choose system database(Dynamics) and select table then mark all the Checkbox in the right side of the window. Click the process to complete the table creation.

    4. After completed the above steps you can view the table which you have created from above steps in SQL under database-->Tables.

    Hope this helps!!!

  • Sathish Sivakumar Profile Picture
    Sathish Sivakumar 3,732 on at
    RE: Creating new custom fields and entity in GP 2010

    Hi Soma,

    Where will the Physical Name (Table) is stored in the SQL database. Because I couldn't find it.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Creating new custom fields and entity in GP 2010

    Sathish,

    Follow below steps to create a custom fields and tables in dexterity.

    1. Open your Dynamics/Development dictionary in Dexterity and click "Open Resource Explorer" icon to open the resource explorer which is contains all the resource for the dictionary.

    2. Then select the "Fields" from left side pane and click the new button.

    8015.Dex4.png

    2. Now field definition window will open. In this window enter your custom field name, physicalname(Stored in SQL server) and datatype(Select default or click new to create custom datatype). 

    5734.Dex5.png

    3. In Left side, now go to Globals under Base and click the new button to view your custom field which created from above steps.Then click OK to add your custom field to globals.

    Note: You can add only the global fields to the tables. So, you can add you custom fields to global fields.

    8130.Dex6.png

    4. Now select tables and click new to open Table definition window and then create your custom tables with custom field.

    5381.Dex9.png

    Note:

    Table name: This is used for calling the table in dexterity coding.

    Display Name : This is name for displaying the tables.

    Physical Name: This is the name for creating table in SQL server.

    Series: Module Name

    Database Type: Always SQL for most of the tables.

    5. After inserted values to the table click the New icon under Keys section to add key fields to the tables.

    4336.dex10.png

    Note: For more details about adding fields and tables. Go to the Dexterity Manuals under your dexterity installation folder and find the QSTART.pdf file. This file contains more details about the tables and fields.

    Hope this helps!!!

  • Sathish Sivakumar Profile Picture
    Sathish Sivakumar 3,732 on at
    RE: Creating new custom fields and entity in GP 2010

    Hi Soma,

    Can you give me full step by step documentation for adding field in GP and also extending the object in web service using  visual studio. Because I'm new to Dynamics GP.

    Really thanks for your support in Great Plains.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Creating new custom fields and entity in GP 2010

    Sathish,

    You need to create a table in Dexterity. Otherwise you can't access any custom tables created by SQL in dexterity. So, follow my above suggestion mentioned to Priya. I have suggested to priya for creating custom fields and tables.

    If you need any help regarding the same don't hesitate to ask me.

    Hope this helps!!!

  • Sathish Sivakumar Profile Picture
    Sathish Sivakumar 3,732 on at
    RE: Creating new custom fields and entity in GP 2010

    Hi,

    For creating the new field in the Dynamics GP, where should I create a table? In SQL or Dexerity.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Creating new custom fields and entity in GP 2010

    Hi Sathish,

    Please open dexterity & point to dynamics dictionary.

    in forms section, type RM_Customer_Maintenance to open customer maintenance form

  • Suggested answer
    Sathish Sivakumar Profile Picture
    Sathish Sivakumar 3,732 on at
    RE: Creating new custom fields and entity in GP 2010

    Soma,

    Thanks a lot it's working for me.....

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans