Modify Dynamics GP table

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.

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?

Hi.

Sorry I did not put that info.

The Add-in is based on Dexterity.