Filters and options in the Goods on the Way report
A reference guide to filtering and customizing the Goods on the Way report for your needs.
Jul 11, 2026
Available filters
| Filter Name | Description | Example Use |
|---|---|---|
| Vendor Name | Filter to show items on order from a specific supplier. | Show all items on order from "Acme Distributors." |
| Warehouse / Location | Limit results to items expected at a specific warehouse or storage location. | Show items expected at the Kabul warehouse only. |
| Product / Item Code | Search for a specific item or SKU. | Find the status of item code "WIDGET-001." |
| Product Category | Filter by the product category (e.g., Raw Materials, Finished Goods). | Show only raw materials in transit. |
| Expected Receipt Date Range | Show items expected to arrive within a specific date range. | Show items expected to arrive this week. |
| Purchase Order Date Range | Filter by when the purchase order was placed. | Show orders placed in the last 30 days. |
| Purchase Order Number | Search for items on a specific purchase order. | Find all items on PO #12345. |
| Outstanding Quantity > 0 | Show only items with quantities still pending (most common filter). | See what still needs to arrive. |
| Item Status | Filter by item status (e.g., On Order, Partially Received, Overdue). | Show only overdue items. |
| Currency | Filter by the currency of the purchase order. | Show items ordered in USD. |
Common filter combinations
Scenario 1: Check what's arriving this week
- Set Expected Receipt Date Range = "This Week"
- Run the report to prepare warehouse staff for incoming deliveries.
Scenario 2: Find all items from a specific vendor
- Set Vendor Name = "Your Vendor Name"
- Run the report to monitor a single supplier's open orders.
Scenario 3: Identify overdue items
- Set Item Status = "Overdue"
- Or manually set Expected Receipt Date Range to dates in the past
- Run the report to follow up with vendors on late deliveries.
Scenario 4: Track items by warehouse
- Set Warehouse = "Warehouse A"
- Set Outstanding Quantity > 0
- Run the report to see all pending deliveries to a specific location.
Scenario 5: Monitor raw materials in transit
- Set Product Category = "Raw Materials"
- Set Outstanding Quantity > 0
- Run the report to ensure you have visibility into incoming materials for production.
Report display options
Some reports allow you to customize how results are displayed (these vary by system configuration):
- Sort by — Choose the column to sort by (e.g., Expected Receipt Date, Vendor Name, Outstanding Quantity). Click a column header to toggle sort direction. (Sorting by Expected Receipt Date helps you see items arriving soonest.)
- Rows per page — Choose how many item rows to display per page (e.g., 10, 25, 50, 100).
- Column visibility — Some reports let you hide or show specific columns (e.g., hide Purchase Order Date if not needed, show Received Quantity to track partial arrivals).
Combining filters (AND logic)
When you apply multiple filters, the report uses AND logic. For example:
- Filter 1: Vendor Name = "Acme Distributors"
- Filter 2: Warehouse = "Kabul"
- Result: Show only items ordered from Acme Distributors that are expected at the Kabul warehouse.
If you need items from Acme Distributors OR from another vendor, you cannot achieve this with a single filter set. Instead, run two separate reports and combine the results.
Clearing filters
To remove all filters and see all goods in transit again:
- Look for a Clear Filters or Reset button (usually near the filter panel).
- Click it to restore the unfiltered view.
- Re-run the report.
Tips for effective filtering
- Always filter for Outstanding Quantity > 0. This excludes fully received purchase orders so you see only items still in transit.
- Sort by Expected Receipt Date. This makes it easy to identify items arriving soon and items that are overdue.
- Use Vendor filters to monitor specific suppliers. If a vendor frequently ships late, you can track their orders separately.
- Combine with warehouse filters if you manage multiple locations. This keeps your report focused on one facility at a time.
See also: "Running the Goods on the Way report" and "Reading and interpreting the Goods on the Way report".
Was this helpful?