Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision, Solomon and its own CRM solution ? Microsoft CRM. Targeting to automate all business operations, Microsoft CRM is now integrated with Microsoft Great Plains and in the close future it should have integration with Microsoft Navision. In this small article we'll show you business automation example, where Microsoft CRM and Great Plains are integrated and customized to fit Freight Forwarding business processes.

? CRM. Central Customer and Vendor records place. Assuming you have agents across the USA and internationally ? CRM, being web-interface application and so, could be used across the globe with good internet connection. The nice features of this product are central emailing ? you send email from MS CRM and receive responses from your clients back in CRM, where they are permanently stored and documented. You can issue Quote and Sales Order directly in CRM if needed or could have them issues in Microsoft Great Plains with propagation to Microsoft CRM (deploying MS CRM-Great Plains integration tool ? BizTalk based connector).

? Accounting/ERP. Microsoft Great Plains could play this role, being integrated with Microsoft CRM and with industry-specific business system. In the case of Freight Forwarding/Transportation ? this business system could calculate fees and charged, associated with MBL/HBL and posted against agent accounts. You could deploy SQL triggers for instant integration or stored procs for scheduled batches.

? Great Plains Customizations. Freight Forwarding specifics require Shipment tracking with SOP and POP invoices posted and tracked against the shipment and probably regular/monthly Agent Settlement report, where you match customer and vendor invoices, associated with the agent shipments and create AR or AP document, depending on positive or negative balance. This is Great Plains Dexterity customization or web-development (if you need your agents lookup features from remote locations)

? Microsoft CRM Customization. Assuming that you have Shipment Tracking system, which might be SQL or Oracle based ? you need shipment lookups for your order takers and customer support personnel from Microsoft CRM screens. Being designed for easy web customization ? Microsoft CRM allows you to incorporate .Net web application into its screens, such as Account, Contact, Lead, Opportunity, etc. You use Web Forms and Microsoft CRM SDK to penetrate into MS CRM security realm and then ADO.Net to call third party MS SQL Server or Oracle data

? Implementation Advices. Microsoft CRM should be probably tried as in-house pilot implementation with 5 users license and then you can purchase additional license as you have your users trained. If you need MS CRM SDK C# or VB.Net programming ? you could subcontract. Great Plains requires consultant help to be implemented and integrated, because it has sophisticated tables structure and documents flow mechanism.

? Data Conversion. We recommend you to deploy Great Plains Integration manager to import Vendor and Customers plus open documents. Historical transactions, if needed ? should be moved by outside consultant. Microsoft CRM has import tool ? try it first and subcontract more complex ? attachments, for example.

Good luck with implementation and customization and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com

---

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

Microsoft CRM Customization Secrets ? Second Edition

This article is for advanced Microsoft CRM SDK C# developers.... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

Software Development in 2005 - Back to the Future

2005 ? Back to the Future.What does the future hold?... Read More

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

What is Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

Microsoft CRM Customization

Microsoft CRM customization techniques are very diversified and based on... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Microsoft Great Plains: Annual Enhancement Program ? How To Be Re-Enrolled

Microsoft Business Solutions Great Plains is mid and even corporate... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

And kill the best layout software in the process of... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

Microsoft Great Plains Payroll Module Customization Scenarios

It is now common thing when large corporation selects mid-market... Read More

Microsoft Great Plains Jewelry ? Implementation & Customization Overview

Each Industry and market niche has business specific and unique... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

S is for Spying, Surveillance -- and for Software as Well

Words we choose to describe things and phenomena often show... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

Top Questions to Ask Before Buying a Help Desk & Asset Management Software

#5 All your hardware components like Printers, PCs etc come... Read More

Microsoft CRM: Implementation, Customization, Support ? Consultant Overview

Microsoft Business Solutions CRM is present several years on the... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains... Read More

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

RFID: Strengthen the Position for SAP; United States

SAP Inc., a global leader in client/server enterprise application software... Read More