Live from Prospect. Lists split into Allocated and Unallocated. Floor Allocated shows the SO + customer behind committed stock; Unallocated is free to sell, with the supplier and arrival date taken from the purchase order that delivered it. On the Group view, BV cost shows EUR then GBP in brackets (today's rate is shown top-right). Use the Warehouse / Supplier filters to narrow a list — every column still sorts.
View:
On the floor
Stock physically on the floor — free to sell plus allocated. Select a card to open it.
Due in
Incoming stock from suppliers — free to sell plus pre-sold. Select a card to open it.
Incoming stock by month
All three charts share one scale · select a month to open it in Due inUKNL
Free to sellDue in by month — free to sellunallocated · at cost · today's FX · all three charts share one scale · click a month to open it in Due in
AllocatedDue in by month — allocatedpre-sold incoming · at cost · today's FX · click a month to open it in Due in
TotalDue in by month — totalfree + allocated · at cost · today's FX · click a month to open it in Due in
Floor value by companyFloor value by companyat booked cost
Where the value sitsWhere the value sitsall at cost · cards and rows are clickable
Stock on the floor
Space = all words · + = either (e.g. Dove + Axe)
Add columns:
All stock on the floor
A/U
Co
Warehouse
PO
PO date
Barcode
Product
Case
CPP
Arrived
Days
SO
SO date
Customer
Units
Pallets
Cost/u
Sale/u
Margin %
Value (cost)
Sale value
Margin cash
Allocated — committed to sales orders
A/U
Co
Warehouse
PO
PO date
Barcode
Product
Case
CPP
Lang
Sales order
SO date
Customer
Supplier
Days
Due
Units
Order value
✳ AI edit:
Unallocated — free to sell
Tick "Drop" on any line to leave it off the SOH download — the line stays on screen.
A/U
Co
Warehouse
PO
PO date
Barcode
Product
Case
CPP
Lang
Supplier
Arrived
Days
Free units
Sold units
Cost
Sale
Margin
Free value
Notes
BBE
Origin
Drop
Due in
Product, barcode, PO or supplier · space = all words · + = either
Add columns:
All incoming stock
A/U
Co
PO
Supplier
Warehouse
Barcode
Product
Case
CPP
Lang
Customer
PO date
Due in
Free units
Sold units
Units
Cost
Sale
Margin
Value (local)
Allocated — pre-sold incoming
PO
Supplier
Warehouse
Co
Barcode
Product
Case
CPP
Lang
Customer
PO date
Due in
Allocated units
Cost
Sale
Margin
Value (local)
Unallocated — incoming, not yet sold
✳ AI edit:
Offer
Co
PO
Supplier
PO date
Warehouse
Barcode
Product
Case
CPP
Lang
Due in
Free units
Sold units
Cost
Sale
Margin
Stock value
Notes
BBE
Origin
Drop
space = all words · + = either
Open sales orders
Co
Order
Customer
Due
Status
Order value
space = all words · + = either
Sale pricing
UK prices in £, NL in € — these feed the stock report's price columns.
Bulk import sale pricesone per line: barcode price (space, comma or tab between)
Oxbridge Associates Group · prepared for Andrew Dymond, Managing Director ·