Creating table using VStool kit

(0) Share

Report

Posted on by Shriram

325

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Shriram 325 on at

Like (0)

Report

Hi Natraj

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

thanks...

Was this reply helpful? Yes No
Suggested answer

Naga Kiran on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No