> For the complete documentation index, see [llms.txt](https://support.barnetpos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.barnetpos.com/liquor-store-portal/ordering/reorder-in-barnet-portal.md).
# 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
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://support.barnetpos.com/liquor-store-portal/ordering/reorder-in-barnet-portal.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.