Skip to content

Logistics and distribution

Epicor BisTrack and DMSi Agility: what dealers can export before a change

By SourceX Editorial · Updated

Short answer

A BisTrack data export, like an export from DMSi Agility, should capture a lumber and building materials dealer's line-level history before any system change: quotes, sales orders, delivery tickets, takeoffs, returns, customer and job notes, and pricing. Reports alone break the link between a quote and the delivered job, so export detail records with their codes intact.

Key takeaways

  • An acquirer's ERP conversion usually moves customers, items, open orders and balances, not years of closed quotes and deliveries.
  • The job or project reference is the key that links a dealer's quotes, orders, deliveries and returns, so it must survive the export.
  • Takeoff outputs are usually the dealer's work, while the builder's plans and drawings belong to others.
  • Ask the vendor about hosting, export tools, attachments and post-termination access before the change date is set.
  • Decide in the purchase agreement who keeps the legacy archive and who may use it.

Why a system change puts dealer history at risk#

A system change puts dealer history at risk because conversions are scoped for running the business tomorrow, not for keeping what happened yesterday. When a regional consolidator buys an independent yard, the usual plan is to move customers, items, price lists, open orders and receivables into the acquirer's ERP and switch the old system off.

Closed quotes, delivered orders, returns and job notes often stay behind. If the old system is hosted by the vendor, access can end with the subscription; if it runs on the dealer's own servers, the hardware and the people who understood it tend to disappear after integration.

Epicor BisTrack and DMSi Agility are both widely used by LBM dealers, but they are different products from different vendors, with different export tools and contract terms. The checklist below applies to both; the vendor-specific details have to come from your own agreement and the vendor's documentation.

What should a dealer export? The checklist#

A dealer should export every record family that connects a customer request to what was delivered and what came back. Keep the keys in the right-hand column on every row, because those references are what let an archive answer questions later.

What should a dealer export? The checklist
Record familyWhy it mattersKeys to keep
Quotes and bidsShow what builders asked for and how the dealer priced it, including lost bidsQuote number, customer, job, salesperson
Sales ordersRecord what was actually bought and any changes after the quoteOrder number, quote reference, job, branch
Delivery tickets and proof of deliveryShow what reached the site, when, and any shortages or damageTicket number, order, truck, delivery date
Takeoffs and estimatesCapture estimators' material lists built from plansTakeoff ID, job, plan reference, estimator
Returns and creditsExplain over-ordering, wrong product and damaged loadsCredit number, original order, reason code
Special orders and purchase ordersLink customer needs to supplier orders and lead timesPO number, sales order, vendor
Customer and job notesHold context such as site access, builder preferences and disputesCustomer, job, author, date
Pricing and contract termsShow builder-specific pricing and how it changedCustomer, item group, effective dates
Inventory adjustmentsRecord shrink, cycle counts and yard correctionsItem, branch, adjustment reason
  1. 01Your work records
  2. 02Personal details removed
  3. 03You approve the release
  4. 04Licensed to AI developers
How it works with SourceX: Your work records → Personal details removed → You approve the release → Licensed to AI developers.Illustrative

What to ask your BisTrack or Agility vendor#

The vendor conversation should happen before the change date is fixed, because the answers decide how much time the export needs. Put the questions in writing and keep the replies with the project file.

Questions worth asking include:

Dealers that grew through acquisitions should also ask how branches and legal entities are separated in the database. If several yards share one system but belong to different companies, each company's history may need its own export, and only the entity being sold should hand its records to the buyer.

  • Is our system hosted by the vendor, a partner or our own IT, and who holds the database?
  • Which built-in tools export line-level history, and do they have row or date limits?
  • Can our team or a consultant query the database directly, and does the agreement allow it?
  • How are attachments such as signed delivery tickets, photos and plan files stored, and can they be exported in bulk?
  • What conversion or archive services does the vendor offer, and what do they include?
  • How long does data remain accessible after termination, and in what form will it be returned?

Takeoffs and plan files need separate handling#

Takeoffs and plan files need separate handling because they mix the dealer's work with documents created by others. A takeoff, the material list an estimator builds from a set of plans, reflects the dealer's expertise and pricing judgment. The plans themselves usually come from an architect, designer or builder and remain their work.

In practice, export takeoff outputs as data, with job and plan references, and keep plan files in a separate folder marked as third-party documents. If the records are ever reviewed for licensing, the takeoff outputs may be in scope after builder and homeowner details are removed, while the plans are typically excluded.

Delivery tickets raise a similar issue in a different form. They often carry homeowner names, site addresses and contractor phone numbers, so plan to code or remove those fields before any analysis outside the business.

Choosing an archive approach#

The right archive approach depends on the deal and on who will need the history later. A seller that keeps a copy, an acquirer that inherits the system and a dealer that is simply changing vendors face different questions.

Choosing an archive approach
SituationPractical archive approachPoint to settle
Stock sale to a consolidatorHistory stays with the company; export before cutover so it survives the conversionWhether sellers may keep a copy for tax or disputes
Asset sale of the yardList the legacy data among purchased or excluded assetsWho owns, stores and may use the archive
Vendor change with no saleFull line-level export to company-controlled storage plus a short read-only periodPost-termination access and fees
Branch closure within a groupExport the branch history before its codes are retiredWhich entity's records the branch history belongs to

Illustrative: a family dealer exports before an acquisition closes#

Illustrative: a fictional family-owned LBM dealer runs yards and a small truss shop and agrees to sell to a regional consolidator that uses a different ERP. The dealer's system runs on servers in its main office, and estimators keep takeoffs in an estimating module linked to jobs.

During diligence the CFO asks who will keep the legacy history. The purchase agreement confirms the history stays with the company, but the conversion plan covers only open orders, receivables, customers and items. The IT lead exports quotes, orders, deliveries, returns, takeoff outputs and job notes, with all codes and job references, to company-controlled storage, and keeps plan files in a separate folder.

After closing, the new owner's team uses the archive to answer builder disputes about past deliveries and to study which bids the yard won and lost. The former owners keep a copy limited to financial records, as the agreement allows.

Preparing dealer history for a licensing review#

Dealer history can interest AI developers because quotes, takeoffs, deliveries and returns record skilled human decisions in building materials work. Under the SourceX Enterprise Data Value Framework, domain expertise, human-generated signal and recency raise value, while privacy burden and preparation cost reduce net value.

SourceX starts with metadata only, such as systems, years of history and record families, and follows the SourceX five-step transaction: Supply, Rights, Preparation, Approval and Delivery. The SourceX Evidence Packet records provenance, licensing rights, permitted use, the privacy record and release authorization, which matters when the history changed hands in an acquisition.

Frequently asked questions

Do we need the vendor's permission to export our own data?

Usually you can export your own business data, but how you do it may be governed by the software agreement. Direct database access, third-party tools or bulk extraction can be restricted. Read the agreement's sections on customer data, permitted use and termination, and ask the vendor if anything is unclear.

Will the acquirer's conversion include our history?

Often only partly. Conversions are usually scoped to open orders, balances, customers, items and pricing. Ask the acquirer's integration team exactly which records and date ranges will move, and plan a separate export for anything that will not.

What about signed delivery tickets and photos?

Treat them as part of the archive. Signed tickets and delivery photos help settle disputes and show what reached the site. Ask whether they are stored in the system, a document module or a separate tool, and export them with the ticket number so they stay linked to the order.

Should we export before or after signing the purchase agreement?

Plan the export before signing so the agreement can say who keeps the history, and run it before cutover so nothing is lost in the conversion. Many sellers start inventory and test exports during diligence, then take a final export just before the switch.

How do we check that the export is complete?

Compare the export with the live system before it is switched off. Match counts of quotes, orders, delivery tickets and credits by branch and year against the system's own reports, spot-check a few jobs end to end from quote to return, and confirm every code in the data appears in the exported code tables.

Related resources

See if your company qualifies

A short company assessment. No data uploads are needed.

See if your company qualifies