Home
>
Software
>
Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

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

reliable home cleaners Morton Grove ...

In The News:

ShinyHunters claims it breached FBIJobs.gov and stole Social Security numbers, home addresses and sensitive assignment details of FBI personnel.

Find My iPhone, Google Find Hub and Samsung Find have critical tracking settings to enable now, before your phone ever goes missing or stolen.

The FTC proposed a new enforcement policy on personalized pricing, warning companies that hide how personal data shapes the prices shoppers see.

The $250 million Apple Siri AI settlement is now accepting claims, with eligible iPhone owners potentially receiving up to $95 per device.

ShareAScan turns T-shirts into scannable digital business cards with QR codes that link to profiles the owner can update anytime they choose.

BragJack research reveals how a single malicious browser extension could hijack Gemini, Perplexity Comet and Edge AI agents with zero clicks.

A phishing campaign impersonating OpenAI uses fake ChatGPT billing emails with a convincing login page to steal credentials and payment details.

Startups are helping modernize America’s defense industry with new technology and innovative ideas as the War Department diversifies its inventory.

New account fraud victims jumped 31% in 2025, reaching 5.4 million. Criminals open accounts you may never see on your regular bank statements.

Flytrex says its AI-powered Rooftop Dock system in Dallas-Fort Worth positions drones at restaurants before orders arrive, cutting delivery costs by 60%.

Samson Sky's Switchblade flying car secures $80 million from Dubai's Matin Group, but the redesigned hybrid-electric aircraft still needs more testing.

The Fox News AI Newsletter covers the latest artificial intelligence technology advancements, including the challenges and opportunities AI presents now and for the future.

CenterPoint Energy confirmed customer data was stolen, while a hacker claims 7.49 million records with partial Social Security numbers were taken.

The $59 Brick device promises to help curb phone addiction, but free iPhone and Android tools may already do the job. Here's what to try first.

Epsilon Data Management's "opportunity seeker" lists helped scammers target millions of older Americans, DOJ court filings reveal in detail.

HBO Max's verified Reddit account was hijacked to push 108 malicious ads using ClickFix, a technique that tricks victims into running dangerous commands.

Flash Shelton reveals how home security cameras and alarm systems can stop squatters before they claim tenant rights in your vacant property.

WIM-Z's AI dog training robot uses on-device processing to detect barking and dispense treats autonomously, with field trials showing up to 83% reduction.

Google's Threat Intelligence Group found PROMPTFLUX malware that uses Gemini to rewrite its own code every hour, raising urgent cybersecurity alarms.

Your VPN may quietly drop protection when switching between airport Wi-Fi and hotel Wi-Fi. Key settings like auto-connect and kill switch help.

A South Carolina caregiver allegedly gained power of attorney over a 75-year-old with Parkinson's, then transferred his home via quitclaim deed for $5.

Joby Aviation flew its eVTOL air taxi into DFW Airport's busy airspace as Texas launches Project Nexus, a three-year advanced air mobility program.

Federal prosecutors say criminals bought sponsored search ads mimicking real banks, capturing over 5,000 login credentials and draining accounts.

The Mercedes-Benz eActros 600 electric truck targets 621 miles per charge on a 28,000-mile round-the-world journey through over 30 countries.

A viral video shows roughly a dozen Coco Robotics delivery robots swarming a Chicago sidewalk near Lincoln Park, raising wheelchair access concerns.

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

Software