Modify Dynamics GP table

Posted on 2011-04-19
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
    LVL 18

    Expert Comment

    by:Steve Endow

    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

    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

    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.
    LVL 10

    Expert Comment

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

    Author Comment


    Sorry I did not put that info.

    The Add-in is based on Dexterity.

    LVL 10

    Accepted Solution

    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

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
    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…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now