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


Best Spyware Removers

Finding the best spyware removers to detect and remove spyware... Read More

Reduce TCO: The Java Database Way

TCO (Total Cost Ownership) is the buzzword in... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... 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

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

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

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

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

Free Software - Powerful Alternatives to Budget-Busting Software

When you buy a computer, it most likely comes with... Read More

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

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

Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

We would like first emphasize the change in the paradigm.... Read More

Great Plains Customization Upgrade? Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Top Questions to Ask Before Buying a Help Desk & Asset Management Software

#5 All your hardware components like Printers, PCs etc come... Read More

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

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

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

Cross-Platform Custom Software Development & Integration ? IT Strategy for Large Corporation

Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

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

Backing Up And Restoring Your MySQL Database

If you've been using MySQL database to store your important... Read More

Navision Attain Database access via C/ODBC in ASP.NET Application

Navision Software was purchased by Microsoft and now it is... Read More

Does your Company have Documentum?

Are you lost in the mess of documents that get... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More