Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

Bill of Lading is required report for Logistics and Freight Forwarding companies. If you are looking at Freight Forwarding software, targeted to automate transportation business ? Bill of Lading with multiple custom forms should be present there. However if you need the extension to standard ERP/Accounting application ? you may be looking at the option to customize the system. Microsoft Business Solutions Great Plains might be considered as ERP platform, ready for customization. Let us give you customization highlights.

? Sales Order Processing ? SOP is the module, where you create customer order, transfer it into invoice upon the completion, fulfillment or allocation. So, naturally Bill of Lading should be originated in SOP. Also nice feature in SOP is multicurrency (Dollar, Euro, Yen, Yuan, Peso) support, so Bill of Lading report could be produced for international shipment

? MBL/HBL ? House Bill of Lading may include several Master Bill of Ladings, associated with the shipment to specific customer. Microsoft Great Plains naturally associate invoice with single customer, this is why House Bill of Lading should be light Great Plains Dexterity customization, where you combine several shipments into one container (HBL). Simplified solution is just to use user defined fields for HBL & MBL.

? Cargo/Shipment Inquiry ? you might also need to see the profit/loss on the shipment/HBL. This window should include all AR and AP invoices associated with HBL with drill down to original documents functionality. This maybe done as Dexterity, C#/VB.Net application, publishing SOP tables (SOP30200, SOP30300), or just a report

? Technologies. Microsoft Great Plains Dexterity is programming language and development environment of Great Plains. Great Plains Software has Great Plains Dynamics/Dynamics C/S+/eEnterprise and currently Microsoft Great Plains lines of products developed in Great Plains Dexterity. ReportWriter ? this tool will allow you modify existing Picking Ticket, Packing List or Invoice form to produce Bill of Lading. ReportWriter has some restrictions: in order to place fields from your custom tables or from third party modules on ReportWriter report you need light Dexterity customization (rw_* functions). VBA/Modifier will allow you to modify Great Plains forms and attach VBA scripts to buttons. Crystal Reports ? with Crystal Reports Designer you could produce the report of maximal complexity, including the report pulling info from heterogeneous databases (as if portion of your Bill of Lading info resides in Oracle, DB2 custom database).

Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! [email protected]

Andrew is Great Plains specialist in Alba Spectrum Technologies ( ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

In The News:

Beware of free software  Telegraph India
SOCOM Rolls Out New Software Program Office  National Defense Magazine
Nutanix, VMware Battle For HCI Software Market Share Lead  CRN: Technology news for channel partners and solution providers

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... 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

The Top 5 Wrong Reasons For Not Hiring Testers

Considering whether or not your software company should hire a... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... Read More

Google Brings the Earth to Your Desktop

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

The True Meaning of Freeware

The vast majority of us will have, at some point,... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... 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 Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... Read More

Screenshots Vista Windows

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

Top Questions to Ask Before Buying a Help Desk & Asset Management Software

#5 All your hardware components like Printers, PCs etc come... Read More

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

IBM Lotus Domino or Microsoft Exchange?

IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

Microsoft Great Plains e-Commerce ? additional considerations for programmer

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

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

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

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

The Dreaded Paper Label - Should it be Used?

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

Dig Out That Worm

Internet worms. Is your PC infected?If your computer has become... Read More

When is a Software Engineer Not a Software Engineer?

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

Microsoft Great Plains Jewelry ? Implementation & Customization Overview

Each Industry and market niche has business specific and unique... Read More

Is Your Family Protected?

When you think... Read More