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

---

15 Questions to Ask Your Software Vendor

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

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

Software Piracy

SOFTWARE PIRACY We regularly hear reports... Read More

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

Microsoft Great Plains Middle East - Arabic Language Support

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

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

Popular Fleet Maintenance Programs

Some companies that are in need of fleet management may... 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

ERP for Large Corporation ? New Selling Strategy

Our opinion is based on our Microsoft Business Solutions Great... Read More

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

CRM and Customer Life Cycle

Customer Relationship Management or CRM is a combination of enterprise... Read More

Your Computer May Be Infected, Heres How To Check (NOT about virus)

NOTE: Please take time to read on - it may... Read More

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail... Read More

CROOK: A Methodology for the Refinement of Forward-Error Correction

Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Five Steps to Rapid Development with TierDeveloper 4.0

Follow the steps below to quickly design, generate, and deploy... Read More

Microsoft Great Plains: Getting New Users Licenses ? Annual Service Plan FAQ

Microsoft Business Solutions Great Plains, Solomon, Navision, Axapta, Microsoft CRM... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

You Can Write Microsoft Office Program in About 60 Minutes

Microsoft Office program is a programming tool called Visual Basic... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

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

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

Inherent Dangers Of File Sharing Via The Internet.

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

Know-how in Microsoft Publisher

For those who still don't know, Microsoft Publisher helps computer... Read More

Hubris - Definition: Microsofts Passport

Before September of 1995, Microsoft ignored the Internet because their... Read More

Helping Newbies Understand Professional Software

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

3 Reasons Why Medical Billing Software is Leading the Way

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

The Hidden Power of Online Manual

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

Make 2005 the Year You Save Time!

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

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More