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

---

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

Outlook... Not Just for Email! Using Your Outlook Calendar

Microsoft Outlook is one of the most widely used software... Read More

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

The Hidden Power of Online Manual

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

Screenplay and Script Writing Software

When it comes to screenplay software each screenwriter needs to... Read More

Software Engineering: An Introduction

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

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

What is Preventive Maintenance Software?

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

Great Plains Sales Order Processing and Invoicing Modules ? Tips For Consultants

We'll give you non formal view, based on our consulting... Read More

Microsoft Great Plains Inventory Control ? Overview For Consultant

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

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

An Easy Way to Develop JAVA Enterprise Applications

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

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

OSI Layers Model

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

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

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

3 Reasons Why Medical Billing Software is Leading the Way

Since technology changes so quickly, it is hard to begin... Read More

40/sec to 500/sec

IntroductionSurprised, by the title? well, this is a tour of... Read More

Free Software for Newbies and Web Developers

Here is some free software tools to help you build... Read More

Quick Summary of Basic and Common Linux Commands

There are many commands that are used in linux on... Read More

Resume Software ? Advantages Revealed

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

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

Many reasons made GBM a unanimous choice for experts, one... Read More

netstat - Linux Command to Display Networking Information

In linux, one of great commands for finding out information... Read More

Brief Notes About Mainframe Software Pricing

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

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... 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

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More