Skip to content
CASE STUDY

Custom ERP for an HVAC and duct work contractor

An HVAC duct work contractor coordinated sales, warehouse, installation and accounts as separate manual processes, with no shared visibility into stock or driver movement. We built a custom ERP covering sales orders, raw material inventory, project document management, QuickBooks sync and real-time delivery tracking in one system.

CLIENT
An HVAC and duct work contractor
INDUSTRY
HVAC, field service
ENGAGEMENT
Custom ERP development and process automation
STACK
ASP.NET / .NET, SQL Server, jQuery, MVC, QuickBooks integration
THE PROBLEM

Sales, warehouse, installation and accounts each worked from their own disconnected process.

  • No centralized system for managing customers and projects
  • Sales orders and invoices handled separately from inventory
  • Difficulty tracking duct material stock levels across the warehouse
  • Manual document handling for project drawings and compliance files
  • No integration with accounting systems, and limited visibility into driver movement
WHAT WE BUILT

One system, built around how the work actually happens.

01Raw material stock tracked automatically
02Project-based sales and invoicing
03Project drawings and compliance files, centralized
04QuickBooks sync on every invoice
INVENTORY

Raw material stock tracked automatically

Duct sheets, fittings and insulation stock deduct automatically on order confirmation, with low-stock alerts replacing manual warehouse counts.

SALES

Project-based sales and invoicing

Sales order creation, approval workflow and automated invoice generation tied to project-based billing, with real-time order status.

DOCUMENTS

Project drawings and compliance files, centralized

Duct layout drawings, compliance certificates and work orders attach directly to the project record instead of living in separate folders.

ACCOUNTING

QuickBooks sync on every invoice

Invoices synchronize with QuickBooks automatically, with payment tracking and reconciliation handled in the same system.

DELIVERY

Driver and dispatch tracking

Delivery scheduling and driver assignment with status updates from warehouse through to the installation site.

TECHNOLOGIES

What it runs on.

ASP.NET / .NETSQL ServerjQueryMVCQuickBooks integration
OUTCOME

What changed.

  • Centralized management of all duct work projects in one system
  • Faster sales-to-installation workflow
  • Accurate inventory and material planning
  • Reduced accounting errors through QuickBooks sync
  • Real-time visibility into driver movement and order delivery

This page shows no percentages or figures because none have been confirmed by the client for publication. Where a number is not verified, it is left out rather than estimated.

ONGOING VALUE

After go-live.

The ERP became the operational backbone of the business, bringing customers, inventory, finance, documents and driver tracking into one platform that continues to support its expansion.

RELATED SERVICES

The work behind this project.

RELATED INDUSTRIES

Where this work applies.

LET'S TALK

Running into something similar?

Describe what you are dealing with and we will tell you honestly whether this is a pattern we have solved before.

Start a project