For the complete documentation index, see llms.txt. This page is also available as Markdown.

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

Filter
Comments

Buyer

Filter by one or more buyers

Supplier

Filter by one or more suppliers

Status

Filter on the workflow step of line items

Requester

Filter by one or more requesters

Receipt status

Filter by receipt status:

  • DRAFT – order has not been sent to the supplier yet

  • OPEN – quantity received is 0

  • PARTIAL – quantity received is greater than 0 but less than the quantity ordered

  • COMPLETE – quantity received is equal to the quantity ordered, or the line is closed

  • CANCELED – order was canceled

  • NONE – item is not receivable (no material or NonReceivable material type)

See Receipt Status Reference for full details.

ETA before

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.

Inventory Type

Filter by the inventory type of the line's part — Inventory, Non-Inventory, or Non-Receivable. 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.

Order Created

Filter on line items whose order was created within a date range. Either end of the range can be left open.

Closed status

Filter on whether a line has been closed — Closed or Open. See Closing individual lines.

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.

1

Open Filters and pick Inventory Type

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

The Inventory Type filter open under the General category, showing the Inventory, Non-Inventory, and Non-Receivable options
2

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.

3

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.

The Columns panel filtered to Inventory Type, with its checkbox unticked

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

Columns

Filter
Comments

Supplier

The supplier of an order / line item

Item

The part or description for the line item

Qty

The quantity ordered

Unit of Measure

The unit of measure for the part associated with a line item

Qty Received

The quantity received

Qty Remaining

The quantity ordered less the quantity received, or 0 once the line is closed regardless of how much was actually received

Receipt Status

  • DRAFT – order has not been sent to the supplier yet

  • OPEN – quantity received is 0

  • PARTIAL – quantity received is greater than 0 but less than the quantity ordered

  • COMPLETE – quantity received is equal to the quantity ordered, or the line is closed

  • CANCELED – order was canceled

  • NONE – item is not receivable (no material or NonReceivable material type)

See Receipt Status Reference for full details.

Unit Price

The unit price of the line item

ETA

The estimated delivery date of the line item

Need Date

The need date of the line item (or the promise date or contractual delivery date)

Billed

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.

Order

The order number

Line

The line number

Status

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.

Buyer

The buyer of an order / line item

Requester

The requester of an order / line item

Inventory Type

The inventory type of the line's part — Inventory, Non-Inventory, or Non-Receivable. Blank for lines with no part.

Last Updated

The date the line item was last updated

Created

The date the line item was created

Order Created

The date the line item's order was created

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.

Last updated

Was this helpful?