Dynamics GP 10: Modifying the length of UserDef1, UserDef2 in RM00101

Hi,

Unfortunately it isn't that easy.  You can change the field length in the RM00101 table, but the Dynamics GP application won't recognize the new field length, since it's field objects store the field length.  It will still truncate the field at 20 characters when it displays the data, and the GP form will also not save properly if the field length is modified in the database.

If you need to store longer data values, four options come to mind.

1) Use the record note on the customer.  Alot of capacity, but difficult to query.

2) Use Extender to add additional fields to the window.  Extender offers alot of flexibility, but requires an additional window to be opened, so it is not as convenient for manual data entry.  And querying the data can be tricky depending on how you need to query it (SmartLists can be created that include Extender data).

3) Add custom fields to the Customer Maintenance form using Modifier & VBA.  This requires a custom database table to store the custom fields, and will require VBA code to save and query the fields on the window.  And the custom fields would require custom queries, SmartLists, or reports to be developed.

4) Develop a Dexterity customization to create a new, alternate version of the Customer Maintenance window that has larger field lengths or additional custom fields.  I believe that reporting might also be a challenge with this solution.


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

Hi,

One option that I didn't mention, since I assume you already considered it is to try using the Comment 1 and Comment 2 fields, since those are each 30 characters.  Obviously they won't work if you are already using them for other purposes, and won't work if you need to store more than 30 characters, but just wanted to throw it out there.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

I thought so!
I really like you third suggestion. Do you know of a good link where I can get a functional example of this?  ie the VB code that needs to be run when the window opens (query the data?).

Thanks in advance.

This is wonderful. More than I expected.
Thank you and have a nice weekend