Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

Microsoft Great Plains may be recommended for international freight forwarding / transportation company. Great Plains has such features as multicurrency (Euro, Pound, Yuan, Yen, Peso, Real), Spanish, French, Brazilian Portuguese (and if needed Unicode-specific languages such as Chinese, Japanese). If you have operations in East Europe ? you can have Polish version as well as you can have several screens (SOP Entry, Inventory Item Maintenance, Customer/Vendor Maintenance, etc) translated to Russian, Lithuanian, Latvian. Plus ? if you consider Great Plains as a platform for custom tailoring and developing ? you can have reasonably priced solution for horizontal business, such as freight forwarding, cargo delivery, consignment, transportation. Let's consider industry specifics and the way to implement them in Microsoft Business Solutions Great Plains

? Agent Settlement. Freight forwarder usually deploys agents to deliver shipment. And agents are usually paid on the monthly or semimonthly basis. This means that you should have agents as customer.

? Daily Agent MBL invoices/statements. Assuming that agent is handling several shipment with Master Bill of Ladings (MBL) and House Bill of Ladings (HBL) per day ? freight forwarder emails to the agent daily invoices. Then these daily invoices are settled and paid one time per months

? Cargo Tracking System. This is usually custom in-house made system, specific to each freight forwarder or industry specific stand alone software. The important requirement is the integration between Shipment Tracking System and ERP, such as Great Plains

? Accurate in-time payments. Payments are required to stay in highly competitive business, such as freight forwarding

? Bill of Lading report. Where you usually need additional info to standard invoice form: Carrier, MAWB, Airport of Departure, Airport of Destination, Flight #/ETA, Weight in KG, Lbs, number of packages, etc. Technologies and customization tools:

? Great Plains Dexterity. This is Great Plains Software and currently Microsoft Great Plains programming language and IDE. It will allow you seamless integration with Great Plains user interface. You should realize agent settlement screen and inquiry, MBS/HBL profit/loss inquiry form and probably Bill of Lading in Great Plains Dexterity.

? SQL Integration. Integrating with Cargo Tracking/Delivery system should be done via SQL stored procedures. Use ODBC Linked Server to link to your tracking system database (MS SQL Server, Oracle, DB2, Unidata, Pervasive SQL, Ctree/Faircom, mySQL).

? Web Order Entry. Use eConnect to avoid high user license cost in Great Plains. eConnect is SDK to reference Great Plains objects ? you will need SOP and POP orders entry

? Customer/Vendor Consolidation. For agents, who are customers and vendors at the same time use consolidation module. It is available for Great Plains Professional only ? if you'd like to stay with Great Plains Standard ? use Great Plains Dexterity to program the consolidation.

Good luck in implementing 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, 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 clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia, Canada, Mexico 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

In The News:


pen paper and inkwell


cat break through


Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

Microsoft Great Plains has substantial mid-market share in the USA... Read More

Microsoft Great Plains POP: Purchase Order Processing ? Overview For Consultants

Great Plains Purchase Order Processing (POP) module makes up one-third... Read More

An Easy Way to Develop JAVA Enterprise Applications

Research bears that less than 70 percent of development projects... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Great Plains Dexterity ? Microsoft Great Plains Customization Overview

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

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays thetasks... Read More

Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

Microsoft Great Plains may be recommended for international freight forwarding... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Microsoft Great Plains Reporting ? Overview for Developer

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

Microsoft Great Plains SOP: Sales Order Processing

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Destination: Desktop for Google

First we had the original Google search that evolved into... Read More

Software Engineering: An Introduction

Software Engineering is the Systematic Approach for analysis design implementation... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Antivirus Software ? Get The Bugs Before They Get You!

You turn on your computer, and it doesn't look quite... Read More

Huddle Up; Groupware on Three

It could just be me, but my experiences with document... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

6 Easy Steps for a Smoother CD/DVD Order

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

Blind CC (Bcc): Master Its Use When E-Mailing

If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Your Computer May Be Infected, Heres How To Check (NOT about virus)

NOTE: Please take time to read on - it may... Read More