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.

to o hare transportation Riverwoods .. Lockport Chicago limo O’Hare
In The News:

When speaking becomes physically challenging, you can preserve your unique voice using Apple's Personal Voice and Live Speech technology.
Google Maps is deleting location history soon. Tech expert Kurt “CyberGuy" Knutsson shows you how to back it up before it's gone.
iOS 18.2 lets AirTag owners securely share item locations with trusted individuals. Tech expert Kurt “CyberGuy" Knutsson examines the powerful new feature.
The FBI is warning timeshare owners of a telemarketing scam tied to a Mexican drug cartel. Tech expert Kurt “CyberGuy" Knutsson provides steps to stay safe.
Protecting your home network includes securing your router, just like your phone or laptop. Kurt “CyberGuy" Knutsson reveals six ways to protect your Wi-Fi router from hackers.
Kurt “CyberGuy" Knutsson: ConnectOnCall breach leaks sensitive data of 910,000+ patients.
Rising elder scams: How to recognize them and protect yourself and your loved ones. Tech expert Kurt “CyberGuy" Knutsson helps you outsmart the scammers.
There are common habits and oversights that could leave your financial information vulnerable to cybercriminals, according to Kurt the CyberGuy.
Counting calories just got easier with The Drop, the world's first automated nutrition tracker using advanced computer vision and artificial intelligence.
A virtual private network can help ensure your information remains security and your privacy remains intact. Kurt the CyberGuy explains.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
Artificial intelligence-based cameras are giving air defense operators unprecedented capabilities in monitoring and protecting airspace.
Apple's iOS 18.1 Inactivity Reboot automatically reboots your iPhone if it hasn't been used or unlocked for more than three days, providing better data protection.
An inventor designed rooftop solar panels for a Tesla that draws solar energy while the car is parked, adding travel mileage without plugging in.
There are currently no laws governing what artificial intelligence can and cannot do with the information it gathers; here are 10 things to avoid telling AI chatbots to keep yourself safe.
A credit union with over 240,000 members recently revealed it was targeted by cybercriminals, resulting in a data breach that was part of a two-month attack by hackers.
Scammers have become skilled at creating convincing fake websites that can easily fool unsuspecting users. The CyberGuy offers tips to protect yourself.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
CAPTCHAs, which are used by websites to confirm whether users are people or bots, are harmless, but hackers are using them to infect PCs with malware.
Hackers recently leaked personal information of about 500,000 Americans and stole patient medical records that included lab results and insurance details.
The holiday season sees a rise in mobile shopping scams. Tech expert Kurt “CyberGuy" Knutsson helps you learn how to stay safe.
Tech expert Kurt “CyberGuy" Knutsson says a VPN enhances online banking security by encrypting data and protecting privacy.
Beware of these six sneaky holiday scams. Tech expert Kurt “CyberGuy" Knutsson gives you tips to avoid falling victim.
Tech expert Kurt “CyberGuy" Knutsson reveals how to securely back up and factory reset your Android to protect your privacy and data.
Artificial intelligence is making life easier for cybercriminals, allowing them to create elaborate scams to trick people. Kurt the Cyberguy explains how to protect yourself.

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... 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

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

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

Spyware Statistics -- Whats New in May 2005?

Although statistics often is blamed for various deadly sins --... Read More

Hubris - Definition: Microsofts Passport

Before September of 1995, Microsoft ignored the Internet because their... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview

Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Internet Faxing Service Review

The Internet is reshaping every form of communications medium, and... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

Brand Your Websites URL With a Favicon

Have you ever noticed that when you look at your... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

What is Preventive Maintenance Software?

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

Open Source Concepts: Dual Licensing Explained

We were recently faced with a decision: either to let... Read More

Business Plan Software Review: Ultimate Business Planner?

One of the main reasons business owners and entrepreneurs use... Read More

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

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

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

An Easy Way to Deal with Email Viruses and Worms

If you feel intimidated when someone tries to teach you... Read More

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

Cadillac Escalade rental Beaverville ..