Home
>
Software
>
Microsoft Great Plains & CRM in Transportation & Logistics ? Overview

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.

move in cleaning service Mundelein ..

In The News:

Kodiak Driver autonomous truck achieves perfect 98 safety score, matching top human fleets in groundbreaking AI evaluation by Nauto's VERA system.

New 401k catch-up contribution rules in 2026 will change taxes for high earners over 50. Learn how scammers exploit these changes and protect your retirement savings.

Kurt Knutsson's guide covers social media privacy protection through location settings, account privacy controls and two-factor authentication to prevent scams and data breaches.

Revolutionary retinal implant restores central vision in 80% of patients with advanced macular degeneration, offering hope where treatments once only slowed blindness.

Learn how to use passkeys on Windows and Mac computers without cameras or fingerprint readers. Discover secure authentication methods that replace passwords.

Tesla's FSD v14.1.2 update reintroduces Mad Max mode, enabling higher speeds and more frequent lane changes than the standard Hurry profile setting.

A phishing email scam targeting American Express customers shows how cybercriminals use fake urgent messages to steal personal and financial information.

Facebook's new Meta AI feature analyzes your camera roll photos to create polished collages automatically, but requires cloud processing and raises privacy concerns.

A New Jersey teenager filed a major lawsuit against AI/Robotics Venture Strategy 3 Ltd. over ClothOff, an AI tool that created fake nude images from her social media photos.

Microsoft reports Storm-2657 cybercriminals sent phishing emails to 6,000 addresses at 25 universities to steal payroll credentials and redirect funds.

Astronomers have discovered asteroid 2025 SC79, a skyscraper-sized space rock orbiting the sun in just 128 days. the second-fastest known.

The Fox News AI Newsletter delivers the latest developments form the world of artificial intelligence, including the technology's challenges and opportunities.

A cyberattack on SimonMed Imaging exposed personal information of 1.2 million patients, including medical records, financial details and identity papers.

Spotify's managed accounts for kids under 13 now available in at least seven countries, allowing parents to filter and block explicit content and songs.

Friendly text conversations about BBQs and social events can lead to WEEX gold trading scams that target older adults with fake investment opportunities.

California company Skyeports creates self-healing glass spheres from Moon regolith that generate solar power and support plant growth for sustainable lunar living.

Cleafy researchers discover fake VPN streaming app Mobdro Pro that installs Klopatra banking Trojan, giving attackers full control over Android devices.

Police departments across the U.S. and Canada are adopting virtual reality training to better prepare officers for high-pressure, real-world situations.

House Bill 469 would prevent AI systems from owning property, serving as executives, or gaining legal personhood in Ohio under Representative Thaddeus Claggett's proposal.

Public voter records expose retirees' personal details to election scammers who create targeted cons using names, addresses, and voting history data.

Instead of fearing what comes next with artificial intelligence, think outside the box. Here are high-earning AI jobs that don't require a computer science degree.

OpenAI CEO Sam Altman says polite words like "please" and "thank you" cost millions annually, while direct prompts may improve ChatGPT accuracy by several points.

Chattee Chat and GiMe Chat exposed intimate conversations and photos, revealing users spent up to $18,000 on AI companions before the breach.

New Instagram parental controls allow families to manage teen screen time and content limits through the Family Center with stricter safety settings.

Third-party security breach at Discord exposes sensitive user information including government IDs, highlighting cybersecurity risks from external service providers.

Microsoft Great Plains & CRM in Transportation & Logistics ? Overview

Software