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

---

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

Microsoft Great Plains RW: Report Writer

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

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Falling in Love With More Than One Screensaver: The Fun Part

Having from five to ten and more favorite screensavers is... Read More

Off The Record - Tips For Picking Recording Software

Need software to record your voice, streaming audio or musical... Read More

Top Questions to Ask Before Buying a Help Desk & Asset Management Software

#5 All your hardware components like Printers, PCs etc come... Read More

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Microsoft Great Plains Partner Selection: Overview

Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

Who?s Watching What You Type?

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

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

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

Theres Gold in Your Websites Server Log

Many Webmasters have never bothered to view their website's server... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

The True Meaning of Freeware

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

Online PowerPoint Presentation ? Convert PowerPoint to Flash

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

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

Instant Messenger Clients

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

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... 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

Inherent Dangers Of File Sharing Via The Internet.

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

Free Software - Powerful Alternatives to Budget-Busting Software

When you buy a computer, it most likely comes with... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Great Plains Customization Upgrade? Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net... Read More

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Accounts Payable: A Powerful Document Management and Workflow Solution

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

Configure Windows Indexing Service for Performance

The Windows Indexing Service provides you with the ability to... Read More

Save Your Resources - Combine Your IM Clients

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

Microsoft CRM Development

Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole... Read More