[Last Call] Learn how to a build a cloud-first strategyRegister Now


Modify Dynamics GP table

Posted on 2011-04-19
Medium Priority
Last Modified: 2012-05-11
I have added a column to a table of an add-in application for Microsoft Dynamics GP 10.0, however when I go to Report Writer I am not seeing the new field in the table. I have updated GP and the dictionary.

Can anyone help?
Question by:gmollineau
  • 3
  • 2
LVL 18

Expert Comment

by:Steve Endow
ID: 35430350

Just to confirm, you have manually added a field to a database table for a Dynamics GP third party module?

You shouldn't modify any Dynamics GP tables, or the tables of any third party GP modules .  Consider those sacred, and just don't even think about modifying them.  The field you manually added to the SQL table will not show up in Report Writer because it isn't defined in GP--report writer is not like Crystal Reports--it does not dynamically scan the database tables to check for new fields.

And there are alot of possible problems with modifying the table, the least of which is that the field can be deleted or cause a failure during a patch / service pack install, or an upgrade.

If you need to store or track additional information, there are several supported options, such as:

1) Use a user-defined field, comment field, note field, etc.  The benefit of this approach is that the field should be available in Report Writer and SmartLists, but unfortunately, not many windows have these spare fields available.

2) Use Extender to add additional windows / fields.  This is easy to do, but not necessarily easy to add the fields to an existing report or SmartList.

3) Create a custom table and use Modifier & VBA to read from and write to the table from GP windows.  This offers alot of flexibility, but requires knowledge of Modifier & VBA, and requires VBA in Report Writer to add the custom fields.

4) Use Dexterity to modify the base window to read/write to a custom table.  Similar pros and cons as Modifier & VBA.

Let me know if this makes sense.


Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
LVL 10

Expert Comment

ID: 35430572
As Sendow said, DO NOT do it. But if you're practicing or testing, or you know what you're doing, here's how to do it:

1- Add the field in Dexterity.
2- Drop and recreate the table from the SQL Maintenance window.

Author Comment

ID: 35433598
Let me clarify.

We did not touch the GP tables.

It is an Add-in appliucation that we deveoped in house, and got a registration number, etc from Microsoft.
The application works fine. However we had to create a new column in one of the tables of this Add-in so that we could establish a relationship between two tables in order to have data from a table printed on a report.

We added the column to the table, it is in SQL, and other sreas. The forms are updating it, but in the Report Writer the new field is not listed under the table.
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

LVL 10

Expert Comment

ID: 35438643
What is the add-in based on? Dexterity, VS, VBA, Continume?

Author Comment

ID: 35440119

Sorry I did not put that info.

The Add-in is based on Dexterity.

LVL 10

Accepted Solution

Abdulmalek_Hamsho earned 2000 total points
ID: 35440307
Well, then do the following:

1- Open the Add-in dictionary file in Dexterity and add the field to the table.
2- Go to SQL Maintenance window and drop that table and re-create it.
3- Done.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question