Software for formula manufacturing

One of the greatest misconceptions in the software industry is that manufacturing software is manufacturing software and that there are no differences in manufacturing products on the market. That is not true – let me share my perspective on the landscape.
I typically break the market into a couple sectors – much like Gartner and the like will do. I keep my categories simple – Big, Medium and Small. Big > $750 million in sales, Medium $150-750 million in sales and small $5 – 150 million in sales.
In the Big and Medium camp you have the typical very good and very expensive applications such as SAP, Oracle, Infor (many options), Ross and the like. These companies typically need outside independent consultants to assist them in the selection and it is worth every penny.
The real confusion comes in the Small sized company - $5 – 150 million in sales. While I do not have statistics to back this up I think this is the largest part of our market – at least in the US – and they have the least resources. They tend to be forced to rely on software vendors to assist in the selection process. As such there is much misinformation being spun to this group of users.
I will attempt to put some applications into groupings and give my perspective on what to look for in each grouping. To keep it simple I have limited the groups to three.

Assembly posing as formula/batch

All-in-one

Everything but financials

Extension to larger standard ERP solution

Assembly posing as formula/batch -First let me get the assembly applications out of the way first. This is a group of applications that have found very stiff competition in the assembly/discrete world and have moved over to batch/formula manufacturing where they see more potential market share. Typically they are easy to point out and are often eliminated by the trained eye. Here are a couple signs. Does their web site spend as much time talking as much time about BOMs, routings and subassemplies as they do recipes, compliance documents and intermediates? Do you see MSDS or Nutritional Analysis prominently displayed on the site? If not move on – you will spend more time customizing an assembly application than you will gaining benefit. Today there are plenty good vertical applications that do exactly what you need. Some examples include Macola, MAS90 and Dynamics Manufacturing – each are well suited for assemblers but not necessarily formula/batch manufacturing.
All-in-One – Through the 1980's and 1990's this model really was the standard. This is an application that was written specifically for an industry and hand tailiored to that industry. It will look and feel like your industry and will be feature rich and very deep in functionality. For the first couple years of usage you will feel great. The primary drawback of this approach is that it does not talk to any other application and they are the only ones doing the development for your solution. Sure you can export data to excel and manipulate it into other applications but that is a bit different than being able to pick from a myriad of solutions to solve unique challenges. Additionally these applications are typically written to fill as specific need such as Lab Analysis, MSDS, Scheduling or Formula Management. They will be strong is certain areas and very weak in others – such as financial analysis or business intelligence. This is largely caused by limited resources and the resources they do have know the technical aspects of the industry and not the broader ever-changing business issues impacting your business. The risk of this solution is in the unknown. How will they handle electronic payment of payables (common in the EU)? How will they handle web orders if you choose to go there? How will they broaden their sales order processing to handle export orders and all the paperwork associated with that business. Some examples include Deacom (although really assembly but have made a reasonable attempt at batch), ProcessPro and Syspro. Biggest benefit – it is a one stop shop for software. Biggest drawback – if the store does not have what you want after purchase – tough.
Everything but financials – This group amazes me. These are applications written specifically for the industry and have stopped short of being an All-in-One by attaching themselves to the core financials of many ERP systems. This model has tightly integrated data within their own functionality such as formula management, inventory control and compliance. When it comes to integrating with financials (GL, AP and AR) the integration is relatively weak. Normally there simple transactions sent to AP to pay the inventory invoices or transactions to AR to track outstanding receivables. All this is great until you want to perform analysis on costs from the GL and flow back into production. Because the transaction is foreign to the financial system (GP, AP, AR) it will not be able to make the jump to the source document (sales order, purchase order or batch ticket). This is often frustrating for users. Like All-in-One there are no other resources developing for this implementation. So if EDI becomes an issue for you after purchase you really only have one option with this group. As well if your financial application changes you are dependent on this group to keep up to speed with the changes. Now the part that amazes me is this. These applications tend to work with any and every financial solution on the market and claim to be tightly integrated with each. Logic tells you that can't be the truth. It is the old saying – "If you say it loud enough and often enough it becomes the truth". Not so. The prime application doing this today is Batchmaster (the one owned by eWorkplace). Biggest benefit – most of the software is written by one company. Biggest drawback – that one company may be trying to service far too many markets.
Extension to larger standard ERP solution – This is where the trend seems to be today. It is similar to the Everything but financials group with more reliance on the ERP solution for core business processes. In this model the application handles only the parts of your business that is truly unique – MSDS, scheduling by formula, formula management. It is not trying to handle order entry, purchasing, inventory or financials. The groups doing this are highly focused on the formula manufacturing parts of the solution and leave the routine transactions to the standard ERP solution. The reason this is a new development is that ERP solutions have gotten to a place in technology where they can accept third party applications into their suite of offerings. This was a huge technology change that began in the late 1990s and really picked up speed in the early 2000s . Now it is common place for software developers to leverage the work done by very large ERP developers and focus on what they do best. Some examples include Vicinity (Dynamics GP, SL and NAV), O2/EscapeVelocity (MAS500), JustFoodERP (Dynamics NAV), and Fullscope (Dynamics AX). Biggest benefit – significant resources are in both standard ERP and vertical requirements. Biggest drawback – upgrades need to be coordinated by your local reseller.
In 1,500 words or less I have attempted to group the software solutions for you. Each has merits to consider. Each has legacy to look into. For my money I would look for the solution that addresses your needs today, is easy to use and has the ability to change as your business changes around the corner.