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

---

5 Easy File Management Tips in Microsoft Word

How many steps does it take you to locate and... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Software Review: Xsitepro Total Site Management Software

It's not very often I get excited about a software... Read More

Groupware Finds Home in American Business: Collaboration Tool Analysis

What is Groupware?Have you ever had to manage document collaboration... 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

How to Make Own CMS

Every day millions of new web documents emerge on the... 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

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Protect Your Most Vital Business Asset with Security Software

Homeland security, airport security, Internet security â?" these days weâ??re... Read More

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... Read More

eConnect: eCommerce Development for Microsoft Great Plains

Microsoft Business Solutions Great Plains has several options to enable... Read More

Microsoft Great Plains Upgrade ? Things to Consider and FAQ

If you have Microsoft Great Plains and support it for... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Microsoft Small Business Manager eCommerce ? Overview

Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Microsoft Great Plains: Large Scale Implementation

Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

Groupware and Version History: Collaboration Series #1

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

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

What You Must Know About Spyware Right Now

Spyware is like the new technological nuclear weapon on the... Read More

6 Easy Steps for a Smoother CD/DVD Order

It's all about turn times in the eMedia industry! The... Read More

History of Java

The java programming language is becoming more and more popular... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

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

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

What is Groupware?

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

Great Plains Dexterity Customization Options ? Overview For Developers

Looks like Microsoft Great Plains becomes more and more popular,... Read More