How To Use the Order as Used Report
List the components each sales order line needs from its bill of materials, with how many have been picked and how many are on hand, to find material that is available but not yet picked.Updated Nov 9 2026
Before you start
- Order As Used is under Sales > Orders and needs the Sales or Engineer role.
- The report shows one row per component of each order line's bill of materials, including lines on closed orders. Check the Status column.
-
Open the report
- Go to Sales > Orders > Order As Used. The list is headed Order As Used and opens with no filters set.
- Each row is one component of one order line: Order, Customer, Loc, Status, Line#, the component (Prcpart), the assembly it goes into (BOM), Start Date and Ship Date, then quantities: Qty per Top, Ord Qty, Net Qty Required, Qty Picked, QOH (on hand), QOO (on order) and Avail (on hand less reserved).
- Click a column heading to sort it (Sort A → Z / Sort Z → A) or hide it.
-
Find unpicked parts that are available
- Click the filter search bar (Filter or search…), pick Short Only and choose Yes. Only components with fewer picked than the order needs are listed.
- Pick Available and choose Yes to keep only components with stock available (No shows those without).
- Pick Non Inventory and choose Exclude to leave out non-inventory parts. The options are All (every part), Only (just non-inventory parts) and Exclude.
- Click Apply (n). The rows left are components that can be picked now.
-
Narrow by order, part or date
- Click the filter search bar (Filter or search…) and pick Customer, Order, Prcpart (a component), BOM (an assembly), Location, Part Revision or Revision Required.
- For dates, pick Start Date or Ship Date and set the range.
- Click Apply (n). To drop a filter, click the × on its chip.
- Click Export below the list to download the rows.