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

---

Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... 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

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... 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

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

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

RFID: Strengthen the Position for SAP; United States

SAP Inc., a global leader in client/server enterprise application software... Read More

A Symons Mark II Function Point Counting Example

I provide, here clear explanations and a count of function... Read More

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

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

Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example

Microsoft Business Solutions Great Plains is very generic accounting application... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Interactive Mapping Brings Information to Life

What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

Navision Attain C/ODBC Crystal Report ? Customization Example

Microsoft Business Solutions Navision is main ERP application for European,... Read More

Examining the Substance of Studio MX

To all web designers out there, this article is for... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

Antivirus Software ? Get The Bugs Before They Get You!

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

Fundraising Software ? How Can That Help Me?

Fundraising software lets you connect with donors in a way... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

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

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable... Read More