Microsoft Dynamics GP (Archived)

Creating new custom fields and entity in GP 2010

(0) Share

Report

Posted on by Priya Swain

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

I have the same question (0)

All responses (18)

Answers (2)

Mike Smith 6,840 on at

Like (0)

Report

I prefer using a Dexterity developer for these types of scenarios.

Have you reached out to your GP partner for assistance on this?

Was this reply helpful? Yes No
Priya Swain 600 on at

Like (0)

Report

Hi Mike.

Thanks for your time...

I am new GP, using a trial version of GP 2010.

I have tried with Dexterity. But it is a bit of difficult for me to understand now...

Anyway I will try it again...

Is there any way to create custom fields and tables in GP trial version?

Waiting for your response...

Regards,

Priya.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Personnaly, I do all the code myself. There for, the learning curve for Dexterity was really high compare to simply add my developments which I do under Visual Studio.

Here is the link : msdn.microsoft.com/.../bb430822.aspx

There is also a product which can be embeded named "VS Tools menus for Dynamics GP" which will allow you to add options directly in GP menu.

For your question about files/fields, I never add fields directly in the Dynamics GP tables for ease of upgrade purpose. I create extensions tables starting with a "z", then the name of the table I need to extend (ex : zRM00101 for extra fields to customer card).

Then I use VS Tools for Dynamics GP to handle some Customer card's GP events, or simply create an extra window which I place under the Tools menu of that screen, or both, depending on my need (ex : defaulting values to the standard screen, or adding extra fields to the standard Dynamics GP).

Hope that helps !

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Hi,

I am also new to Dynamics GP. I couldn't find the forms which is present in the Dynamics GP using Dexterity. I am working on adding the new field (E-MAIL) in the CUSTOMER MAINTENANCE form. I had created the table in the database and given the foreign key relationship between "Customer Number". Can you guide me how to find the customer maintenance form in the Dexterity. If needed please give me some link to follow.

Thanks in advance.....

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

SATHISH ,

Follow below steps to find the Customer Maintenance form and add the fields whatever you wants in dexterity.

1. Open Dynamics Dictionary in Dexterity and click the "open resource explore window" icon.

2. In Resource Explorer window click "Forms" in left side pane.

3. Now you can see the form customer maintenance form(The technical name is RM_Customer_Maintenance) in right side pane.

4. Double click the RM_Customer_Maintenance form to open the form definition.

5. This form contains below windows. Choose the RM_Customer_Maintenance window and click open button.

6. In this window you can add global fields and fields from attached table for this window.

7. For adding table to this window, follow below steps

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

Priya,

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.

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

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.

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

Hope this helps!!!

Was this reply helpful? Yes No
Sathish Sivakumar 3,732 on at

Like (0)

Report

Soma,

Thanks for your reply. Where can I find the .DIC file?

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

Go to your GP installation folder(By Default C:\Program Files\Microsoft Dynamics\GP) and copy the Dynamics.Dic file. Then paste this file to any other locations and open the dic in Dexterity.

Note: Don't open the Dynamics.dic file directly from your GP installation folder.

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

Sathish Sivakumar 3,732 on at

Like (0)

Report

Soma,

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Sathish,

Please open dexterity & point to dynamics dictionary.

in forms section, type RM_Customer_Maintenance to open customer maintenance form

Was this reply helpful? Yes No