Below 2.5-month cover
0
total candidates
Out of stock
0
0-month cover · hidden
Needs setup
0
in stock, no team/batch · hidden
Schedulable now
0
shown in schedule
Products
0
in catalogue
Setup complete
0
batch + team set
Needs setup
0
active, missing batch/team
Dormant
0
no stock / usage
Products shown
0
rows
Below threshold
0
cover under limit somewhere
Warehouses
0
columns shown
🧬 Capricorn stock
…
products holding · click to view
① Load latest stock holdings (Location&Usage)
Browse to the latest Location&Usage workbook (.xlsx / .xlsm). It refreshes stock, usage & to-invoice across all warehouses and branches (today's snapshot) and logs the import below.
Stock import history
② Load back-order report (SAP B1)
Browse to the latest Back Order Report (.xlsx). It replaces the current back-order set (a bad file is validated first, so it never wipes good data) and logs the load below. Drives the Back Orders + Fulfilment screens.
Back-order load history
③ Load sales history (TMs unit sales pivot)
Browse to the latest “TMs unit sales … pivot” workbook (.xlsx). Each month's file contains the full history, so simply load the newest one — earlier loads are kept and can be made live again. Drives the Sales Summary screen. Note this feed is units only — it carries no rand values.
Sales load history
Items to fulfil
0
to-invoice less back order
Honour from stock
0
no transfer / production
Need transfer / WIP
0
stock elsewhere or in production
Need production
0
stock + WIP can't cover
Open back-orders
0
0 products
Short — need action
0
can't fulfil from their WH
Transfer can cover
0
stock exists elsewhere
Produce
0
no network stock
Units — latest month
0
vs prior month
Units — period
0
across the window
Active reps
0
0 customers
Selling but at risk
0
out of stock or under 2.5 months cover
Add user
Email
Name (optional)
Roles