# ReOrder in Barnet Portal
**ReOrder in Barnet Portal**
The ReOrder feature in Barnet Portal allows you to create purchase orders efficiently by vendor or vendor group, with full visibility into:
* Rate of sale
* Wholesale cost changes
* Current (and in some cases future) LTOs
* Products already ordered but not yet received
This helps ensure informed purchasing decisions and accurate inventory planning.
**1. Price List – Before You Start**
Before placing an order, **ensure your Price List is up to date**.
* The ReOrder page displays wholesale costs, LTOs, and cost changes based on your current price list.
* The **Price List Date** is shown in the \_Wholesale Cost (WS Cost)\_column header.
* If you are in a province that provides **advance price lists**, and you are in the week prior to a price change:
* Be mindful that pricing may already be advanced.
* Enable both **Current LTO *****(LTO/TPR)*** and **Future LTO *****(LTO Next Period)*** columns to help identify upcoming changes.
**2. Accessing ReOrder**
You can access ReOrder in either of the following ways:
* Click the **PO (Purchase Order) icon**, or
* Navigate to **Inventory → ReOrder**
**3. Selecting Vendors**
* You can select **a single vendor**, **multiple vendors**, or a **vendor group**.
* Selecting a group or multiple vendors allows you to **create multiple purchase orders at once**.
* This is the most efficient way to review inventory and make purchasing decisions across suppliers.
**4. Filters and Sorting Options**
The top section of the ReOrder page includes several filters and sorting tools. Key settings to review:
* **Number of Weeks for Average Sale**
* **Forecast Ratio (%)**
* **Show LTO Only**
Once adjusted, click "Apply" to refresh results.
**5. Ordering by Units or Cases**
* Ordering defaults to the vendor’s setup (Units or Cases), but this can be manually changed.
* When ordering by **Cases**, you can still enter quantities in **Units or Cases**.
**Best Practice**
* Weekly sales, average sales, and on-hand quantities are displayed in **Units**.
* Many vendors (e.g., BDL) require ordering in **Units**, making unit-based ordering simpler.
**6. Multiple for Order (Case Rounding)**
When ordering by units, enable **Use Multiple for Order to Adjust Qty**.
* This feature warns you if you’ve entered a quantity does not align with case sizes.
* It suggests rounding up to:
* Full cases
* Partial pallet layers
* Any value set in **Multiple for Order** on the product’s Stock tab
* If *Multiple for Order* is blank, the system defaults to **Units per Case**.
**7. LTO / TPR and DIFF Columns**
With a current price list, you can see:
* **Current wholesale cost**
* **Active LTOs**
* **Cost differences (DIFF)**
**Understanding the DIFF Column**
* Shows the difference between:
* Current wholesale cost, and
* Cost stored in Product Maintenance
* **Positive value** = cost increase
* **Negative value** = cost decrease
* **Blank** = no change
* If an item is on LTO but you already purchased it at that cost, DIFF will be blank.
**BC-Specific: TPR Identification**
* Temporary Price Reductions (TPRs) are not explicitly published.
* For BC customers, Barnet attempts to identify likely TPRs by:
* Comparing lower wholesale costs
* Matching items that are also on sale at Government Liquor Stores
* These potential TPRs are flagged with a **green cell**.
**8. Suggested Quantity for ReOrder**
To use **Suggested Qty**, at least one of the following must be set on each product’s Stock tab:
* Minimum Stock
* Maximum Stock
* Replenish Multiple
*Minimum Stock is the most commonly used and can be applied in bulk using “Apply All” in Product Maintenance.*
**Simplified Suggested Qty Logic**
(Minimum Stock + Average Sale) − (On Hand + Ordered Not Received)
* Maximum Stock and Multiple for Order are also applied.
* Click the **green “Autofill Suggested Qty” button** to populate quantities automatically.
**9. Forecasted Quantity**
Forecasted QTY is another auto-calculation controlled by the **Forecast Ratio (%)** at the top of ReOrder.
* It uses the **highest sales week** in the selected period (not the average).
**Formula (simplified):**
(Highest Week Sales × Forecast Ratio) − (On Hand + Ordered Not Received)
* The result is then adjusted by Multiple for Order.
**Example**
* To keep \~2 weeks of stock on hand → set Forecast Ratio to **200%**
* If sales are trending up → consider **250% or higher**
**10. Ordered Not Received**
This column displays quantities that have been **ordered on Purchase Orders but not yet received**.
**Backorders**
When you **post a receiving invoice** from a Purchase Order and **not all items are received**, the remaining items are automatically flagged as **Backorder**.
* Backordered items appear in the **Ordered Not Received** column.
* This column includes **all SKUs** that are:
* On **PO status**, or
* On **Backorder (Posted status)**
**Why This Matters**
Quantities in *Ordered Not Received* are used in both **Suggested Qty** and **Forecasted Qty** calculations.If incomplete or outdated Purchase Orders are left in the system, Barnet will assume inventory is still inbound, which can lead to **under-ordering**.
**Best Practices**
To maintain accurate ReOrder calculations:
* Post **partial purchase orders** accurately
* Remove SKUs from Purchase Orders if they are confirmed unavailable
* Delete any **obsolete or unsent** Purchase Orders
Keeping this column accurate ensures ReOrder reflects your true inventory needs.
**11. LDB On-Hand (BC Customers)**
* Displays **BC Liquor Distribution Branch warehouse on-hand quantities**
* Updated daily = Not live inventory, but helpful for assessing product availability
**12. Creating the Purchase Order**
Once quantities are reviewed and entered:
1. Click **Create Order** (blue button at the top center)
2. A processing pop-up will appear
3. Click **Create Order** again to confirm
4. The system will automatically navigate to the **Purchase Order page**
From there, you can:
* **Export** the order for online vendor ordering, or
* **Email** the order directly to the vendor
