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


Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Blind CC (Bcc): Master Its Use When E-Mailing

If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

Lotus Domino: Application Integration ? A Programmer View

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

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Preventive Maintenance Software Companies

Several software companies design programs for preventive maintenance. Most of... Read More

Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative... Read More

Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

Microsoft Business Solutions Great Plains has substantial market share and... Read More

Microsoft Great Plains Jewelry ? Implementation & Customization Overview

Each Industry and market niche has business specific and unique... Read More

Navision Attain C/ODBC Crystal Report ? Customization Example

Microsoft Business Solutions Navision is main ERP application for European,... Read More

SSH (SCP) Send Files from Windows to Your Linux Box

Not all of us have the luxury of working both... Read More

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

Microsoft Great Plains Remote Support - Overview

Microsoft Great Plains is now standard mid-market ERP application, serving... Read More

Things You Can Do With Windows XP!

Did you ever give a thought to the number of... Read More

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example

Microsoft Great Plains fits to majority of horizontals and retail... Read More

Think Of This

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

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More

C++ Tutorial 2, Input and Variables

This is the tutorial where we really get into programming.... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More

Know Linux

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

How to Choose the BEST Charting Software

I suggest that you do not spend a lot of... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

Microsoft Great Plains is main Microsoft Business Solutions accounting package... 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

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software

1. What determines the software price? Is it Per Seat... Read More