Stock Configuration
On-hold stock excluded from planning. Dispatch offsets adjust required dispatch date vs need-arrival.
On-Hold / QA Hold Stock (pallets)
Dispatch Lead Times
Stock Cover Thresholds (days)
Retailer view:
Weekly Demand by SKU
Stock vs Demand
Production Plan — Net of Stock, All Lines
Rolling Stock Projection — Current Week Forward
Shift Schedule
EP HMPS
EP Line A
EP Line B
EP New (12pk)
EP New (6pk)
Shift Detail
12-Week Rolling Horizon — click week to select
Dispatch Calendar — Next 21 Days | SOH + planned production | Dispatch-by dates applied
Alerts — Selected Week
Data Audit — Demand Quality, Consistency Check, Production Coverage
Loading…
Upload Actuals — ABH Actual Production Performance Tracker
ABH Actual Production Performance Tracker (.xls)
Drop or click — MTD file accepted, filtered to current week
No actuals loaded
📥 Get the actuals file from NetSuite
Run the ABH Actual Production Performance Tracker saved search in NetSuite. Set the Date filter to the current week before downloading.
Open in NetSuite →
Upload Inventory — NetSuite Inventory Valuation Summary
Updates stock on hand across all planning tabs instantly
NetSuite Inventory Valuation Summary (.xls / .xlsx)
Drop or click — updates all stock figures instantly
Using embedded stock figures
📥 Get the stock file from NetSuite
Run the 1 Stock for planning tool report in NetSuite, then download and upload here.
Open in NetSuite →
Current Stock on Hand
Manual Stock Override
Edit individual SKUs if inventory file is not available
Raw Material Coverage
vs next week forecast ● ● ≥3 wks ● 1–3 wks ● <1 wk
Upload Open Sales Orders — NetSuite Export
ABH Open Sales Orders Cust & Sku (.xls) — upload Monday morning to see committed stock
ABH Open Sales Orders Cust & Sku (.xls)
Drop or click — NetSuite SpreadsheetML export
No open orders loaded
📥 Get the open orders file from NetSuite
Shows open sales orders by retailer and SKU using Quantity Open (exact units)
to calculate committed pallets. Open orders are deducted from opening stock
and shown in the rolling projection as the first row.
Open in NetSuite →
Other Customer Demand — Pallets per Week
Added to WW + Coles before planning
Retailer Forecast Files
Forecasts arrive automatically by email — use these drop zones only if you need to manually override
Woolworths Forecast
Any format — Drop or click
Using embedded data
Coles Forecast
Any format — Drop or click
Using embedded data
Metcash / IGA Forecast
Any format — Drop or click
Using embedded data
Maintenance
Reference only — manual entry. CMMS link is a future phase.
Add Maintenance Entry
All Maintenance Events (date sorted)