We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Modify Dynamics GP table

gmollineau
gmollineau asked
on
Medium Priority
584 Views
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?
Comment
Watch Question

Steve EndowMicrosoft MVP
CERTIFIED EXPERT

Commented:
Hi,

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.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
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

Commented:
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.
What is the add-in based on? Dexterity, VS, VBA, Continume?

Author

Commented:
Hi.

Sorry I did not put that info.

The Add-in is based on Dexterity.

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.