A purchase run is used to determine what products need to be ordered, and in what quantities. Readysell provides two basic ways to calculate this: by defining minimum and maximum stock levels for a product (Min Max), or by considering average weekly sales.
- For more information on purchase runs, see Generating purchase orders with a purchase run.
- For information on how quantities are calculated, see How order quantities are calculated.
Nett Quantity on Hand calculation:with Stock Allocation on:
this.NetQuantityOnHand = this.QuantityAvailable
- this.QuantityOnSalesBackOrder
- this.QuantityOnLayBy
- this.QuantityOnTransferPick
+ this.QuantityOnOutstandingPurchaseOrders
+ this.QuantityOnTransferIn
+ this.QuantityOnTransferPending;stock allocation off:
this.NetQuantityOnHand = this.QuantityOnHand
- this.QuantityOnSalesBackOrder
- this.QuantityOnLayBy
- this.QuantityOnTransferPick
+ this.QuantityOnOutstandingPurchaseOrders
+ this.QuantityOnTransferIn
+ this.QuantityOnTransferPending;
Product fields
Each product has a number of fields that govern how it behaves in a purchase run. These fields are set on the Products screen. The table below shows how each field is used in a purchase run, and the tab within the Products screen where each one is located.
| Field | What it does | Used in | Tab |
|---|---|---|---|
| Min Reorder Quantity | When the quantity on hand for any product reaches or falls below the value set in the field of 'Min Reorder Quantity', the system will automatically re-order the product in the next appropriate purchase run. Once the Minimum reorder quantity is reached = Maximum Reorder Qty - Nett Quantity on hand . | Min Max | General tab |
| Max Reorder Quantity | When reordering this product, order enough stock until the Value in the Maximum Reorder. Maximum Reorder quantity - nett quantity on hand. | Min Max | General tab |
| Min Order Quantity | It is the minimum quantity which the supplier requires you to order in. EG min qty = 2 means if the product is purchased by each, you must buy at least 2. If the product is purchased by box or pack you must buy at least or 2 or by multiples of 2 from the.supplier. The system will always round up. Formula = max reorder qty - net qty on hand / min order qty if the pack break is not in eaches eg max reorder = 100 net qty on hand = 10 min reorder qty = 20. purchase order run will order 100 - 10 = 90. Then the system will divide the 90 by the min order qty of 2 = 45 only if the buy unit is not in eaches or box of 1 etc . | Average Weekly Sales, | Suppliers tab |
| Purchase Order | Quantity of stock that is currently on order on an outstanding purchase order. | Average Weekly Sales, | Quantities tab |
| Sale Back Order | Quantity of stock that is currently back ordered on an outstanding sale order. | Average Weekly Sales, | Quantities tab |
| Allocated | Quantity of stock that is currently allocated to customers on an outstanding sale order. | Average Weekly Sales, | Quantities tab |
All quantities are in Eaches, regardless of the units that are defined for the product.
Purchase Run Set fields
Each purchase run set has a number of fields that govern how products are selected to order. The table below gives a brief description of each field.
| Field | What it does | Default |
|---|---|---|
| Minimum Weekly Sales Count | The product will only be ordered if the average number of sales per week is greater than or equal to this number. Count of Weekly Sales = the average number of sales per week over the date range that contained at least one line with the product in it | 0.9 |
| Minimum Weekly Sales Quantity | The product will only be ordered if the average quantity of products sold per week is greater than or equal to this number. Quantity of Weekly Shipments = the average weekly each quantity of products shipped over the date range | 0.5 |
| Weeks of Floor Stock | Readysell multiplies the average quantity sold per week by this number to get the amount of stock required. The amount of stock that will be reordered is equal to weeks of floor stock x the quantity of weekly shipments | 5.0 |
| Average Weekly Sales Variance Threshold | Readysell multiplies the average quantity sold per week by this number to get the acceptable sales variance. If a week's total sales differ from the average by more than this amount, that week's sales are excluded from the calculation. This is particularly relevant for products where the quantity sold varies significantly in some weeks (such as seasonal stock). | 2.0 |
If you want to ignore a particular field, you must set it to 0.