The Quantity (Qty) column in BOM Insight includes two numbers separated by a forward slash (/) character. The quantity shown on the left is your original requested quantity. The quantity number shown to the right of the slash is the corresponding orderable quantity based on Min and Mult values.
If you imported or configured multiple quantity fields then those quantities will be stacked vertically within the same Qty cell. Each multiple will also have it's own corresponding orderable quantity.
Using 0 Quantities
It is possible to set the quantity to zero ("0") if you do not want to have the IPN/CPNs cost factored into the BOM. This can be useful for tracking parts for analytical or preparatory purposes without impacting the cost of the BOM. Items with a Qty of "0" are excluded from the Total Cost but still appear in the UI or export.
You may consider zeroing out these "placeholder" IPN/CPNs so that you can track substitute parts or optional parts that you are not planning on pricing with the BOM.
When uploading your list, blank quantities will default the Qty to 1. It is only when the file explicitly has "0" in the Qty field that it will keep it as "0". This ensures that the system maintains consistency and accuracy in BOM processes.
Mapped Quantities
You can update your mapped quantities for a part at any time by clicking into the Quantity cell. Type in the new desired Requested Qty and then click Save.
Multipliers
When using Multipliers, you will only be able to update your original mapped requested quantity per (Quantity 1) within that cell. You can change your entire BOM’s Multipliers by clicking on Project and then Settings.
Within the Multipliers field, type in the updated comma separated multipliers for this BOM and then click on Refresh list with new settings.
Requested versus Orderable Quantity
In the Quantity (Qty) column, your original requested quantity will be on the left and its corresponding orderable quantity to the right. The orderable Quantity is based on the minimum order quantity (MOQ) for the part number, the standard package quantity (Mult) and your requested quantity. When the line item’s Min or Mult are missing, then the orderable Quantity = requested Quantity.
Orderable Quantity Calculation
In the industry, it is common practice not to consider the Minimum Order Quantity (MOQ aka Min) once the Request Quantity exceeds the Min. In such cases, the Orderable Quantity is calculated solely based on the Multiple (Mult) and then rounded to the nearest valid quantity, without factoring in the MOQ.
When the Requested Quantity is below the Minimum Order Quantity, Supplyframe will calculate the Orderable Qty by rounding up to the nearest Mult (aka Package Qty) required to cover the Requested Qty.
- When Req. Qty is < MIN, the Orderable Qty = MIN
- When Req. Qty is > MIN , Orderable Qty = roundup to nearest Mult
Maximum Quantity
The maximum allowable quantity is 200 trillion or 200,000,000,000,000 (2e14) to provide flexibility in managing large-scale inventory data. If you manually enter higher values, then an error message will state the maximum quantity limit and guide you to input quantities less than 2e14.