Skip to content

Manufacturing

JobBOSS and JobBOSS² data: export and licensing guide

By SourceX Editorial · Updated

Short answer

A JobBOSS data export should capture the full quote-to-ship history, not just open orders: quotes, sales orders, jobs, routings, time tickets, purchase orders, shipments and quality records, each with its original numbers so the records can be joined again. Estimated versus actual time by operation is usually the most useful part. Customer drawings and export-controlled jobs stay out.

Key takeaways

  • Keep original quote, order, job, operation and PO numbers in every export so the records can be joined again later.
  • Estimated versus actual hours by operation is usually the most useful history in a job shop ERP, for your own estimating and for AI developers.
  • How the shop used the system matters as much as how long: operation-level labor, closed jobs and lost quotes marked as lost decide how much history holds up.
  • Customer-owned drawings, models and export-controlled work are excluded before any licensing discussion begins.
  • A SourceX fit check collects metadata such as version, years of history and record families; no files leave the shop.

What does JobBOSS actually store?#

JobBOSS stores the operating history of a job shop from the first quote to the final invoice. Classic JobBOSS and JobBOSS² both organize that history around a few anchors: the quote number, the sales order, the job number, the part number and the operation sequence on each routing. Almost every other record points back to one of them.

The table below is a working record map. Module names and field labels vary by version and by how your shop configured the system, so treat it as a checklist to confirm with whoever administers your install, not as a database schema.

What does JobBOSS actually store?
Record familyWhat it capturesAnchor to keepLicensing note
Quotes and estimatesQuantities, material, operations, setup and run estimates, outside processing, quoted priceQuote number, part numberCore history; won and lost quotes both matter
Sales ordersOrder lines, due dates, promised ship dates, change historyOrder number, quote referenceCustomer names coded before licensing
Jobs and routingsOperations, work centers, sequence, estimated hours, job statusJob number, operation sequenceCore history; the plan side of estimate versus actual
Time tickets and laborActual setup and run time by operation, employee and dateJob number, operation, employee IDEmployee names pseudonymized; pay rates usually removed
Material and purchasingMaterial requirements, purchase orders, receipts, vendor promise datesPO number, job numberVendor pricing may be confidential under supplier terms
Shipping and invoicingPacking lists, shipments, partial shipments, invoicesPacking list and invoice numbersShows delivery performance against promised dates
Quality recordsNonconformances, scrap, rework and inspection notes where trackedJob number, NCR referenceValuable when linked to the job and the fix
AttachmentsCustomer drawings, models, certifications, travelersFile path tied to job or partCustomer drawings excluded; certifications reviewed case by case

A usable JobBOSS export keeps every record family with its original identifiers, so a quote can still be joined to its job, the job to its time tickets and the job to its shipment. Built-in reports are convenient, but they tend to flatten those links, so most shops pair report exports with a full database copy made by IT or their software provider.

Treat the export as a project with a named owner, not a favor from the one person who knows the system. The steps below work for most installs.

  • Confirm the product and deployment: classic JobBOSS or JobBOSS², on-premises or hosted, and how many years of history the live database still holds.
  • Ask IT or your software provider for a full database backup, then confirm it can be restored on a different machine.
  • Export each record family to flat files such as CSV, keeping quote, order, job, operation, part and PO numbers as columns.
  • Export the lookup tables: work centers, operation codes, customer and vendor codes, part masters, employee IDs and status codes.
  • Copy the attachments folder separately and keep the path that ties each file to its job or part.
  • Check the export: compare record counts by year with the live system and confirm that a few closed jobs still join from quote to shipment.
  • Write down what was exported, when, by whom and from which version, and store the set in company-owned storage.

Does JobBOSS² change the export path?#

JobBOSS² usually changes where your history lives more than what the history is. Shops that have run more than one of these products, for example classic JobBOSS or E2 Shop System before JobBOSS², may have older history in a retired database, newer history in the current system, and a conversion in between that carried some records but not others.

Hosted deployments add a contract question. If the vendor or a partner runs the database, your ability to get a full copy depends on your agreement and the vendor's documentation, not on what the screens allow. Read the data return and termination terms before you plan a migration or cancel support.

Look for that older database before anyone wipes the old server. It often holds the deepest estimate-versus-actual history the shop has, and its codes may differ from today's, so export its lookup tables too.

Which JobBOSS records hold up best?#

The JobBOSS records that hold up best are closed jobs whose routing, time tickets and shipment are all present, because together they show estimate against actual, operation by operation. A quote says a part needs a certain setup and run time on a given work center; the time tickets say what it took; job notes often say why the two differ.

Years in the system matter less than how the shop used it. The checks below need only the person who knows the database, and they tell you which years are worth exporting carefully and which need a note in the coverage log. AI developers building quoting and scheduling tools look for the same plan-versus-actual pairing, which public data rarely shows.

Which JobBOSS records hold up best?
Habit to checkWhy it mattersHow to check
Labor posted by operation, not as a lump sum per jobOnly operation-level actuals line up with routing estimatesOpen a sample of closed jobs and look for time on each routing step
Lost quotes closed with a statusLost quotes show prices and lead times the market turned downCount quotes by status for each year
Jobs closed with final costsJobs left open carry incomplete actualsList old jobs still open or closed in bulk
Routings updated when the work changedRoutings copied forward unchanged make estimates look worse than they wereCompare repeat-part routings with job notes
Stable work center and operation codesRenamed codes need a mapping, or years cannot be comparedCompare lookup tables from different years

What to leave out: customer drawings, controlled work and pricing terms#

Customer drawings and models attached to quotes and jobs are left out of a JobBOSS data license because they belong to the customer, not the shop. Purchase order terms and NDAs commonly limit their use to quoting and making that customer's parts.

Export-controlled work needs its own pass, and it reaches further than the drawing. Under the ITAR, technical data includes information required to design, manufacture, assemble, repair, test or modify a defense article, including blueprints, drawings, plans and instructions. A routing, setup sheet or job note for a defense part can therefore be controlled even with the drawing removed. Jobs tied to ITAR- or EAR-controlled programs are identified with whoever handles export compliance and removed whole, with their routings and notes. The rest of the preparation list is shorter but just as firm.

  • Customer drawings, models and specifications stored as attachments or linked files.
  • Jobs, parts and notes tied to export-controlled programs.
  • Customer names and contacts, replaced with consistent codes.
  • Employee names on time tickets, replaced with pseudonymous IDs, and individual pay rates.
  • Negotiated pricing covered by customer or supplier confidentiality terms.

Illustrative: scoping a job shop's JobBOSS archive#

Illustrative: the fictional owner of a contract machining shop wants to know what part of a long JobBOSS history could be licensed. The office manager fills in the record map above with the person who administers the database and finds three complications.

Older quotes live in estimating spreadsheets rather than in JobBOSS. Labor was posted by operation only after data collection terminals went onto the floor; before that, time was booked to the job as a whole. And the attachments folder mixes customer drawings with the shop's own travelers and setup sheets. One long-standing customer is a defense prime whose jobs carry export-control markings.

The owner sets a narrow scope: quotes, jobs, routings, time tickets and shipments from the years with operation-level labor, for commercial customers only. Spreadsheet quotes are matched to JobBOSS job numbers where possible and listed as excluded where not. The whole attachments folder stays out, because sorting drawings from travelers file by file is not worth the risk, and every job for the defense customer is removed with its notes. Employee names become IDs and pay rates are dropped. The shop then requests a metadata-only fit check describing that scope, while the export stays on its own server.

How SourceX handles a JobBOSS archive#

SourceX treats a JobBOSS archive as one supplier package moving through the SourceX five-step transaction: Supply, Rights, Preparation, Approval and Delivery. During Supply, the fit check asks for the version, years of history, record families and known restrictions, never the files themselves.

If the shop proceeds, preparation strips customer drawings, controlled jobs and personal details, and the owner approves the final scope before Delivery. The records are licensed, not sold, so the shop keeps ownership, and large archives stay on the shop's own storage or ship on encrypted drives. A SourceX Evidence Packet records provenance, licensing rights, permitted use, the privacy record and release authorization for the package.

Typical fit is a company with 50+ full-time employees at peak and several years of operating history. Smaller specialized shops may be reviewed when a buyer requests a specific kind of record.

Frequently asked questions

Can we still export JobBOSS data if our support plan has lapsed?

For an on-premises install, the data usually remains in your own database after support lapses, and IT can typically back it up. Hosted setups depend on your agreement with the vendor or partner. Confirm your export rights in writing before you cancel anything or change servers.

Do we need the whole database, or are report exports enough?

Keep both if you can. A full database backup preserves every table and relationship, while report exports stay readable without the software. Reports alone often drop identifiers and notes, which makes it hard to rebuild estimate-versus-actual history later.

Would licensing JobBOSS data expose our pricing to competitors?

The risk can be kept low when scope and terms are set carefully. Customer names are coded, negotiated pricing under confidentiality terms is removed or banded, and the license can restrict use, ban redistribution and require deletion at the end of the term. You approve the scope before anything is delivered, and you can leave out any part family or customer you consider too sensitive.

How much history is worth keeping?

Keep all of it if you can store it securely. Longer history shows how estimating changed as machines, materials and staff changed. Even years with inconsistent routings can be useful once the lookup tables and code changes are documented alongside the export.

Do quality records in JobBOSS count?

Yes, when they link to jobs. Scrap, rework and nonconformance entries tied to a job number show what went wrong and what it cost in time. If quality lives in a separate QMS or spreadsheet, note where, so those records can be joined by job or part number later.

Sources

  • 22 CFR 120.33(a)(1) defines ITAR technical data to include information, other than software, required for the design, development, production, manufacture, assembly, operation, repair, testing, maintenance or modification of defense articles, including blueprints, drawings, photographs, plans, instructions or documentation. Source

Related resources

See if your company qualifies

A short company assessment. No data uploads are needed.

See if you qualify