The Attivo Blog

QuickBooks Enterprise Suite Version 10 has some basic manufacturing assembly capabilities, many manufacturers find that they need more advanced inventory, purchasing and manufacturing planning capabilities than what QuickBooks Manufacturing offers. One of the best solutions out there for extending QuickBooks for Planning and Manufacturing is MiSYS Small Business Manufacturing Software. Here are some of the key reasons why MiSYS might make sense for you: Flexible and easy to use MRP. Using MiSYS MRP, you can consider the sales orders and inventory quantity on hand in QB during it's recommendations without having to rekey that data into MiSYS. MiSYS MRP also lets you use inventory forecasts during Material Planning before generating MRP so it can consider actual and planned demand. When MRP makes 'buy' or 'make' recommendations you can control what quantity MRP will recommend based on: - 'Never' means never automatically recommend to build this item meaning you control the planning for this item - 'Zero' means build enough to meet current demand. - 'Minimum' means build enough to maintain the minimum quantity on hand defined for this item. - 'Reorder' means build enough to reach the reorder qty defined for this item Link Sales Orders to Mfg. Orders: If you are a make to order environment you can link Manufacturing orders to a QB sales order during the MRP run for manufacturing. The quantity produced will then be transferred to QB and automatically fulfill this sales order. Raw Material Consumption: MiSYS gives you the choice when it comes to raw material consumption on a BOM. Raw materials can either be consumed per planned quantity of the parent or by actual quantity of parent produced. Costing Choices: MiSYS supports Average, Standard, LIFO and FIFO costs, while QBES only supports Average Cost. Add/Change Components: Manufacturing orders give you the flexibility to make one-time changes to what is being manufactured whether it is raw material quantities or adding additional raw materials. Scrap Transactions: You can also record scrap transactions against manufacturing orders to more accurately reflect what materials and quantities were actually consumed during the manufacturing process. Download a FREE trial Version and try it for yourself.  You can either use the demo data included with the trial version, or you may create your own company with up to 100 inventory items.  MiSYS offers free online demonstrations, and excellent training sessions to get you started.  And as experts with MiSYS Manufacturing software, Attivo can help you complete your implementation and provide the local consulting and support that you need.

QuickBooks doesn't do manufacturing, does it? Well, kind of. It does have a basic bill of materials, which will consume components and create a parent item. But that's where it stops. Intuit QuickBooks Pro, QuickBooks Premier or QuickBooks Enterprise Suite have never been known as robust manufacturing solutions. Manufacturing Systems Designed to Work with QuickBooks First, I should tell you that our company, The Attivo Group, is an Intuit Solution Provider, and that we sell and support QuickBooks Enterprise Suite.  We also sell and support several tier 2 ERP (Enterprise Resource Planning) systems such as Microsoft Dynamics GP and Exact Macola.  These are wonderfully capable systems, but may be more expensive or overly complex for the smaller, $1-10 million manufacturer. The reason I wanted to point this out is to help small manufacturers understand that they should implement good planning and control systems, but they shouldn't overspend to achieve the goal. Fortunately, there are several great software applications that are designed to work with QuickBooks to support manufacturing needs.   Here's the great part - you don't have to disturb your accounting department to implement them!  There might be some small process changes to deal with, but no major overhaul of your entire business.  This is like remodeling the house without ripping out the kitchen or either of the bathrooms. The key is understanding those requirements, and choosing the right solution.  Although it might seem like there are a lot of software choices, the choices are narrowed when specific requirements are considered.  First, narrow the field with basic choices, by identifying the type of manufacturing support that you need, such as:                     -  Make to order                     -  Configure to order                     -  Make to stock                     -  Process Manufacturing, etc. Then, consider unique requirements such as compliance needs, serial or lot traceability, project management needs, labor tracking, outside processing or other needs.  Each application provides a different set of functions, and in some cases are designed to support particular types of industries.  So get some help on determining your needs before you start looking - or you will be looking for a while, since there are over 100 options out there.  Some of the more widely used applications are (click on them for more information):

• Fishbowl Inventory
• MISys Manufacturing
• Exact JobBOSS
• Exact MAX
• AdvancePro

Check out the Intuit Marketplace, and see for yourself.  There is a lot of good software out there to manage your operations.  Our experience is that most of the $1-10 million manufacturers are using QuickBooks for accounting, and Excel for everything else, as tedious as that is.  Even though Microsoft Excel is a great application, it's time to put in an easy to use system that can really save your company time and money.  And you don't have to throw QuickBooks out to do it!