Consulting businesses often require robust systems to track time and manage client billing efficiently. Microsoft Dynamics CRM, when integrated with Great Plains (GP), can serve as a powerful tool for consultants to log time, generate invoices, and report on project status. This article delves into the technical aspects of integrating Microsoft CRM with GP, providing insights and C# source code for developers to customize and implement a solution that automates the creation of sales invoices from CRM tasks.
The integration between Microsoft CRM and Great Plains (GP) is designed to streamline the billing process for consulting businesses. Here's how it works:
Time Tracking in CRM: Consultants log their timesheets as tasks in Microsoft CRM against contract line cases. These tasks are then integrated as GP Sales Order Processing Invoice lines. However, there's a limitation to consider: GP SOP line descriptions are truncated to 100 characters.
Automated Invoice Creation: GP sales invoices are generated automatically through an overnight integration process when a case is closed in CRM. If multiple cases for the same customer are closed—such as QA, development, and onsite consulting—they are combined into a single invoice per customer.
Enhanced Reporting: Microsoft Dynamics CRM offers additional capabilities for creating comprehensive consultant time tracking and project status reports.
Code Availability: The Microsoft Dynamics GP eConnect 10.0 SDK lacks a C# demo project for Sales Invoice integration. The provided demo C# code includes a custom project that addresses this gap, featuring the SerializeSalesOrderObject
procedure.
The provided C# source code is a starting point for developers to create a tailored integration solution. It requires the expertise of GP eConnect C# programmers to customize and install the code appropriately. The code listing includes various namespaces and classes necessary for establishing connections, handling data, and executing the integration process.
While the provided code serves as a functional framework, it's important to note that each consulting business may have unique requirements. Customization is essential to ensure that the integration aligns with specific workflows, data structures, and reporting needs.
Microsoft Dynamics GP eConnect is a set of tools and components that allow for programmable access to GP data. It's a crucial element in the integration process, enabling developers to create, update, and retrieve GP documents programmatically. The provided code utilizes eConnect methods to facilitate the creation of customer records and sales invoices based on CRM data.
Integrating Microsoft CRM with Great Plains using the provided C# source code can significantly enhance the efficiency of time tracking and billing processes for consulting businesses. However, it's essential to engage skilled GP eConnect C# programmers to customize and implement the solution effectively.
For developers interested in exploring the full capabilities of Microsoft Dynamics GP eConnect, the official Microsoft Dynamics GP documentation provides comprehensive information and resources. Additionally, the Microsoft Dynamics CRM Community is a valuable platform for sharing knowledge, asking questions, and connecting with other CRM professionals.
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQPlanning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella