Overview
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.
Getting Started
| Child pages (Children Display) | ||
|---|---|---|
|
...
| Field | Description |
|---|---|
| Type | This is the transaction type for this purchase run (i.e: PURSUG (Purchase Suggested Order)) |
| Number | The unique number for the transaction of this Purchase Run |
| Status | The status for this Purchase Run (e.g: open, posted etc) |
Date | The date and time the purchase run was created |
| Description | The description for reference of the purchase run |
| Purchase Run Type | Purchase run type is selected when a "Extract Products" occurs on a purchase run.
|
Suppliers Tab
Button
| Image | Field | Description | ||
|---|---|---|---|---|
 | Delete | Allows you to delete a selected supplier or selected suppliers off the purchase run without deleting the whole purchase run | ||
 | Extract Products |  | Change Supplier | Allow Brings up the purchase run selection window so that you can extract products and their suppliers based on the criteria of this window onto the purchase run |
| Change Supplier | Allows all products on a single purchase run to have their supplier set to one common supplier with a single button Once a day. A purchase order run is created for the wholesale supplier. Their may be many suppliers on the purchase run. The user clicks a single button, selects the required supplier and all purchase order lines on the purchase run change supplier to the supplier that was entered. | ||
 | Filter | There is a filter on the purchase run window which can show Order Required and Order Not Required and All. This filter is just above the lines to be ordered. Change the filter to Order Not Required, the product should show in this list, the Message tab at the bottom of the screen will show why it doesn't want to order it, you can change the Qty field to read as the quantity you wish to order of this product. |
Supplier's information
| Field | Description | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Field | Description | Count of Weekly Sales | Qty of Weekly Shipments | ||||||||||
| Stock Required | This is the stock required for this item | ||||||||||||
| Qty on Sales Back Order | The qty on sales back order for this item | ||||||||||||
| Qty on Purchase Order | The qty on outstanding purchase orders for this item | ||||||||||||
| Qty Allocated | The quantity allocated for this item | ||||||||||||
| Qty On Hand | The quantity on hand for this item | Unit Qty on Hand | |||||||||||
| Qty Available | The quantity available for this item | ||||||||||||
| Net Qty On Hand | The net quantity on hand | ||||||||||||
| Site | Supplier | Value Ex Tax | Value Inc Tax | Min Order Value | Minimum Order Variance | Product | Qty | Unit | Unit Quantity On Hand | Price Ex | Value Ex | Value Inc | Lead Time |
Item Details Tab
| Lead TimeThe site for this proposed purchase order from this supplier. If you have more than one site, your purchase run may be for all sites which means the supplier could appear more than once to show a purchase run for each site's supplier | |
| Supplier | The supplier the products are to be ordered from (this can change should you wish to change them to a different supplier) |
| Value Ex Tax | The value ex tax of the purchase run generated for each supplier |
| Value Inc Tax | The value inc tax of the purchase run generated for each supplier |
| Min Order Value | The minimum order $ value of the purchase run/order required to order from this supplier. This is Inc GST |
| Minimum Order Variance | The difference between what the minimum order value is and what you've so far added to the purchase run for that supplier |
Product information per supplier
Field | Description |
|---|---|
| Product | Product ID and Product Name appear in this field |
| Qty | Qty that the system thinks you need to order based on the criteria you used in the extract products window |
| Product Unit | The unit the qty refers to that is being proposed to be ordered |
| Unit Quantity On Hand | The qty on hand based on the default sell unit |
| Price Ex | The price ex per unit |
| Value Ex | The total value ex per line (Qty x Price Ex) |
| Value Inc | The total value inc per line (Qty x Price Inc) |
| Lead Time | The date the product will be due to come in to your site. From the point in time that you send the order to the supplier, to the point where it lands in your site. |
Item Details Tab
| Field | Description |
|---|---|
| Count of Weekly Sales | The count of time it sold per week - used when processing a purchase run based on average weekly sales. |
| Qty of Weekly Shipments | The total qty of shipments per week - used when processing a purchase run based on average weekly sales. |
| Stock Required | This is the stock required for this item |
| Qty on Sales Back Order | The qty on sales back order for this item |
| Qty on Purchase Order | The qty on outstanding purchase orders for this item |
| Qty Allocated | The quantity allocated for this item |
| Qty On Hand | The quantity on hand for this item |
| Unit Qty on Hand | The qty on hand based on the default sell unit on the product |
| Qty Available | The quantity available for this item |
| Net Qty On Hand | The net quantity on hand |
| Lead Time | The number of days that the product takes to get to your site. From the point in time that you send the order to the supplier, to the point where it lands in your site. |
Message tab
This feeds off the product you've selected on the Item Details tab and the filter selected (i.e. All, Order Required, Order Not Required)
- If you've selected a product to be ordered, the Messages tab will have a message along the lines of...
Min Reorder Qty: 2
Qty of Weekly Unit Shipments: 0.000
Min Qty of Weekly Unit Shipments: 0.5
Weeks of Floor Stock: 5
Calculated Stock Required: 0
Count of Weekly Sales: 0
Min Count of Weekly Sales: 0.9
Net Qty on Hand: 2
Max Reorder Qty: 10
Final Stock Required: 0.000
Stock to Order (Each): 6.000
Rounded Stock to Order (Unit): 16.8
--- Additional Figures ---
Qty on Hand: 2
Net Qty on Hand: -3
Total Qty of Unit Shipments for Date Range: 0
Total Count of Sales for Date Range: 0
Min Order Qty (for Rounding): 12
Qty Per Box (for Rounding): 1
- If you've selected a product to be ordered, the Messages tab will have a message along the lines of...
Qty of Weekly Unit Shipments: 0.000
Min Qty of Weekly Unit Shipments: 0.5
Weeks of Floor Stock: 5
Calculated Stock Required: 0
Count of Weekly Sales: 0
Min Count of Weekly Sales: 0.9
Net Qty on Hand: 4
Final Stock Required: 0.000
Excluded because:
- Net quantity on hand (4) is already greater than or equal to the stock required (0.000)
- Count of weekly sales (0) is less than the minimum weekly sales count required (0.9)
- Quantity of weekly unit shipments (0) is less than the minimum weekly unit shipment quantity required (0.5)
--- Additional Figures ---
Qty on Hand: 4
Net Qty on Hand: 4
Total Qty of Unit Shipments for Date Range: 0
Total Count of Sales for Date Range: 0
Product Suppliers Tab
| Field | Description |
|---|---|
| Product | |
| Supplier | |
| Minimum Order Quantity | |
| Is Primary | |
| Supplier Product ID | |
| Stock Level | |
| Stock Level Updated | |
| Cost Price Break 1-10 | This field shows the cost price break |
...
| Field | Description |
|---|---|
| Period | |
| Product | |
| Quantity | |
| Value Ex Tax | |
| Value Inc Tax | |
| Original Cost Ex Tax | |
| Cost Ex Tax | |
| Discount Value | |
| Margin | |
| Margin Percent | |
| Gross Profit Percent | |
| Number of Sales | |
| Average Sale Value Ex Tax | |
| Last Year Value Ex Tax | |
| Last Year Value Ex Tax Variance | |
| Internet Sales Value Ex Tax | |
| Last Year Internet Sales Value Ex Tax | |
| Last Year Cost Ex Tax | |
| Last Year Cost Ex Tax Variance | |
| Last Year Cost Ex tax Variance Percent | |
| Last Year Margin | |
| Last Year Margin Variance | |
| Last Year Margin Variance Percent | |
| Last Year Gross Profit Percent | |
| Last Year Gross Profit Percent Variance | |
| Last Year Gross Profit Percent Variance Percent | |
| Diff From Last Year Value Ex Tax | |
| Diff From Last Year Value Ex Tax Percent | |
| Sale Value Less Than Last Year | |
| Sale Value Greater Than Last Year | |
| Internet Sales Value Ex Tax Percent | |
| Cost Ex Tax At Cody P1 | |
| Margin At Cost P1 | |
| Margin Percent At Cost P1 | |
| Gross Profit Percent At Cost P1 | |
| Last Year Cost Ex Tax Variance At Cost P1 | |
| Last Year Cost Ex Tax Variance Percent At Cost P1 | |
| Last Year Margin At Cost P1 | |
| Last Year Margin Variance At Cost P1 | |
| Last Year Margin Variance Percent At Cost P1 | |
| Last Year Gross Profit Percent At Cost P1 | |
| Last Year Gross Profit Percent Variance At Cost P1 | |
| Last Year Gross Profit Percent Variance Percent At Cost P1 |
Message tab
The amount of stock that will be reordered is equal to weeks of floor stock x the quantity of weekly shipments
...
| Field | Description |
|---|---|
| Site | |
| Transaction Number | |
| Supplier | |
| Value Inc Tax Ordered | |
| Value Inc Tax On Order | |
| Minimum Order Variance | |
| Status |
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.
...