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
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.
When a filter is applied, the filters button will show a green dot to remind users:

Columns
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?

