Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Creating table using VStool kit

Posted on by 325

Hi 

    I just created a custom form  for GP sales transaction entry window  using Visual studio tool kit . Now i want to store the values  in the custom table.What is procedure to create a table using VS tool kit for dynamics GP.

Thanks... 

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Creating table using VStool kit

    Why don't you simply create a sql script that contains all of your tables, stored procedures, functions etc and then call this script as part of your installation procedure or give the user a setup screen where one button click initializes what you need? This moves all of this activity into SQL where it belongs.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Creating table using VStool kit

    Hi Shri Ram,

    Developed customization are delivered as dll file and you can paste that file in GP Addins folder.

    if it is GP 2013 i guess we can paste in GP installation folder itself.

  • Suggested answer
    Naga Kiran Profile Picture
    Naga Kiran on at
    RE: Creating table using VStool kit

    I never tried this but If you intend to use the table for your custom Form alone, you may create the table directly in back end under Company/System databases and perform read and write to the table using ADO.Net in VS Tools GP addin you created. You can use the Dynamics GP SQL connection to perform the same.

  • Shriram Profile Picture
    Shriram 325 on at
    RE: Creating table using VStool kit

    Hi Natraj

           how to implement it in production server? By chunk? or some other way?

    thanks...

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Creating table using VStool kit

    Hi Shri Ram,

    I guess there is no option for creating table using VSTools. please use Dexterity to create tables or use store procedure in VS tools to insert values to the custom table.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans