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
![]() |
|
![]() |
|
![]() |
|
![]() |
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Usually, the easiest way to tell you have spyware is... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Each Industry and market niche has business specific and unique... Read More
Microsoft Business Solutions Navision is main ERP application for European,... Read More
Not all of us have the luxury of working both... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
Did you ever give a thought to the number of... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
Think of this, first we had the HAM Radio, then... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
This is the tutorial where we really get into programming.... Read More
Now there are Three Steps To Heaven Just listen and... Read More
We would like to give you pluses and minuses of... Read More
Microsoft Business Solutions is now in process of creating so... Read More
Linux essentials:It's free for download but you have to pay... Read More
I suggest that you do not spend a lot of... Read More
With any good luck and a good amount of hard... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
1. What determines the software price? Is it Per Seat... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
Looking at all the ads which promise to get rid... Read More
(1) Avoid using the same variable again and again for... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
The world of small business accounting software can be a... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
When you visit department stores and see that majority of... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
Need software to record your voice, streaming audio or musical... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
It is really interesting that a bug can create problem... Read More
Many Webmasters have never bothered to view their website's server... Read More
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
The Internet is reshaping every form of communications medium, and... Read More
There are plenty of articles out there about how to... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
While paper labeling CDs and DVDs may appear to be... Read More
What is Groupware?Have you ever had to manage document collaboration... Read More
Best Software Act! is very popular CRM for small and... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
An integral part of any quality CRM system is lead... Read More
Whether you are a small consultancy firm, a medium sized... Read More
One of the main reasons business owners and entrepreneurs use... Read More
In this short FAQ style article we would like to... Read More
IntroductionDuring the early years of our modern computer era, very... Read More
We all already got used to computer monitoring both at... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
The Windows Indexing Service provides you with the ability to... Read More
Software |