BUILT BY DATA Phocas & ERP Analytics Architects
Led by a Former Phocas Senior Implementation Consultant

Unlock the Other 70% of Your Phocas & ERP Data.

Phocas and Epicor Data Analytics (EDA) are fantastic platforms—but because their internal services team is in high demand, custom requests often carry a 4 to 6 week lead time. Whether you need new databases built, custom ERP data added, or Financial Statements & Rebates configured, Built By Data gets it done in days, not months.

All Major ERPs
Epicor, Infor, NetSuite, SAP, Sage, MS
Zero Queue
Direct Senior Architect turnaround
100% Tie-Out
Reconciled to the penny with your ERP
Database Designer • Live ERP Sync
Synced 100%
TRUE NET MARGIN (AFTER VENDOR REBATES & SPAs) +4.8% Identified
$14,820,450 vs. $13.4M Invoice GM
CUSTOM ERP STREAMS
UDFs + BAQs
✓ Open Bids & Quotes
✓ Service & Warranty
FP&A AUTOMATION
Branch P&Ls
✓ Rolling Forecasts
✓ Zero Excel Exports
Why Built By Data? Because I built these systems from the inside as a Phocas Senior Implementation Consultant, there is zero learning curve on your ERP schema or Database Designer architecture.

Hands-On Implementation Experience Across All Major Distribution & Manufacturing ERPs

Epicor Prophet 21 (P21) Epicor Eclipse Epicor Kinetic & BisTrack Epicor Data Analytics (EDA) Infor CloudSuite (CSD / SX.e) Infor SyteLine (CSI) Oracle NetSuite SAP & IFS Microsoft Dynamics & Sage
What We Build & Fix

Where Standard Implementations Stop, Built By Data Begins

Out-of-the-box Phocas content packs are built to get you live quickly—not to reflect the custom nuances of your pricing, rebates, branches, and general ledger.

01

Custom Database Designer & ERP Data Streams

Break free from rigid standard content packs. We architect custom Phocas databases and streams that pull in your custom ERP tables, User Defined Fields (UDFs), Epicor BAQs, and SQL views without breaking your nightly syncs.

  • ✓ Open Quotes, Bids & Backlog tracking
  • ✓ Warehouse KPIs (OTIF, lines picked/hr, backorders)
  • ✓ Multi-ERP harmonization during M&A or migrations
02

Phocas Financial Statements & Budgets (FP&A)

Stop exporting Phocas grids back into Excel every month-end. We map and automate your P&L, Balance Sheet, and Cash Flow statements inside Phocas so they tie out to the penny against your ERP General Ledger.

  • ✓ Automated branch & department P&L statements
  • ✓ Bottom-up sales rep & branch manager budget workflows
  • ✓ Corporate overhead allocations & rolling forecasts
03

Vendor Rebates, SPAs & True Landed Net Margin

In HVAC, plumbing, electrical, and industrial distribution, invoice margin rarely tells the truth. We build automated models for Special Pricing Agreements (SPAs), vendor billbacks, and customer rebates.

  • ✓ True net margin visibility by branch, customer & SKU
  • ✓ Automated Phocas Rebates module rule configuration
  • ✓ Sales commission calculations based on true net profit
04

Role-Based Scorecards & Inventory Optimization

Replace cluttered, orphaned dashboards with high-adoption, role-based scorecards designed specifically for Executives, Branch Managers, Buyers, and Outside Sales Reps.

  • ✓ GMROI, dead-stock aging & seasonal stockout alerts
  • ✓ Customer buying gap analysis & churn alerts
  • ✓ Counter vs. Outside Sales & eCommerce tracking
Featured Client Spotlight • HVAC Wholesale Distribution on Epicor

Transforming an Epicor HVAC Distributor’s Phocas Environment into a Single Source of Truth

Like many wholesale distributors running Epicor, our HVAC client had invested in Phocas but struggled to get custom ERP data into their databases, reconcile complex vendor rebates/SPAs, and automate branch-level financials without heavy manual spreadsheet work.

Custom Database Designer

Integrated custom Epicor tables, UDFs, and BAQs into clean Phocas streams with automated nightly validation.

SPA & Rebate Net Margin

Exposed true landed margin after vendor billbacks and special pricing agreements across all branches.

Financial Statements & Budgets

Automated monthly P&L and Balance Sheet reporting with rolling branch-level budget comparisons.

Executive & Rep Scorecards

Delivered tailored scorecards for leadership, branch managers, and buyers to cut dead stock and boost turns.

Why Clients Choose Built By Data Over Traditional Options

✕
Hiring a Full-Time BI Admin ($120k–$150k/yr):

Expensive overhead, and generalist BI analysts still take 6+ months to learn Phocas Database Designer and ERP tables.

⏳
Standard 4–6 Week Lead Time for Custom Services:

Phocas's Professional Services team is great, but high demand means waiting 4 to 6 weeks just to get custom database builds, new UDFs, or financial mappings scheduled.

✓
Partnering with Built By Data (Days, Not Weeks):

While Phocas Support still handles behind-the-scenes cloud infrastructure, we jump in immediately on all your hands-on Database Designer builds, custom ERP data additions, Financial Statements, Rebates, and Scorecards.

Simple, Transparent Engagement Models

Flexible Ways to Work With Built By Data

Whether you need a one-time audit, a custom Financial/Rebate rollout, or ongoing Fractional Phocas Administration, we tailor our support to your team's bandwidth.

Most Popular Starter

Phocas Health Check & Audit

Ideal if your original Phocas champion left, syncs are slow, or numbers don't match your ERP.

  • ✓ Full audit of Sync logs, SQL/BAQ feeds & Database Designer architecture
  • ✓ Tie-out verification against your ERP General Ledger, Sales & Inventory
  • ✓ Dashboard, scorecard & user permission cleanup
  • ✓ Includes 5 hours of immediate hands-on fixes & optimization
Targeted Build

Custom Expansion Project

Fixed-scope or hourly execution for high-impact Phocas modules and custom ERP data streams.

  • ✓ Rollout of Phocas Financial Statements, Budgets & Forecasts
  • ✓ Vendor Rebates & SPA true net margin implementation
  • ✓ Custom UDF / BAQ / SQL database builds beyond standard EDA packs
  • ✓ M&A branch consolidation or ERP migration data bridging
Ongoing Retainer

Fractional Phocas Admin

Keep a former Phocas Senior Implementation Consultant on your team for a fraction of a full-time hire.

  • ✓ Dedicated monthly hours with priority same/next-day turnaround
  • ✓ On-demand creation of new executive, branch & rep dashboards
  • ✓ Proactive sync monitoring & monthly financial tie-out governance
  • ✓ Live role-based training for sales reps, buyers & managers

Is Your Team Experiencing Any of These Phocas Bottlenecks?

Check any items below that sound familiar—if you check two or more, a 15-minute Architecture Review with Built By Data will immediately save your team hours of frustration:

Ready When You Are

Let’s Take Your Phocas Backlog Off Your Plate

Book a complimentary 15-minute screen-share with a former Phocas Senior Implementation Consultant. Bring your trickiest Database Designer, ERP sync, or Financial Statement question.

© 2026 Built By Data • Tommy Piggee (tommy.piggee@builtbydataanalytics.com • builtbydataanalytics.com)
Independent Consulting Practice • Not affiliated with Phocas Software or Epicor Software Corp.