# How to Export an Indented (Multi-Level) BOM from SyteLine

> Source: https://netray.co/erp-help/syteline-how-to-export-indented-bom-to-excel
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

You can get an indented BOM out of SyteLine three ways: run the BOM report with the multi-level option and export it, use the grid export on the job material or BOM form for single levels, or run a recursive SQL query against the BOM tables for a full multi-level explosion. The SQL route is the most reliable for many parents at once.

## Kind

how-to

## System

syteline

## Erp

Infor SyteLine (CloudSuite Industrial)

## Module

Engineering / Bill of Material

## Query

how to export an indented bom from syteline

## Alternate Queries

- syteline multi level bom to excel
- syteline bom explosion sql
- syteline export bill of material csv

## Applies To

Infor SyteLine 8.x and CloudSuite Industrial (CSI) on SQL Server; table and column names should be verified against your version before use

## Steps

### How to export a multi-level BOM

**Items:**

- Decide scope: one parent item, a family, or every active parent. Single parents suit the application; large exports suit SQL.
- In the application, open the BOM or bill of material report from the forms list, choose the item and set the option to explode all levels if available, then send output to a file or Excel through report options.
- For a quick single-level list, open the BOM maintenance form for the item, use the grid's export to Excel option and repeat for each sub-assembly.
- For a full explosion, run a recursive query on a reporting copy or with read-only access (sample below), adjusting names to your version.
- Include the fields you need: level, parent, component, quantity per, unit of measure, scrap, effective dates and operation number.
- Save to CSV or paste into Excel, then check a known assembly by hand to confirm the quantities and levels.
- Decide how to treat phantoms, alternates and effectivity so the export matches what planning actually uses.

## Sections

### How SyteLine stores the BOM

**Body:**

SyteLine keeps manufacturing BOM data in the job structures: a standard job holds the material lines in the job material table and the operations in the job route table, and each item points to its standard job. Because of that, a BOM export is a join between the item and its standard job material, and a multi-level export is that join repeated for each component that has its own standard job.

Always query through the site views where your installation uses multi-site tables, and filter by site. Querying the base tables across sites can mix data and produce duplicates.

### Sample recursive query

**Body:**

The following sketch shows the idea. It starts from one parent, walks its components and multiplies quantities by level. Verify column names against your schema, and add filters for effective dates and for the site. Treat it as a starting point, not a drop-in script.

Add a cycle guard in real use: a BOM that refers back to itself will loop. Limit recursion depth with OPTION (MAXRECURSION n) and investigate any item that hits the limit.

**Code:**

WITH bom AS (
  SELECT 0 AS lvl, i.item AS parent, m.item AS component,
         m.matl_qty AS qty_per, CAST(m.matl_qty AS decimal(28,8)) AS ext_qty,
         i2.job AS child_job, i2.suffix AS child_suffix
  FROM item i
  JOIN jobmatl m ON m.job = i.job AND m.suffix = i.suffix
  LEFT JOIN item i2 ON i2.item = m.item
  WHERE i.item = 'PARENT-ITEM'
  UNION ALL
  SELECT b.lvl + 1, b.component, m.item, m.matl_qty,
         CAST(b.ext_qty * m.matl_qty AS decimal(28,8)),
         i3.job, i3.suffix
  FROM bom b
  JOIN jobmatl m ON m.job = b.child_job AND m.suffix = b.child_suffix
  LEFT JOIN item i3 ON i3.item = m.item
)
SELECT lvl, parent, component, qty_per, ext_qty FROM bom
ORDER BY lvl, parent, component
OPTION (MAXRECURSION 20);

### Making the export trustworthy

**Body:**

A BOM export is only useful if it matches what planning uses. Decide how to handle phantom assemblies (pass through), alternate components, scrap and effective dates. If you ignore effectivity you will export obsolete components alongside current ones.

Reconcile a few assemblies against the application's own display, and compare totals such as the number of distinct components. Exports are often used for costing and for PLM comparison, where small errors compound.

## Pitfalls

- Querying across sites without a site filter and getting duplicate lines.
- Ignoring effective dates and exporting obsolete components.
- Forgetting a recursion limit and looping on a circular BOM.
- Treating phantoms as real stocked assemblies in cost roll-ups.
- Running heavy queries against the live transactional database during working hours.

## Ai Angle

Writing and checking recursive BOM queries is a good task for SyteRay: it can generate the explosion for your version, flag circular references and items without a standard job, and explain the result. It works read-only, shows the SQL it ran and can run on-prem so engineering data never leaves your network.

## Faq

### Does SyteLine have a built-in indented BOM report?

**Answer:** There are BOM reports with multi-level options, and the available forms vary by version and customization. Search the forms list for bill of material reports and test with a known assembly.

### How do I get a multi-level BOM into Excel?

**Answer:** Export a report to file or Excel from the report options, or run a recursive SQL query and save the results as CSV. SQL is better for large numbers of parents.

### Where is the BOM stored in SyteLine?

**Answer:** In the job material and job route tables of standard jobs, which the item record points to. Verify table and column names against your version.

### Is it safe to run the query on production?

**Answer:** Prefer a reporting copy or off-hours with read-only access. Recursive queries on large BOMs can be heavy, so test with a limited scope first.

## Search terms

how to export an indented bom from syteline, syteline indented bom, syteline multi level bom, syteline bom to excel, syteline bom sql query, syteline jobmatl bom, csi bill of material export, syteline bom explosion

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json