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

---

Downloading Spyware Removers: Think Before, not After

Just imagine: you are walking, say, towards your car, and... Read More

Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

Many reasons made GBM a unanimous choice for experts, one... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Destination: Desktop for Google

First we had the original Google search that evolved into... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

MCP Market News: Microsoft SQL Server & SQL Reporting Services

Are you ready? SQL Server 2005, the next-generation data management... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management... Read More

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

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

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications... Read More

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

It?s Back!! WordPerfect?s Amazing Comeback

Have you noticed WordPerfect is gearing up for a comeback... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

String in Java

Handling character strings in Java is supported through two final... Read More

Can You Calculate Complex Financial Calculations?

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

EDI: Electronic Document Interchange for Microsoft Great Plains ? Overview for Software Developer/Pr

Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More

Anti-Spyware Protection ? Holes in the Shining Armor

Looking at all the ads which promise to get rid... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... Read More

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays thetasks... Read More

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

Microsoft Great Plains Upgrade ? Version 8.0 Overview for IT Director/Controller

If you have Microsoft Great Plains as main accounting and... Read More

10 Steps To Secure And Manage Your Passwords

Passwords protect your most sensitive personal, financial and business information.... Read More

Secure File Transfer Using SSH Plus Additional Audit & Automation - FSA Reporting

In order to meet regulatory and corporate compliance requirements reporting... Read More

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

Cisco Certification: Introduction To ISDN, Part IV

In part III of this ISDN primer, we learned that... Read More