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
drivingforceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
drivingforceAuthor Commented:
This is wonderful. More than I expected.
Thank you and have a nice weekend
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Tax / Financial Software

From novice to tech pro — start learning today.