Microsoft Great Plains in Metal Distribution: Implementation & Customization ? Consultant Overview

Microsoft Business Solutions Great Plains serves to the wide spectrum of horizontal markets and could be also considered as generic ERP/MRP/Accounting platform for light and advanced customization to fit verticals. In this small article we describe distribution sector with the example from metal distribution - Dealer/broker of industrial nonferrous by-product scrap, de-tins and de-oils industrial by-product scrap and finished parts. It might sound a bit complex ? but we think this is typical for this horizontal market niche. The language of the article is targeted to primarily technical consultant and in-house programmer/software developer. In our opinion ? ERP applications should be implemented with the leveraged help and support of internal IT people ? we are entering into the epoch of technical specialists and IT departments ? smile.

Industry specifics:

? Cost / Price with 5 decimals of the dollar. Well ? if you sell thousands of pounds with the price per pound ? then every tiny fraction of the cent makes a difference in vendor selection. In Microsoft Great Plains you have reserved 5 digits in the currency datatype to be able to track 5 decimals of the $. In case of Euro or other currency in multi currency environment ? this should be applicable to your local currency: Rand, Peso, Real, Pound, Yen, Chinese Yuan.

? Settlement Report. This report is typical for distribution and logistics type of business. In case of metal distributor ? this report shows either monthly transactions log or HBL (House Bill of Lading) /MBL (Master Bill of Lading). Again we should implement 5 digits fractioning of the main currency. This report is classical Great Plains Dexterity or Crystal Report ? depending on the level of integration with Great Plains screens (Dexterity gives you seamless integration ? Crystal requires Modifier/VBA scripting to call Crystal Reports engine)

? Historical Customer Orders. When order taker gets order by phone she/he should have instant access to customer's recent purchases and comparisons with average recent sales for the specific alloy or metal item. The customization you need is Great Plains Dexterity sales pad and instant item sales inquiry. Both should pull info from Sales Order Processing (SOP) module and have item lookup to Inventory Control (IV)

? Compliance Reporting. We recommend you to use Crystal Reports ? this tool should stay for five years and plus. These reports should publish Great Plains company database data at your will and the requirements of the federal or state authority

? Customization & Modification. You should consider using these tools: Great Plains Dexterity (requires some training and experience), Crystal Reports, Visual Studio.Net web publishing, MS SQL Server stored procedures for data integration and feeding.

Good luck with localization, 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 1-630-961-5918 or 1-866-528-0577! help@albaspectrum.com

Author is a Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, New Orleans, Toronto, Montreal and having locations in multiple states and internationally

---

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

ERP Implementation: Success Factors

As seeing large number of implementations ? in our case... Read More

eCommerce development for Microsoft Great Plains: tools and highlights for programmer

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

What is Shareware?

Shareware is software that you can try before you buy;... Read More

What To Do When Windows Wont Boot

When Windows fails to boot it is normally caused by... Read More

Monitoring Software Can be Used for Spying as Well

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

Software Companies: Generate New Revenue Streams and Decrease Costs with Custom e-Learning Content

It's no secret that software companies operate in a very... Read More

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

Groupware and Version History: Collaboration Series #1

This article is the first of a series of articles... 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

Blind CC (Bcc): Master Its Use When E-Mailing

If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... Read More

20 Extra Hours Per Week: What Would You Do?

While I was in college, if you would have asked... Read More

Save Your Resources - Combine Your IM Clients

There are so many different programs that clutter up your... Read More

Tripwire for Linux File Integrity

What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

IBM Lotus Domino or Microsoft Exchange?

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

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

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

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Razzle Dazzle Them

Once upon a time not so long ago, there was... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... 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 Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

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

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

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Spyware - The Internet Devil Of Our Times!

Spyware and Adware infest over 90 percent of computers in... Read More

New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink

Three highly respected names in Human Resources have joined forces... Read More

Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

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