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! help@albaspectrum.com

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? 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:


pen paper and inkwell


cat break through


Mapping Software: Putting Data Visualization on the Map

Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

Downloading Spyware Removers: Think Before, not After

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

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

CRM 101: Customer Relationship Management for Beginners

Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

Microsoft Small Business Manager eCommerce ? Overview

Microsoft Business Solutions Small Business Manager is scaled down Great... Read More

Inherent Dangers Of File Sharing Via The Internet.

Cyberspace has opened up a new frontier with exciting possibilities... Read More

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Behave, Word, Behave!

If you copy something from a Web site or elsewhere...... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

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

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

Helping Newbies Understand Professional Software

The Windows registry is a huge database that ensures normal... Read More

Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

Microsoft Business Solutions Great Plains has many years of successful... Read More

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

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

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

Manufacturing Solutions for Microsoft Great Plains ? Overview for Consultant

Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More

Free Software: How Not To Get More Than You Bargained For!

I completed an experiment recently. I wanted to find out... Read More

Microsoft Great Plains BR: Bank Reconciliation

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

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

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

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

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications... Read More

Dashboard Widgets for Windows

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

10 Steps To Secure And Manage Your Passwords

Passwords protect your most sensitive personal, financial and business information.... Read More

Microsoft Great Plains GL: General Ledger ? Overview For Consultant

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

5 Time-Saving Tips in Microsoft Word

Whether you have used Microsoft Word for years, have just... Read More

Microsoft C# vs. VB.Net

Hi, Guys,I believe a lot of programmers are trying to... Read More