[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 824
  • Last Modified:

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

Hi ...
I need to use the fields UserDef1, UserDef2 that appear in the Customer Master card in GP 10 (which are UserDef1, UserDef2 in RM00101) so that we can store relatively long strings.  These fields are defined to be CHAR (21) and I would like to modify that to CHAR (50).

Can I do that?  Is there anything that I should be aware off?

Thanks
0
drivingforce
Asked:
drivingforce
  • 3
  • 2
1 Solution
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
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


0
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
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



0
 
drivingforceAuthor Commented:
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.
0
 
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Hi,

Unfortunately I can't seem to find sample code that I have written for a custom field on a window.  I am pretty sure I have done it, but it's been a while.

Here are a series of articles by Mariano Gomez that will probably be more helpful than just a code sample.

http://dynamicsgpblogster.blogspot.com/2009/02/workshop-day-1-adding-custom-fields-and.html

http://dynamicsgpblogster.blogspot.com/2009/02/workshop-day-2-setting-up-vba-project.html

http://dynamicsgpblogster.blogspot.com/2009/02/workshop-day-3-adding-vba-code-to.html

He covers alot of topics in the three articles, so you don't necessarily need to learn everything.

In his example, he uses the DUOS tables to store custom fields.  I am personally not a fan of the DUOS concept, and prefer to use custom tables that are dedicated to the specific custom fields.  But you can review both options and see which makes sense for your requirements.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional



0
 
drivingforceAuthor Commented:
This is wonderful. More than I expected.
Thank you and have a nice weekend
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now