web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Custom Modifier GP Field
Microsoft Dynamics GP (Archived)

Custom Modifier GP Field

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I've been looking through the GP Modifier documentation, and just have a quick question.  With regards to adding a custom field to a GP form - from what I gather, I would use the appropriate DUOS object to retrieve/update/save the value of the custom field added using Modifier.  My only question is - if I was adding a field to say, the Vendor Address screen, would I add the field to the database in the actual Vendor Address screen?  If so, would the DUOS object recognize my newly added field?  Let me know if I am not on the right track here :)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    If you are using DUOS for your requirement, you are just adding the field to the form and the data is stored in the DUOS table. There is no need in adding the field to the tables in the database.

    Refer the links:

    blogs.msdn.com/.../what-is-the-dynamic-user-object-store-duos.aspx

    community.dynamics.com/.../what-is-the-dynamic-user-object-store-40-duos-41

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    I think you are misunderstood the GP table behavior. We can not add any field on any existing GP tables. If you add and new field to GP original table, you need to re-create the table and it will lost all the existing data. This is not a suggested way.

    If you want to add any field on any GP window, just modify the window and add the new field to this window and include this same field on any custom table(For you case, create a new table with using appropriate vendor address related field), not GP table (Vendor Address).

    Then create a trigger to save your new field value to custom table once users save the Vendor address information on that window. Follow the same logic for retrieve and delete as well.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at

    Thanks to both of you for the info.  I will need to review the documentation a bit more.  But basically, you would store the values of the custom field in a custom SQL table (along with a key field from the GP table)?  And I should be able to get a DUOS handle to my custom SQL table?

  • Verified answer
    soma Profile Picture
    soma 24,410 on at

    Yes. You should store the values of custom field along with GP key field in your custom table by writing VBA or dexterity triggers.

    Hope this helps!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans