Epicor BisTrack

NS90: Migrate:

Epicor BisTrack to NetSuite

Epicor BisTrack to NetSuite, with your units of measure, contractor pricing and rebates intact.

NS90: Migrate extracts BisTrack read-only from on-premises SQL Server or BisTrack in the Cloud, rebuilds products and units of measure, contractor jobs, pricing and rebates in NetSuite, and loads the history you choose with period-by-period trial-balance proof.

Plan my BisTrack migration

See Support Data

Source

Epicor BisTrack (Desktop, Web Browser or BisTrack in the Cloud)

EXTRACTION

Read-only SQL Server on-prem. BisTrack API Smart View queries in the cloud

Building supply data

Products by species, grade and dimension, units of measure, contractor jobs, price matrices and supplier rebates, mapped to NetSuite items, pricing and custom records

DATA DOMAINS

28 supported, including pricing and rebates

Timeline

45-day proof of concept, 90-day go-live

Depth

Options 1 to 4, balances to full history

WHY NOW

Dec 2026

Epicor’s announced final BisTrack Desktop release

Epicor has scheduled the final BisTrack Desktop release, 2026.2, for December 2026, with Active Support through December 31, 2028 and Sustaining Support from January 1, 2029. The last on-premises BisTrack Web Browser and API release, 2028.1, follows in July 2028, with Active Support through June 30, 2029. After that, new BisTrack functionality ships only in the cloud. On-prem BisTrack customers now choose between moving to BisTrack in the Cloud and choosing a new platform. NS90 makes NetSuite a data-safe option.

Source: Epicor announcement, January 2026

// Supported Data Domains

28 Epicor BisTrack data domains, mapped to NetSuite

Each domain maps to a NetSuite target, with the BisTrack source record shown so your team can check coverage against its own data. Domains scoped per project are building supply structures we design with you.

Master data

Transaction

Balances & files

Master data

Customers, vendors, items and the records every transaction depends on.

Customer

Cash and charge accounts → customers

Lien details (scoped per project)

Lien information on customers and jobs → custom fields

Contact

Customer and supplier contacts

Product by branch

Branch stock settings → item locations and reorder points

Branch

Branches → NetSuite locations

Supplier rebates (scoped per project)

Rebate programs and open accruals → custom records and GL accruals

Job / job site

Contractor jobs and job addresses → sub-customers or projects

Supplier

Suppliers and buying groups → vendors

Product

Products by species, grade and dimension → items or matrix items

Unit of measure

Pieces, linear feet, board feet and bundles → unit types

Pricing (scoped per project)

Price lists, matrices and contractor pricing → price levels and customer pricing

Transaction

Sales, purchasing, banking and inventory transactions, with the reference numbers your team knows.

Quote

Quotes and estimates → estimates

Delivery

Delivery tickets and proof of delivery → item fulfillments

Invoice

Charge invoices

Customer payment

Receipts on account

Goods receipt

Receipts → item receipts

Supplier credit

Supplier credits → vendor credits

Journal entry

GL journals

Production order (scoped per project)

Millwork and production orders → work orders

Inventory history (scoped per project)

Stock movements → NSAW, or NetSuite adjustments

Sales order

Sales orders, including special orders

Counter sale

Cash and POS sales → cash sales

Credit / return

Credit notes and returns → credit memos

Purchase order

Purchase orders, including special-order buys

Supplier invoice

Supplier invoices → vendor bills

Supplier payment

Supplier payments

Inventory on hand

Stock by branch and unit of measure → opening inventory tied to GL

Balances & files

Period balances for reconciliation, and the documents attached to your records.

Trial balance

GL by period

Choose your depth

Bring as much Epicor BisTrack history as your business needs

Trial balances are part of every option. Pick how much transaction detail lives in NetSuite and how much stays reportable in NetSuite Analytics Warehouse.

Option 1

Balances

Trial balances only

Monthly trial balances by account and segment loaded to NetSuite. Fastest path to a clean opening position.

Available

Option 2

Balances + drill-down

Trial balances in NetSuite, detail in NSAW

Trial balances in NetSuite with transaction-level drill-down to legacy detail in NetSuite Analytics Warehouse.

Available

Option 3

Open items + history

Masters and open transactions in NetSuite, history in NSAW

Customers, vendors, items and open AR/AP/orders in NetSuite. Every closed transaction stays reportable in NSAW.

Available

Option 4

Full history

Open and closed transactions in NetSuite

The years you choose of closed and open transactions in NetSuite, with automated trial-balance true-up by period.

Available

What to plan for on Prophet 21

The BisTrack details that make or break a migration

These are the BisTrack structures that most often complicate a move to NetSuite. Each is built into how we scope and map a BisTrack migration, so you don’t discover it at UAT.

SQL on-prem, Smart View in the cloud

On-premises BisTrack runs on Microsoft SQL Server, so we extract with a read-only SQL user. For BisTrack in the Cloud, the BisTrack API’s Smart View endpoint runs SQL queries against any dataset. Either way, we never write to BisTrack.

Units of measure are the product

Lumber is bought by the bundle, stocked by the piece and sold by the linear foot or board foot. Every product’s conversions map to NetSuite unit types, and we test them against real BisTrack orders before load.

Species, grade and dimension

BisTrack uses flexible SKU structures to track lumber by species, grade and dimension. We decide with you whether these become NetSuite matrix items, item attributes or separate items before anything loads.

Jobs live under contractor accounts

Contractors buy against job addresses tied to their account, with orders and deliveries linked to each job. Jobs load as NetSuite sub-customers or projects, so job history and balances stay connected.

Lien details travel with the job

BisTrack keeps lien information on customer and job records. We carry it into NetSuite custom fields on the same job, so your credit team keeps what it needs.

Contractor pricing in layers

Negotiated contractor pricing, price matrices and volume tiers drive margin. We resolve the effective price per customer, job and product, rebuild it with NetSuite pricing, and test it against real BisTrack quotes.

Rebates accrue every period

BisTrack accrues supplier and buying-group rebates per period and clears them when checks arrive, across monthly, quarterly and annual programs. We carry open accruals so they tie to the GL, keep program terms as custom records, and keep claim history reportable in NSAW.

Counter sales are a different flow

Cash and POS sales close at the counter, not through AR. Open drawers reconcile at cutover, and counter-sale history stays reportable in NSAW unless you choose full history.

Special orders stay linked

A special order ties a customer order to a purchase order and a receipt. Open special orders migrate with those links intact, so nothing ships to the wrong customer.

Deliveries and proof of delivery

Dispatch, delivery tickets and proof-of-delivery records are operational history. Open deliveries load as NetSuite fulfillments; closed ones stay reportable in NSAW, and your dispatch and fleet integrations are scoped at assessment.

Branch inventory, reconciled

Stock sits by branch and unit of measure. Opening inventory loads by NetSuite location at a cost that reconciles to the BisTrack inventory accounts.

Millwork and production

Production orders and product configurators support millwork and value-added work. Assemblies map to NetSuite assembly items and work orders; configurator rules are scoped per project.

Integrations to rebuild

Web stores, Epicor Commerce, manufacturer quote and order imports, buying-group price files and document management all point at BisTrack. We list each one at assessment, so cutover does not strand a channel.

Find the GL of record first

Some BisTrack sites keep their general ledger in a separate accounting system such as Dynamics GP or QuickBooks. We confirm where the books live and extract financial history from that system, using the same NS90 adapters.

How NS90: Migrate works

From Epicor BisTrack to a reconciled NetSuite in six steps

Every step runs on NS90 Migrate, MHI’s cloud-native migration engine on NSIP and NSAW. It handles extraction, landing, harmonization, parallel loading and trial-balance validation as repeatable jobs, so each rehearsal and the final delta pull run the same way.