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:
Click Create Order (blue button at the top center)
A processing pop-up will appear
Click Create Order again to confirm
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
Last updated