Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

Microsoft Business Solutions Great Plains has many years of successful implementation in multiple horizontal markets. In today's small article we'll share our experience of implementing and customizing Microsoft Great Plains, formerly Great Plains eEnterprise/Dynamics in beverage production and distribution industries. These examples will cover two scenarios: US regional distribution and International fruit punch production and sales in US, Latin America and Europe. We'll try to be industry specific and at the same time technical ? using Microsoft Great Plains technical & customization terminology to address both ? decision makers and technical consultant / programmer.

? Concentrate and Output. Usually company sells concentrate to small and mid-size production facilities, where fruit punch or soda is produced and company control the produced volume in Gallons or Liters. In Great Plains you should have light production customization, the natural way is to build it upon Bill of Materials (BM) module. This production is very simple ? you put some labor units and portion of concentrate or powder to produce one Gallon / Liter of punch/soda.

? Marketing Reports. Beverage produces are fiercely competing with each other for the market share. In the case of fruit punch or soda ? competition moves to emerging markets, such as East Europe or Latin / South America. Company has to control sales dynamics via monthly marketing reports, where marketing people can compare sales comparing to the same period of the last year. You have two options ? first is to create data warehouse on SOP30200 and SOP30300 tables (Great Plains Sales Order Processing module) using MS SQL Server Datawarehousing, Cognos or other datamining tool and second ? use set of Crystal Reports. Datawarehousing approach requires user training and might be a bit less precise, Crystal Reports are very precise ? but might be less flexible.

? EDI. Electronic Document Interchange ? in the case of US regional beverage distributor/wholesaler (beer, wine, soda, strong lemonade), we usually see UNIX ordering system, working with EDI orders. In this case Great Plains has to be integrated with this IBM AS/400/RS6000 box and as company manager you should be looking for Microsoft Business Solutions VAR/Partner, who has experience dealing with multiple platforms: UNIX/Linux/Windows/Oracle/Sun Solaris

? Advertisement Expense Allocation. Beverage producer usually launches TV ads on local markets, especially difficult is to track ads efficiency on the emerging markets: Central America, Caribbean, Africa, South East Asia, Russia. You need to establish variable or fixed allocation accounts mechanisms for ads expense tracking

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

Andrew is Great Plains specialist in Alba Spectrum Technologies (http://www.albaspectrum.com) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

In The News:


pen paper and inkwell


cat break through


Huddle Up; Groupware on Three

It could just be me, but my experiences with document... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Putting Screensavers Under Control

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

The Religion And Philosophy Of Small Internet Business

I have always had a tendency to focus on the... Read More

An Easy Way to Develop JAVA Enterprise Applications

Research bears that less than 70 percent of development projects... Read More

Artificial Intelligence And Intuition

The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More

ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses

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

Twelve Things You Should Know to Save on Computer Software

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

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

Microsoft Navision and Crystal Reports - An Overview

Microsoft Business Solutions ? Navision is an integrated solution for... Read More

The Dirt on Screensavers

Remember back in the days where screensavers were the coolest... Read More

5 Mac Security Tips You Can?t Live Without

So, you've bought a new Macintosh, and now you may... Read More

Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

Quick Summary of Basic and Common Linux Commands

There are many commands that are used in linux on... Read More

Hear It in Digits

Music downloads are off the charts! We're listening to digital... Read More

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

Microsoft bought Navision, Denmark based software development company, along with... Read More

Know Linux

Linux essentials:It's free for download but you have to pay... Read More

Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

Increase Office Efficiency With One Simple Tool

When you need a phone number, you do a quick... Read More

Think Of This

Think of this, first we had the HAM Radio, then... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

Great Plains Fixed Assets Management module is a robust tool... Read More

Ukraine: a Prospective Player on the World Software Outsourcing Market

The destruction of the Soviet Union about 15 years ago,... Read More

eConnect: eCommerce Development for Microsoft Great Plains

Microsoft Business Solutions Great Plains has several options to enable... Read More

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

Microsoft Business Solutions CRM is present several years on the... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Photoshop Files and Formats

People often ask me: What image file formats will Photoshop... Read More

Linux Vs. Windows

This article will not attempt to advocate the use of... Read More