Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant

Microsoft Great Plains ? ERM from Microsoft Business Solutions and formerly Great Plains Software is pretty generic with its standard set of modules: GL, BR, AR, AP, IV, SOP, POP and US Payroll. However, having about twelve years of implementation and customization history ? Great Plains Dynamics, Dynamics C/S+, eEnterprise being Great Plains Dexterity written application has been and still is attractive core platform for third party software development companies to write vertical and horizontal modules, written as well in Great Plains Dexterity. If you have Microsoft Great Plains implemented or under the implementation should have your options in making in-house or outsourced customizations to fit your vertical industry needs. Let's consider consignment, barcoding and distribution/warehouse management

1. Consignment Sales & Recurring Sales. If your business is bakery, sandwiches or ice cream making ? you probably send recurring daily shipments / trucks to your customers on consignment. You need accurate system with daily predictions and recommendation on the lot size, based on historical data: day of the week, season, holiday, etc. This is very popular Dexterity customization, dealing with SOP (Sales Order Processing) and IV (Inventory Control) modules

2. Trucks Scheduling / Distribution. In the case of consignment sales you may have your own fleet of trucks. Then for each truck you should have SOP orders batch and you need to print picking tickets. You should first print the picking tickets for the longest route and then one-by-one up to the shortest route. This is also Dexterity customization for SOP module.

3. Barcoding, Warehouse Management. Lot number tracking, Receiving, Order Fulfillment, Inventory transfer and Cycle Count could be automated with Barcoding. Barcode scanner could automate picking list allocation by reading first picking list number and then scan items and quantities ? and doing so ? allocate Items for Sales Order in Sales Order Processing. Usually you write Visual Basic application or routine to work with the scanner and then communicate with Microsoft Great Plains SQL database ? more precisely ? with Sales Order and Inventory tables: SOP10100. SOP10200, IV00100

4. Wholesale ? daily sales and comparisons, profit by item and salesperson. Yes ? all these calculations could be pulled from SOP historical and work tables, item sales analysis, etc. You can deploy Crystal Reports and even Datawarehousing solution to pivot your cube. If you need fixed number of reports and criteria ? you may need again Dexterity or .Net application to arrange reporting data

Considering Microsoft Great Plains ? majority of the logic above is implemented and could be implemented in Great Plains Dexterity. Alternative platform would be Microsoft C# or VB.Net ASPX web programming with Microsoft Great Plains at the back end. You can use such tools as eConnect to work with Great Plains object creation and retrieving or go ahead with direct SQL Stored Procedure. To certain level you could use legacy technologies, such as Great Plains Modifier with Continuum for VB, VBA scripting, etc.

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 developer

---

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

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

OS 101: Suggestions for Choosing an Operating System

An operating system (abbreviated OS) is essentially the path through... Read More

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

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

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

20 Extra Hours Per Week: What Would You Do?

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

Marketing Your WinRunner Team

It won't matter how effective your WinRunner Team is if... Read More

Microsoft and Webmasters

Does Microsoft care for WebmastersIt's always been a problem with... Read More

QuarkXpress Tips: How to Move Content Between Print and Web Layouts

Since its release in 1987, QuarkXpress had made an immediate... Read More

Groupware and Version History: Collaboration Series #1

This article is the first of a series of articles... 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 Recovery & Upgrade for Large Corporation

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

Microsoft Great Plains - Microsoft RMS Integration ? overview

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

Professional XP Style Icons in Software and Website Development

Using professional icons in your application or website can bring... Read More

Business Plan Software Review: Ultimate Business Planner?

One of the main reasons business owners and entrepreneurs use... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

Microsoft CRM Customization - Processing In/Out-Going Email Messages

We would like to give you several situations, when you... Read More

Adware and Spyware Blockers

The most important things you can do for your computer... Read More

Microsoft CRM for Corporate Business ? Working Offline

If your company has regional and worldwide operations, you might... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... 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 Great Plains Data Conversion ? Overview For Developer

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

Who?s Watching What You Type?

If someone entered your home, uninvited and installed numerous cameras... Read More

The True Meaning of Freeware

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

Corel WordPerfect 7 Macro Programming Example

Case study: A secretary using Corel WordPerfect 7 is often... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Microsoft CRM Implementation ? Fundamental CRM Principles Revision

Microsoft CRM is relatively new player on the now becoming... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More