About the order manufacture picklist report
The Order Manufacture Picklist Report shows the current and projected stock levels for all materials required to produce all products for a specific order or multiple orders within a specified date range. This report is useful for checking how many products can be made to fulfill orders using the current stock available and also allows you to make better purchasing decisions.
This report is available in STUDIO+ plans.
In this article:
- How to find this report
- How to generate a picklist for a specific order
- How to generate a picklist for all orders within a time period
- Factoring in your on hand product stock
- How to run the report
- What information is available in this report?
How to find this report
Navigate to the Reports area, then click on the Order Manufacture Picklist report under the Orders heading.
How to generate a picklist for a specific order
You can filter this report to view data for a specific order by entering the order code in the field in the top left corner. This will return all materials required to create all products within the specified order.
How to generate a picklist for all orders within a time period
To generate a picklist for all orders within a specific time period, select the date range from the Placed Date filter. This filter will return all materials required to create all products for all orders in the date range.
Factoring in your available on hand product
If you'd like, you can also exclude existing product stock from the report results so that the report only tallies quantities of materials for product that needs to be made. To factor in current product stock, ensure that you have the Exclude On Hand Product checkbox selected in the filter area.
As a simple example, let's say you have an order for 3 x product ("Product A"). Product A requires a quantity of 2 units of a material ("Material A") to create. The product currently has 2 units in stock.
Selecting the Exclude On Hand Product checkbox would calculate the amount for Material A required as 4 as only 1 additional unit needs to be made to fulfill this order.
Unselecting the checkbox would change this calculation to 6 as it will not factor in the existing stock on hand and will assume all manufactures need to be created.
How to run the report
Once you make your filter selections, click Run Report.
What information is available in this report?
SKU | The SKU for the material required. |
---|---|
Name | The name of the material required. |
Before Available | The total quantity available of the material before the projected manufactures required to fulfil the order(s) are factored in. |
Required | The total quantity available of the material required to make the specified products in the order(s). If the Exclude On Hand Product is checked in the filter, the required amount will factor in any existing product stock (see above for an example). |
After Remaining | The total quantity available of the material after all products in the order(s) have been manufactured. This calculation is: Before Available - Required = After Remaining. i.e. If the Exclude On Hand Product is checked in the filter, this calculation will only show the remaining material stock after the required manufactures. |
This report can be downloaded as a print-friendly PDF or as a CSV for further analysis in a spreadsheet.