Utility Script for CRM Connector Integrating with Dynamics GP Sample Company

Sivakumar Venkataraman - Click for blog homepageThis is a reposting of an article Sivakumar Venkataraman originally wrote on my Developing for Dynamics GP blog.

This is an interesting script which I have decided to post in this article.

When we configure CRM Connector with Dynamics GP for the sample company (Fabricam, Inc.,), there is a known issue in the way the sample company data is structured.

Continue reading

Email Functionality in Dynamics GP – Some Table Definitions

Sivakumar Venkataraman - Click for blog homepageThis is a reposting of an article Sivakumar Venkataraman originally wrote on my Developing for Dynamics GP blog.

Recently, I was working on a community forum request, where the user was requesting for table structure documentation for the email tables in Microsoft Dynamics GP. I have explained some of them in this article for the benefit of the community.

Continue reading

SQL Script for Account Level Security

Sivakumar Venkataraman - Click for blog homepageThis is a reposting of an article Sivakumar Venkataraman originally wrote on my Developing for Dynamics GP blog.

I recently joined Microsoft as a Partner Consultant for the Global Partner Services team. I have been associated for more than 8 years in the design, development and implementation of Microsoft Dynamics GP in India, Middle East and US. This is my first post in this blog and it feels great to be posting alongside community experts like David Musgrave, Patrick Roth and others.

Microsoft Dynamics GP offers the Account Level Security option to restrict the access of GL accounts to specific users. There is no specific report (or) Smartlist which is available for viewing the details of the accounts which each user has access to.

Continue reading