Supplier orders are a great way of using Inventory Requests to track and manage inventory reorders/purchase orders for newly built inventory.
To get details about how many orders were placed or how much was ordered in a given timeframe, check out our reporting section using the steps below:
Navigate to the Reports page
Scroll down to the Movements Section
Open the "Inventory Requests by User Report"
Next, select the following filters:
This report shows all of the items requested within those parameters you set, meaning each request is listed potentially multiple times (once for each item # on the request), but we can use this to get the info you're looking for. Our recommendation would be to download this report and use the "Remove Duplicates" function in Excel to narrow it down to one row per Request ID, then you can get a count of how many requests there are.
Export the report by clicking on the Tile Actions menu, by hovering over the top right corner of the chart. Then click "Download Data".
Select your file type and open the advanced data options
Select the following download settings:
Once you've downloaded your file, open it up in Excel.
Click on the Remove Duplicates button. In a Mac version of Excel this is located in the Data toolbar.
Select the column to remove duplicates based on the "Request ID" column
Now you'll have a list of all of the requests by request ID (any duplicates of the request ID will be gone) and you can just total a count for the column to get the amount of requests sent in the time period.