In the course of managing your inventory requests, you may end up with partial fulfillments and backorders. The Partially Fulfilled Requests (Backorders) Report can help you to keep track of what partial fulfillments and backorders you still have outstanding.
The Partially Fulfilled Requests (Backorders) Report provides a clear picture of your outstanding request/order fulfillment status. This report presents a table listing all requests that have been partially fulfilled, detailing the items already shipped and the quantities still needed to complete each request.
Available Filters:
- Request Status
- Requested by
- Still Needed?
The report includes line item details of each item and request with a partial fulfillment including: request id, requested by, catalog #/container name, requested product line, qty requested, qty marked received, transferred catalog #, qty transferred, total still needed, transfer IDs.
To export this report data:
- Click Refresh on the report table to apply filters
- Click on the vertical ellipse or Kabob menu that appears when you hover over the upper right corner (Tile Actions)
- Select Download Data
- Choose your File Type
- Change your download settings. The most common download for a .CSV or Excel file should use the following settings. It is critical to use these settings to ensure all of the data is able to export.
- In Results, select "With visualization options applied"
- In Data Values, select "Unformatted (no rounding, special characters, etc.)
- In Number of Rows to Include, select "All Results"
- This is very important as your data set may extend farther than Looker is able to display visually in Beacon, but you want to make sure to export all data.
- Click Download
