Microsoft Great Plains & CRM in Transportation & Logistics ? Overview

Microsoft Business Solutions Great Plains and MS CRM (client relation management system) are very popular in various industries and market niches. In previous article we described Microsoft Great Plains implementation for transportation & logistics company. Having more material, we would like to share with you how you can leverage Microsoft Business Solutions products to automate your business. We'll try to be both technical and business processes specific and be laconic to comply the rules of tiny article.

? Cargo/Shipment Tracking System. Transportation & Logistics industry is pretty mature and you more likely have industry standard (like Efreight) or custom system. So, if you plan to implement new ERP ? it should be tightly integrated with your cargo tracking system.

? Customer Base. This is the question of the core application. If you have to sell to a large number of prospects and track their relatively small shipments ? you should first consider Microsoft CRM, which has Sales and Service modules. In this case ? you should enable shipment status lookup from MS CRM screens. In the case when you ship to limited number of large customers ? you are focusing on the profitability of the shipments and looking at Great Plains as the core system.

? Agent Settlement. This seems to be logistics industry feature. You use agents and settle their AR/AP invoices on the monthly or weekly basis. In Great Plains you should use customer/vendor consolidation, available for Great Plains Professional version. Plus you will need Great Plains Dexterity or .Net customization to link SOP and POP invoices in the settlement process.

? eConnect. Each logistics business has unique business processes and this is why we see software developers in staff plus strong IT department. This makes eConnect (Microsoft Great Plains SDK) very popular among logistics companies. You can create Great Plains objects: Customers, Invoices, Purchase Orders, etc. Plus it allows you to eliminate GP licenses cost ? you can have users work with Great Plains through web forms

? Integration Technology. In the case of both Great Plains and Microsoft CRM you use MS SQL Server linked server technology. Then you deploy MS CRM SDK, Dexterity, Heterogeneous Stored Procedures.

? Programming Tools. You use Visual Studio.Net to program MS CRM lookups, in some cases you can use WebMatrix, but we do not recommend tools, which do not have rich debugging features.

? Reporting. Crystal Reports is the tool of choice. You should create heterogeneous SQL view and base you Crystal Report on this view. Microsoft CRM security suggests you to use MS CRM SDK or built-in Crystal Reports Enterprise to comply.

? MS CRM Messaging. Microsoft CRM Exchange connector has relatively straightforward mechanism ? GUID in the message header. If you need advanced messaging ? capturing emails, based on contact email or domain ? you main consider advanced connector, developed and supported by Alba Spectrum Technologies. In some cases you would like to use Lotus Notes Domino as email server ? this is also possible.

You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is consultant and CTO in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Business Solutions partner, serving clients in Illinois, New York, California, Florida, Georgia, Texas, Arizona, Virginia, Minnesota, Canada, UK, Europe, Australia, Asia, Russia. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer.

---

How Do I Get Rid Of That Darn Spyware?

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

Groupware Finds Home in American Business: Collaboration Tool Analysis

What is Groupware?Have you ever had to manage document collaboration... Read More

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Microsoft Great Plains Customization Tools ? Overview

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

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... Read More

Great Plains Dexterity Customization Options ? Overview For Developers

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

ERP System of the Future: Database, Business Logic and Interface

We will base our prognosis on our Microsoft Business Solutions... Read More

Make or Break Factors - When Considering Estimating Software

Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

What You Should Know About Installing Screensavers

Do you remember that frustrating feeling when you find an... 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

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

What To Do When Windows Wont Boot

When Windows fails to boot it is normally caused by... Read More

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

Manufacturing in the USA is far away down from mid... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

How to Evaluate Staffing Software

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

Need of Document Management System (DMS)

Document Management or Enterprise Information Management is perhaps one of... Read More

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

1. What determines the software price? Is it Per Seat... Read More

History of Java

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

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More

eConnect: eCommerce Development for Microsoft Great Plains

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

Microsoft Great Plains Integrations ? Retail Management Sample

Microsoft Business Solutions is emerging as very attractive vendor for... Read More

3 Reasons Why Medical Billing Software is Leading the Way

Since technology changes so quickly, it is hard to begin... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... 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

25 Things Mapping Software Can Do For You

1. With mapping software you can create a report that... Read More

Free Program Removes Spyware not Detected by Premium Security Scan

What is Spyware?Spyware monitors your surfing habits and sends the... Read More