Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

Microsoft Great Plains might be considered as ERP platform to build your own custom solution upon or as the assembly place for the existing modules. Microsoft Great Plains has Inventory Control (IV), Bill of Materials (BM), Manufacturing modules, coming from Microsoft Business Solutions directly, plus it has third party solutions, such as Horizon Light Manufacturing. In Food Processing industry, however the manufacturing itself is so-called process manufacturing, where with variable input you have variable output. It is opposite to discrete manufacturing, where you expect exact number of parts to be assembled into exact number of finished products. In our opinion ? you should first understand your options to automate business processes and if Manufacturing module is absolute must ? only then you should purchase manufacturing and implement it. Let's give you some highlights:

? Variable Input Unit Weight. You still have to count input units, but in parallel with this you should use Pounds (US) or Kilograms (Europe, Australia, Canada). This means that Great Plains should give you catch weight routine. You can purchase simple catch weight module from existing Microsoft Great Plains partner and tune it, using Great Plains Dexterity, Modifier with VBA and SQL Server scripts. We saw the requirements when Food Processor has to control weight variations to prevent theft and issues like that. In this case you tract average weight of the input item. This is classical Dexterity routine. As this catch weight system becomes your light manufacturing application ? you will need MRP reporting ? use Crystal Reports to cover your reporting needs, our recommendation is to create SQL views and stored procedures for your Crystal Report

? Repetitive Customer Orders. If you are food processing company ? you probably have fixed number of permanent customers ? grocery stores, food retail chains, restaurants and each permanent client orders the same set of products on the regular basis. You should have so-called Order-Pad with historical customer typical order components, where you just verify quantities.

? EDI. In the case of large grocery stores you may need Electronic Document Interchange (EDI). The easiest way to create it in Great Plains ? export SOP orders via EDI fixed-length-position SQL formatted query. You can have it as SQL routine to export Customer orders into text file and forward it to the customer through EDI channel.

? eOrder. Smaller customers (Restaurant, Specialty food outlet) are willing to place internet orders. In Microsoft Great Plains you could deploy eOrder to sell on existing account.

We encourage you to analyze your alternatives. You can always appeal to our help, give us a call: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies (http://www.albaspectrum.com), serving Microsoft Great Plains, CRM, Navision to mid-size and large clients in California, Illinois, New York, Georgia, Florida, Texas, Arizona, Washington, Minnesota, Ohio, Michigan, UK, Canada, Brazil. Mexico

In The News:


pen paper and inkwell


cat break through


Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

Microsoft Great Plains SOP: Sales Order Processing

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

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Spyware: What It Is and How to Combat It

Spyware is software or hardware installed on a computer without... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

How To Choose A Fire Wall Software Program

In the real world a "fire wall" is a fireproof... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

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

Microsoft C# vs. VB.Net

Hi, Guys,I believe a lot of programmers are trying to... Read More

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

Software Piracy - Global Increase

Pirated software is on the increase and now accounts for... Read More

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

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

Create ASP in Minutes

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

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

A few months back I really got sick of my... 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 Inventory Control ? Overview For Consultant

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

Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Artificial Intelligence And Intuition

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

The Software 2005 Conference - A Review

The Software 2005 conference is now a wrap. This conference,... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

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

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Story Development Software: Good or Evil?

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

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Monitoring Software Can be Used for Spying as Well

We all already got used to computer monitoring both at... Read More

Putting Screensavers Under Control

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

Do You Want Your Own Fully Programmable ERP? - Part 1

We are in a transition phase in the Managerial Administration... Read More

Microsoft Business Solutions Partner ? How to Launch New IT Consulting Practice

In the new era of internet marketing the problem of... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable... Read More