×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Adding new fields to GP window and storing it onto the database
2

Adding new fields to GP window and storing it onto the database

Adding new fields to GP window and storing it onto the database

(OP)
Hi,

I am quite new to this Great Plains software. We added few new fields to an already existing database table. I need to add these new fields to the GP window and the user keys in the data and the whole record needs to be stored in the respective database table. Please let me know how to accomplish this. Any help would be appreciated. Thanks!!

Regards,
sslab

RE: Adding new fields to GP window and storing it onto the database

You will need to use VBA or Dexterity.  

RE: Adding new fields to GP window and storing it onto the database

Search for help on the DUOS (Dynamics User Object Store).

Good Luck!

RE: Adding new fields to GP window and storing it onto the database

2
You will use VBA to save to the DUOS table.  That is the SY90000 table I believe.  Basically, every extra field you create gets stored in that one table regardless of information type.  So the VBA code has to tell what type of information, what type of value and the value.  You have to remember to add the code at each point a user could possibly save or delete the information.  This would include click Save or Delete, scrolling with browser arrows, doing a lookup and selecting another record, responding to a dialog box, and other places you may find.

RE: Adding new fields to GP window and storing it onto the database

(OP)
Hi,

Thanks a lot for all your valuable help. That was really great!!!! I created the DUOS table and the extra information i added is stored in the table SY90000..But how do I add them to the original table and how about the fields already existing? Will they be saved to the database table? Thank you

I appreciate your help...

RE: Adding new fields to GP window and storing it onto the database

You can't save them to the original table.  They remain in that DUOS table. You then have to write code to retrieve the data on the windows and reports you want.

RE: Adding new fields to GP window and storing it onto the database

Maybe you can have a look at the extender product from eonesolutions...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close