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
![]() |
|
![]() |
|
![]() |
|
![]() |
Finding the best spyware removers to detect and remove spyware... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Assertion facility is added in J2SE 1.4. In order to... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
New post-recession era has new features, which didn't exist in... Read More
If you have been running Windows XP for a couple... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
When reading an article where some term is used often,... Read More
After almost two decades of existence, Quark has become the... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
There are certain pluses and minuses in both cases and... Read More
When you buy a computer, it most likely comes with... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
We would like first emphasize the change in the paradigm.... Read More
Around the same time Microsoft made its move with .Net... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
While I was preparing some personal background information for a... Read More
If you have Microsoft Great Plains and support it for... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Crystal Reports is the most flexible tool on the market... Read More
There are plenty of articles out there about how to... Read More
If you've been using MySQL database to store your important... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Are you lost in the mess of documents that get... Read More
If you have been using the Internet for any amount... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Music downloads are off the charts! We're listening to digital... Read More
We all already got used to computer monitoring both at... Read More
An integral part of any quality CRM system is lead... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
Stealing company information used to be the specialty of spies... Read More
We'll give you non formal view, based on our consulting... Read More
The Internet is reshaping every form of communications medium, and... Read More
Anti-virus software is used to find, remove or fix files... Read More
The research in the field of Natural Language Processing usually... Read More
Enabling Chinese input is quick and easy, there are only... Read More
Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More
There are several kinds of software piracy. The bottom line... Read More
I like my software simple. If it's too complex or... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
While paper labeling CDs and DVDs may appear to be... Read More
In the early days of the personal computer, we're talking... Read More
(1) Avoid using the same variable again and again for... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
In a previous article, I wrote about OpenOffice... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
I have yet to see a business that, sometimes in... Read More
Words we choose to describe things and phenomena often show... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
If you look back to the history, you will see... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
User interfaces and accessibility are some of the most important... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
Software |