The Limitations of QuickBooks for Manufacturers and Distributors

Mark Munson - ACE Micro

Mark Munson, President

In this post, we will explore why Horizon Stone made the decision to move off of QuickBooks and onto a solution that better served their needs,

Warehouse pallet of goods

Background: Horizon Stone manufactures high-quality, long-lasting stone veneers that add value to residential and commercial projects. However, their current accounting system, QuickBooks, did not provide them with the necessary tools to accurately track raw materials consumption and finish good inventory, including serial numbers. As a result, Horizon Stone was limited in their ability to maintain the high quality of their products and meet the needs of their customers. Some limitations of QuickBooks for manufacturers include:

  • Limited inventory management capabilities: QuickBooks lacks raw material tracking and serialized finished goods management. This is essential for manufacturers to manage production.
  • No support for bills of materials (BOMs): QuickBooks does not have native support for BOMs, which can make it difficult for manufacturers to accurately track raw materials consumption.
  • No support for production scheduling and forecasting: QuickBooks lacks tools for production scheduling/forecasting, making it hard for manufacturers to manage production.
  • Limited reporting capabilities: QuickBooks lacks robust reporting for production metrics like on-time delivery, efficiency, and quality control.

No support for mobile devices: QuickBooks lacks the support for mobile devices on the warehouse floor to manage orders and track serial numbers.

The QuickBooks Replacement Solution

Based on the limitations of QuickBooks and Horizon Stone’s need to get more functionality from their internal accounting system, ACE Micro proposed a two-phase solution:

    1. Replace QuickBooks with Microsoft Dynamics 365 Business Central
    2. Enhance Business Central’s capabilities with apps from Insight Works

Phase One: Integrating Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is a comprehensive enterprise resource planning (ERP) solution that is designed specifically for small and mid-sized businesses, including manufacturers like Horizon Stone. It offers a wide range of features and tools that can help manufacturers manage and optimize their production processes, including:

  • Advanced inventory management: Business Central helps Horizon Stone track raw materials, serialize finished goods, and manage inventory in real-time. It also supports BOMs to track materials and components.
  • Production scheduling and forecasting: Business Central includes built-in tools for production scheduling and forecasting, which helps Horizon Stone plan and manage their production processes more effectively.
  • Robust reporting capabilities: Business Central includes a range of customizable reports that help Horizon Stone track and analyze key production metrics, such as on-time delivery, production efficiency, and quality control.

Phase Two: Fill the Gaps with Warehouse Insight from Insight Works

Dynamics 365 Business Central streamlined Horizon Stone's manufacturing process, but a gap remained in the warehouse. Workers needed an efficient way to pick and ship products, tracking serial numbers for each order. To fill the gap, the Warehouse Insight app from Insight Works was integrated to help manage Horizon Stone’s warehouse process.

One way that Horizon Stone is using the Warehouse Insight app is with Honeywell CK65 mobile computers to pick orders and track serial numbers in Business Central. These mobile computers allow warehouse workers to access Business Central from the warehouse floor and perform warehouse tasks. This can help improve efficiency and accuracy in the warehouse, as workers have access to the necessary information and tools at their fingertips.

Warehouse workers are able to access Business Central pick tickets from the mobile device and fill orders by scanning products, including serial number information, directly into Business Central.

The Results of Replacing QuickBooks

The integration of Business Central with the Warehouse Insight app from Insight Works has enabled Horizon Stone to increase accuracy in their business operations. This is due to the advanced features and tools that Business Central provides for managing and trackWarehouse barcode scanninging production processes, including inventory management, production scheduling, and reporting. Having these controls enables Horizon Stone to maintain the high quality of their products and meet the needs of their customers.

Specific benefits include:

  • Increased accuracy of production data: Horizon Stone now has a greater understanding of its raw materials consumption and yield.
  • Improved quality control: With the integration of Business Central and the Warehouse Insight app from Insight Works, Horizon Stone now has processes in place to report finished goods more accurately and timely.
  • Better tracking: The serialization of finished goods inventory has allowed Horizon Stone to have backwards traceability that was previously impossible.
  • Improved order fulfillment: Horizon Stone has become more strategic in its approach to creating picks and reducing "customer warehousing" in the shipping area.
  • Improved customer service: By having access to more accurate and up-to-date operational data, Horizon Stone now responds more quickly and effectively to customer inquiries and requests, resulting in improved customer service.
  • Reduced errors: Business Central and the Warehouse Insight app reduce errors because the mobile devices will notify workers when wrong materials or inventory items are picked.
  • Better production decisions: Improved visibility into demand, production, and safety stock levels allows Horizon Stone to make more informed and strategic decisions about daily production and warehouse space utilization.

About ACE Micro

ACE Micro, LLC is a professional services firm committed to delivering business solutions to mid-market organizations. They are a Microsoft Partner with expertise in Dynamics 365 Business Central, among other platforms. ACE specializes in serving the lite manufacturing, distribution, and hospitality industries. ACE manages several offices within the southeastern United States.

About Insight Works

Insight Works is an Independent Software Vendor (ISV) that caters to the manufacturing and distribution industry. Their product line features a breadth of end-to-end apps that integrate with Microsoft Dynamics 365 Business Central. There are apps designed for manufacturing, distribution, shipping, sales, productivity, barcoding, and more. Apps are distributed through partners like ACE Micro.

Links to products mentioned:

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.