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

---

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

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

Five Reasons for Using an O/R Mapping Tool

So, why should you use any O/R mapping tool? I... Read More

Great Plains Dexterity Customization Options ? Overview For Developers

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

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

How to Make Attractive and Effective PowerPoint Presentations

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

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

Lowering The Risks In Developing Do-It-Yourself Software Projects

Mike Dunville* had a decision to make. As the new... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Microsoft Great Plains Integrations ? Retail Management Sample

Microsoft Business Solutions is emerging as very attractive vendor for... Read More

Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

Microsoft Great Plains might be considered as ERP platform to... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no... Read More

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

Microsoft Business Solutions Partner ? How to Launch New IT Consulting Practice

In the new era of internet marketing the problem of... Read More

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... Read More

History of Java

The java programming language is becoming more and more popular... Read More

C++ Tutorials: 3, Program Flow (If, Else, While, For)

Program Flow is what you think it is. How the... Read More

Microsoft CRM ? Typical Customizations

Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More

Snort for Network IDS

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

Change Your Word Docs in Record Time!

Anyone who has ever used Microsoft Word knows that it... Read More

Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

Microsoft Great Plains serves majority of US based horizontal and... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Microsoft CRM for Corporate Business ? Working Offline

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

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist

Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More

MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software

MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More