Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example

Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great Plains eEnterprise/Dynamics 7.0, 6.0, Dynamics C/S+ 5.5 and 5.0 serve USA, UK, South Africa, Australia, Middle East horizontal market. As being relatively inexpensive solution, it is reasonably open to be customizable to fit specific industry niche. In this small article we'll give you highlight on how Great Plains could serve specific vertical demands of transportation and freight forwarding industry Industry requirements:

? Agent Monthly Settlement invoicing. Freight Forwarders use agents and usually pay them on the monthly basis, depending on the results. Freight Forwarded pays fees and collects money from customers, and if collection exceeds fees ? it pays to the agent, in the opposite case it issues debit memo. Agent should receive detailed invoice.

? Shipment Inquiry Form. Usually each Freight Forwarding has custom or standard shipping tracking system. This system is primary source of information about the shipment, then all the collections and fees and associated customer and vendor invoices are moved to Accounting Application, such as Microsoft Great Plains. From this accounting/ERP system we need Shipment Inquiry functionality with the report on the profit/loss from this specific shipment

Microsoft Great Plains realization:

? Technology. Microsoft Great Plains sits on MS SQL Server platform and typical technologies are: Stored Procedures and also Great Plains Dexterity for Screens and Reports ? this is Great Plains Software (currently Microsoft Business Solutions) proprietary software development language and IDE

? Integration ? is usually realized through Microsoft SQL Server linked server architecture and distributed queries. These queries might be triggered or placed as MSSQL Server overnight job. Transactions come to Sales Order Processing (SOP) and Purchase Order Processing (POP) modules, where they are placed into batches. Batches then should be processed by AP/AR departments

? Agent Monthly Settlement. This should be realized as Great Plains Dexterity custom window, with two scrolling windows on it, where you should list SOP Invoices and POP Shipments with Invoices

? Shipment Inquiry Form. Use the same Great Plains Dexterity custom window technology.

? Reports ? you are free to use either Dexterity report or Crystal Reports designer

Good luck and you can always seek our help in customization, implementation, integration and support. Call us: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK

In The News:

pen paper and inkwell


cat break through


Crystal Reports for Microsoft Great Plains

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

How to Choose the BEST Charting Software

I suggest that you do not spend a lot of... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

Resume Software ? Advantages Revealed

The various resume software offered, particularly on the internet, can... Read More

Healthcare Preventive Maintenance Software

Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

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

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

Can You Calculate Complex Financial Calculations?

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

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More

Lotus Notes Domino and Microsoft CRM Integration

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

Groupware as a Document Manager: Collaboration Series #3

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

Falling in Love With More Than One Screensaver: The Fun Part

Having from five to ten and more favorite screensavers is... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Is Your Family Protected?

When you think... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Ukraine: a Prospective Player on the World Software Outsourcing Market

The destruction of the Soviet Union about 15 years ago,... Read More

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications... Read More

Microsoft CRM Implementation - US Market Lessons

Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More

SSH (SCP) Send Files from Windows to Your Linux Box

Not all of us have the luxury of working both... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Screenshots Vista Windows

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

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Anti-Spyware Protection ? Holes in the Shining Armor

Looking at all the ads which promise to get rid... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... Read More

The Hidden Power of Online Manual

Writing software manuals is boring, isn't it? We often think:... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

Navision Attain Database access via C/ODBC in ASP.NET Application

Navision Software was purchased by Microsoft and now it is... Read More

QuarkXpress Tips: How to Move Content Between Print and Web Layouts

Since its release in 1987, QuarkXpress had made an immediate... Read More

Performance Tuning of a Daffodil DB / One$DB -JDBC Application

This article illustrates the best practices to improve the performance... Read More