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: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

Free Software - Powerful Alternatives to Budget-Busting Software

When you buy a computer, it most likely comes with... Read More

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

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

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

Benefits of Shareware

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

Microsoft Great Plains Inventory Control ? Overview For Consultant

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

Microsoft CRM Development

Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Software Development in 2005 - Back to the Future

2005 ? Back to the Future.What does the future hold?... Read More

Microsoft Great Plains BR: Bank Reconciliation

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

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

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

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

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application... 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

Brief Notes About Mainframe Software Pricing

We don't think about mainframe software pricing anymore, we just... Read More

OEComplete ? A Personal Information Manager

OEComplete is a utility for managing the personal information of... Read More

OSI Layers Model

IntroductionDuring the early years of our modern computer era, very... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Professional XP Style Icons in Software and Website Development

Using professional icons in your application or website can bring... Read More

Microsoft CRM Implementation - US Market Lessons

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

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0

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

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... Read More

When is a Software Engineer Not a Software Engineer?

The title of "software engineer" has got to be among... Read More

The Dreaded Paper Label - Should it be Used?

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

Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

Logistics automation is often considered as barcoding extension to Sales... Read More

Screenshots Vista Windows

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

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Save Your Resources - Combine Your IM Clients

There are so many different programs that clutter up your... Read More