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.
| Record family | Why it matters | Keys to keep |
|---|---|---|
| Quotes and bids | Show what builders asked for and how the dealer priced it, including lost bids | Quote number, customer, job, salesperson |
| Sales orders | Record what was actually bought and any changes after the quote | Order number, quote reference, job, branch |
| Delivery tickets and proof of delivery | Show what reached the site, when, and any shortages or damage | Ticket number, order, truck, delivery date |
| Takeoffs and estimates | Capture estimators' material lists built from plans | Takeoff ID, job, plan reference, estimator |
| Returns and credits | Explain over-ordering, wrong product and damaged loads | Credit number, original order, reason code |
| Special orders and purchase orders | Link customer needs to supplier orders and lead times | PO number, sales order, vendor |
| Customer and job notes | Hold context such as site access, builder preferences and disputes | Customer, job, author, date |
| Pricing and contract terms | Show builder-specific pricing and how it changed | Customer, item group, effective dates |
| Inventory adjustments | Record shrink, cycle counts and yard corrections | Item, branch, adjustment reason |
- 01Your work records
- 02Personal details removed
- 03You approve the release
- 04Licensed to AI developers
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.
| Situation | Practical archive approach | Point to settle |
|---|---|---|
| Stock sale to a consolidator | History stays with the company; export before cutover so it survives the conversion | Whether sellers may keep a copy for tax or disputes |
| Asset sale of the yard | List the legacy data among purchased or excluded assets | Who owns, stores and may use the archive |
| Vendor change with no sale | Full line-level export to company-controlled storage plus a short read-only period | Post-termination access and fees |
| Branch closure within a group | Export the branch history before its codes are retired | Which 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
- QuestionCan SaaS data be licensed?
- QuestionWhat data is most valuable to AI labs right now?
- InsightMaintenance-mode software products: what their engineering histories hold
- InsightRecords written with AI assistance: do they lose value for licensing?
- InsightAI disruption and software valuations in 2026: does proprietary data help?
- IndustryBPO & contact centers data
See if your company qualifies
A short company assessment. No data uploads are needed.