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

In The News:


pen paper and inkwell


cat break through


10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

How a Bug Challenges to a Software Professional

It is really interesting that a bug can create problem... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including... Read More

Increase Office Efficiency With One Simple Tool

When you need a phone number, you do a quick... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... 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

ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses

Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

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

How Do I Get Rid Of That Darn Spyware?

Ad-Aware and Spybot are probably the two most well known... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

Microsoft Great Plains fits to majority of horizontals and retail... Read More

Microsoft CRM ? Typical Customizations

Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More

Groupware and Version History: Collaboration Series #1

This article is the first of a series of articles... Read More

Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

Many reasons made GBM a unanimous choice for experts, one... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

Perfectly New Database Query Tool - Foxy SQL Pro Released

Are you a database professional? Do you work with a... Read More

Where to Find Free Fleet Maintenance Software

Costs of fleet maintenance software can vary widely. It is... Read More

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Screenshots Vista Windows

Features Additionally, Vista will include many other new features.Aero Vista... Read More