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

---

An Introduction to .NET Framework

.Net Framework is a platform or development environment to seamlessly... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

Why Stick With Email Clients Like Outlook?

Trying to figure out a stream in banning one email... Read More

Helping Newbies Understand Professional Software

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

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

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

20 Extra Hours Per Week: What Would You Do?

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

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

Twelve Things You Should Know to Save on Computer Software

Do you want to get quality software at a reasonable... Read More

Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Microsoft Great Plains Customization Tools ? Overview

Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

Dashboard Widgets for Windows

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

Microsoft Blues

With the advent of 'Service Pack 2' for Windows XP... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

Save Your Resources - Combine Your IM Clients

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

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great... Read More

Microsoft Great Plains Upgrade ? Things to Consider and FAQ

If you have Microsoft Great Plains and support it for... Read More

C++ Function Templates

C++ Function templates are those functions which can handle different... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

Reporting Tools for Microsoft Great Plains ? Overview For Developers

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

netstat - Linux Command to Display Networking Information

In linux, one of great commands for finding out information... Read More

Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

In our small article we'll consider Microsoft Business Solutions Great... Read More

Great Plains Dexterity History and Programming Overview

As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

Story Development Software: Good or Evil?

In the early days of the personal computer, we're talking... Read More

ERP Consulting: Microsoft Great Plains Partner Future Directions

In the Clinton era the status quo was simple: you... Read More

Linux ? Keyboard Or Mouse

Just stress testing one of the latest Linux distributions. Been... Read More

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

1. What determines the software price? Is it Per Seat... Read More