> For the complete documentation index, see [llms.txt](https://docs.silkline.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.silkline.ai/orders/line-items.md).

# Line Items

Use the Line Items view to search, filter, sort, and group all line items by buyer, supplier, status, ETA, and receipt status for material planning

Silkline's **Line Items** view provides a single place to track all line items. This can be helpful for material planning workflows.

Line items can be searched, sorted, filtered, and grouped based on various attributes.

## Filters

<table><thead><tr><th width="191">Filter</th><th width="476">Comments</th></tr></thead><tbody><tr><td>Buyer</td><td>Filter by one or more buyers</td></tr><tr><td>Supplier</td><td>Filter by one or more suppliers</td></tr><tr><td>Status</td><td>Filter on the workflow step of line items</td></tr><tr><td>Requester</td><td>Filter by one or more requesters</td></tr><tr><td>Receipt status</td><td><p>Filter by receipt status:</p><ul><li><strong>DRAFT</strong> – order has not been sent to the supplier yet</li><li><strong>OPEN</strong> – quantity received is 0</li><li><strong>PARTIAL</strong> – quantity received is greater than 0 but less than the quantity ordered</li><li><strong>COMPLETE</strong> – quantity received is equal to the quantity ordered, or the line is closed</li><li><strong>CANCELED</strong> – order was canceled</li><li><strong>NONE</strong> – item is not receivable (no material or NonReceivable material type)</li></ul><p>See <a href="https://docs.silkline.ai/orders/track-receipts.md#receipt-status-reference">Receipt Status Reference</a> for full details.</p></td></tr><tr><td>ETA before</td><td>Filter on line items with an ETA before a specified given. You can also select from preset options of 15, 30, 60, or 90 days from now.</td></tr><tr><td>Inventory Type</td><td>Filter by the inventory type of the line's part — <strong>Inventory</strong>, <strong>Non-Inventory</strong>, or <strong>Non-Receivable</strong>. Useful for narrowing a late-lines view to the inventory parts that gate clear to build. Lines with no part match every "is not" selection.</td></tr><tr><td>Order Created</td><td>Filter on line items whose order was created within a date range. Either end of the range can be left open.</td></tr><tr><td>Closed status</td><td>Filter on whether a line has been closed — Closed or Open. See <a href="https://docs.silkline.ai/orders/track-receipts.md#closing-individual-lines">Closing individual lines</a>.</td></tr></tbody></table>

### Narrow a view to inventory line items

Inventory parts are the ones that gate clear to build, so a late-lines view is often more useful once it is limited to them.

{% stepper %}
{% step %}

### Open Filters and pick Inventory Type

**Inventory Type** sits under **General**. Tick **Inventory**, **Non-Inventory**, or **Non-Receivable** — ticking several matches any of them.

<figure><img src="https://2684497859-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwPsevXC0g5kNMF7GTyPN%2Fuploads%2Fgit-blob-768ec036f2c1fc12d0552e95c5e6dc37baf3d570%2Fline-items-inventory-type-filter.png?alt=media" alt="The Inventory Type filter open under the General category, showing the Inventory, Non-Inventory, and Non-Receivable options"><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Combine it with your other filters

The chip joins the rest of the filter tray, so an existing late-lines view keeps its ETA and status filters and simply drops to the matching parts. Switch the chip to **is not** to exclude a type instead; lines with no part match every "is not" selection.
{% endstep %}

{% step %}

### Show the Inventory Type column

The column is hidden until you turn it on. Open **Columns**, search for *Inventory*, and tick **Inventory Type**. It then sorts like any other column and is included when you export the view to CSV.

<figure><img src="https://2684497859-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwPsevXC0g5kNMF7GTyPN%2Fuploads%2Fgit-blob-7ac00b23a58b459a57aa70501ec58644ade1e72e%2Fline-items-inventory-type-column.png?alt=media" alt="The Columns panel filtered to Inventory Type, with its checkbox unticked"><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

When a filter is applied, the filters button will show a green dot to remind users:

<div align="left"><figure><img src="https://2684497859-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwPsevXC0g5kNMF7GTyPN%2Fuploads%2Fgit-blob-a3e3d504de775fb46ddc64f224019d1b2717ea9d%2FScreenshot%202025-02-23%20at%209.01.39%E2%80%AFAM.png?alt=media" alt="" width="100"><figcaption></figcaption></figure></div>

## Columns

<table><thead><tr><th width="191">Filter</th><th width="476">Comments</th></tr></thead><tbody><tr><td>Supplier</td><td>The supplier of an order / line item</td></tr><tr><td>Item</td><td>The part or description for the line item</td></tr><tr><td>Qty</td><td>The quantity ordered</td></tr><tr><td>Unit of Measure</td><td>The unit of measure for the part associated with a line item</td></tr><tr><td>Qty Received</td><td>The quantity received</td></tr><tr><td>Qty Remaining</td><td>The quantity ordered less the quantity received, or 0 once the line is closed regardless of how much was actually received</td></tr><tr><td>Receipt Status</td><td><ul><li><strong>DRAFT</strong> – order has not been sent to the supplier yet</li><li><strong>OPEN</strong> – quantity received is 0</li><li><strong>PARTIAL</strong> – quantity received is greater than 0 but less than the quantity ordered</li><li><strong>COMPLETE</strong> – quantity received is equal to the quantity ordered, or the line is closed</li><li><strong>CANCELED</strong> – order was canceled</li><li><strong>NONE</strong> – item is not receivable (no material or NonReceivable material type)</li></ul><p>See <a href="https://docs.silkline.ai/orders/track-receipts.md#receipt-status-reference">Receipt Status Reference</a> for full details.</p></td></tr><tr><td>Unit Price</td><td>The unit price of the line item</td></tr><tr><td>ETA</td><td>The estimated delivery date of the line item</td></tr><tr><td>Need Date</td><td>The need date of the line item (or the promise date or contractual delivery date)</td></tr><tr><td>Billed</td><td>The accounting date of the most recent bill against the line item, when your billing integration provides one. Shows N/A until a bill has been synced for the line.</td></tr><tr><td>Order</td><td>The order number</td></tr><tr><td>Line</td><td>The line number</td></tr><tr><td>Status</td><td>The workflow timeline tracker for the line item. Hover over this to see a detailed list of workflow steps. Shows a disabled "Closed" badge instead while the line is closed.</td></tr><tr><td>Buyer</td><td>The buyer of an order / line item</td></tr><tr><td>Requester</td><td>The requester of an order / line item</td></tr><tr><td>Inventory Type</td><td>The inventory type of the line's part — Inventory, Non-Inventory, or Non-Receivable. Blank for lines with no part.</td></tr><tr><td>Last Updated</td><td>The date the line item was last updated</td></tr><tr><td>Created</td><td>The date the line item was created</td></tr><tr><td>Order Created</td><td>The date the line item's order was created</td></tr></tbody></table>

## Grouping

Grouping helps to visually organize data by a certain dimension, such as supplier or need date. For example, you might want to group by supplier to see all of a supplier's open lines. Alternatively, you might group by need date to see which items are coming due in the next week.

In the line items view, you can group on these dimmensions:

* Supplier
* Item
* ETA
* Need Date
* Order
* Buyer
* Requester

Each group sits under a header row that names its value, and the grouped column leaves the table while the grouping is on. For most dimensions the header also states how many lines the group holds across all pages, and a group that runs past the bottom of a page continues on the next.

## Export to CSV

You can export the current line items view to a CSV file. This can be particularly useful for material planning workflows like a clear-to-build report where you need to marry procurement data with BOM data including make parts. The exported CSV retains the columns and filtering of the view.

<div align="left"><figure><img src="https://2684497859-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FwPsevXC0g5kNMF7GTyPN%2Fuploads%2Fgit-blob-42ef294167302a6f44dab63f201af193d1b8647c%2FScreenshot%202025-02-23%20at%209.02.17%E2%80%AFAM.png?alt=media" alt="" width="46"><figcaption></figcaption></figure></div>
