 Free Online Articles Directory |
|||||||
Home Page  Computers Software Great Plains Integration Example: Importing Ms CRM Hours to Gp Service Invoice |
|||||||
 |
Great Plains Integration Example: Importing Ms CRM Hours to Gp Service Invoice Microsoft Dynamics GP customization tools selection changed with the introduction of eConnect. If you are on version 9.0 or higher (current GP version is 10.0 – August 2008), we recommend you to deploy eConnect in GP integration routines programming. In this small publication we would like to orient you in Microsoft CRM consulting hours capturing and moving them into Great Plains SOP invoice for billing out to your customers. This example allows MBS consulting practice to build their time billing and accounting systems virtually for free, as Microsoft Dynamics certified partners at this time enjoy GP and Microsoft CRM licenses for free
1. Service Activity in MS CRM. You can schedule, assign your CRM users and resources, associate with Account, Contract, Contract Line or even case. In our example we have case, created on contract line level as future Service Invoice in GP
2. Account contract and contract lines. In MS CRM you budget your time and assign hours (more precisely minutely) rates on the contract line level. Then you invoice contract to enable creating case, associated with contract line and toward this case your consultants log their time in the form of tasks.
3. Closing the cases and transferring them to your custom time log table. First of all, you should know that in MS CRM database you should not create custom objects, such as table, view, stored procedure. Instead you should create new database and place your custom objects there. Having time log table, you should create nightly SQL job, which will move closed cases and their tasks into time log table and mark these cases as transferred
4. Creating Service Invoices in GP. This job is done by eConnect application. You scan time log table, and create SOP Invoice with non-inventory item lines simply by placing consultant name as item number and description as task title. Finally, when your eConnect routine creates Sales Invoice for the case, you should mark case as integrated in your time log table
5. Dexterity nature of GP tables and fields. Great Plains Dexterity places some limitations on the length of GP SOP invoice line records. Please, read about the field descriptions in GP tables in Tools->Resource Description->Tables
Rate this Article:
Current: 0 / 5 stars - 0 vote(s).
Article Tags: Microsoft Dynamics Gp Article Source: http://www.articlesbase.com/software-articles/great-plains-integration-example-importing-ms-crm-hours-to-gp-service-invoice-506901.html  About the Author:Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions for the customers in CA, IL, WI, NY, FL, IN, MI, TX, GA, NE, NM, AI, NC, SC, OR, WA, DC, DE, PA, VI, AZ, LA
Related ArticlesDeciding on a New ERP Solution? Choosing Working With the Right Microsoft Partner Could Make the Difference in your Systems Success Great Plains Version Upgrade – Microsoft Dynamics Gp Installation Notes Microsoft Great Plains Version Update to 10.0 Latest Notes Workflow in Microsoft Dynamics Gp 10.0 Great Plains Support: How to Recover “suspicious” Company Database Great Plains Customization Overview or How to Modify Dynamics Gp Great Plains Programming Tools: Dex, Econnect, Sql, .net Great Plains Customization and Development: Dexterity, Econnect, Sql Scripting Got a Question? Ask.Ask the community a question about this article:Q&A Powered by:
 Latest Software ArticlesSap Business One Integration: Sb1 Reseller Chicago, Atlanta Newsflash Qc Software Sees Spike in Wcs Business Due to State Tax Incentives Tracegains Dramatically Reducing Perishable Shrink Ultimate Factories Program Looks at Optimation Client Pierce Manufacturing Delete Porn-delete Porn From Any Computer Fast! Hertzler Systems Sponsors Aberdeen Group Hosted Summit in Boston November 4-5 Great Plains Consultant Newsflash: Custom Edi How to Remotely Spy on Another Pc More from Andrew KarasevSap Business One Integration: Sb1 Reseller Chicago, Atlanta Newsflash Great Plains Consultant Newsflash: Custom Edi Sap Business One Reseller Chicago, Atlanta Newsflash: Db Structure Notes Sap Business One Var Newsflash: Workbench Integration Highlights Sap Business One Partner Atlanta, Chicago Newsflash: Data Conversion Sap Business One Consultant Atlanta, Chicago Newsflash: Customization Sap Business One Implementation in Chicago, Atlanta Newsflash Sap Business One Chicago, Atlanta Var Newsflash: Training |
|
|||||
|
Article Categories
|
|||||||
 Sign up for our email newsletterReceive updates, enter your email below
Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright © 2005-2008 Free Articles by ArticlesBase.com, All rights reserved. (0.18, 17) |
|||||||
