Stock ControlRidgeline Laboratory Supplies
Signed in as Warehouse and purchasing
Sample dataWarehouse and purchasing
Goods receipt
Booked-in deliveries, open delivery notes and the inspection at the gate.
Deliveries, August 10 to 15
Accepted on business days from 7:00 AM to 3:00 PM at gate 2; hazardous goods mornings only.
Mon, Aug 10
7:30 AM
Westbrook Laboratory Trading
B-24066 · 6 lines
10:00 AM
Redstone Plastics Engineering
B-24095 · 4 lines
1:30 PM
Collection of returns
2 cartons back to Thorncroft Glassware
Tue, Aug 11
8:00 AM
Thorncroft Glassware
B-24071 · 3 lines · fragile
11:00 AM
Sample count, rack B-01
40 items · warehouse management
2:00 PM
Picking round
12 orders for the eastern run
Wed, Aug 12
7:15 AM
Northgate Chemicals
B-24088 · 9 lines · hazardous
9:30 AM
Westbrook Laboratory Trading
B-24102 · 12 lines
2:00 PM
Picking round
18 orders for the western run
Thu, Aug 13
8:05 AM
Northgate Chemicals
LS-88417 · 7 lines · being checked
10:30 AM
Review quarantine hold
batch B-2409-77 · supplier has not replied
3:00 PM
Transfer from the central store
Memphis · 2 pallets · no delivery note
Fri, Aug 14
7:30 AM
Redstone Plastics Engineering
B-24127 · 5 lines
11:00 AM
Clear stocktake discrepancies
11 open lines from the sample count
1:00 PM
Weekly warehouse review
warehouse management and purchasing
Open deliveries
| Delivery note | Supplier | Order | Lines | Arrived | Inspection |
|---|---|---|---|---|---|
| LS-88417 | SupplierNorthgate Chemicals, St. Louis | OrderB-24118 | Lines7 | ArrivedAug 13, 8:05 AM | InspectionBeing checked |
| LS-88412 | SupplierWestbrook Laboratory Trading, Louisville | OrderB-24102 | Lines12 | ArrivedAug 12, 9:30 AM | InspectionDiffers from the order |
| LS-88409 | SupplierRedstone Plastics Engineering, Evansville | OrderB-24095 | Lines4 | ArrivedAug 10, 10:20 AM | InspectionPutaway open |
| LS-88404 | SupplierNorthgate Chemicals, St. Louis | OrderB-24088 | Lines9 | ArrivedAug 12, 7:15 AM | InspectionBatch number missing |
| LS-88398 | SupplierThorncroft Glassware, Akron | OrderB-24071 | Lines3 | ArrivedAug 11, 8:10 AM | InspectionMoved to quarantine |
| LS-88391 | SupplierWestbrook Laboratory Trading, Louisville | OrderB-24066 | Lines6 | ArrivedAug 10, 7:35 AM | InspectionPart delivery |
6 delivery notes open — on two of them the quantity received differs from the order.
Goods inspection, LS-88417
Delivery accepted
Aug 13, 8:05 AM · gate 2
Delivery note checked against the order
Line 3 short: 48 bottles instead of 96
Visual check and batch capture
4 of 7 lines recorded
Putaway to the bin
C-04-12 to C-04-14
Report the shortfall to purchasing
Decide between back order and credit note
Close the delivery note
Record a line
Demo — nothing is posted, nothing is saved and nothing is reported to the supplier.
taken from the delivery
shortfall of 48 bottles
from the supplier's label
goes into the query sent to the supplier
How Awelior would approach this project
Ridgeline Laboratory Supplies is invented — the way it is built is not. None of this is work delivered for a client. It is the shape we would give such a project — with the same depth, but without a client who would have to answer for it.
Where it starts
Cavendish Laboratory Supplies carries items that expire and belong to batches. The stock list is a spreadsheet, delivery notes sit in a binder, and at stocktake people walk the warehouse with clipboards. As long as nothing gets recalled that works; one batch recall reveals that nobody can say where the goods went.
Decisions
Batch and expiry are mandatory fields, not remarks
Both are captured at goods receipt and travel with the line. In the old spreadsheet they were free-text columns — and a free-text field three people fill in three ways is worthless in a recall.
Purchase suggestions from consumption, not from a reorder point alone
A fixed reorder point over-orders in summer and under-orders in autumn. The suggestion factors in actual consumption — and it stays a suggestion; a person places the order.
An item record with history
Every item has a view of its own with movements. That is the screen that answers “where did this go” — and the one a spreadsheet cannot structurally have.
Deliberately left outNo bin location management and no handheld picking. Both only pay off above a warehouse size this business does not have — and building them because they impress is exactly the kind of effort nobody uses later.
What is in it
- Screens
- 5
- Content blocks
- 17
- Languages
- 6
Five screens, in all languages, with sidebar, header and stated role. Navigation works; tables, filters, calendar, history, board and forms are rendered and inert. Item numbers, batches and stock figures are invented.
How it would go on
Goods receipt with a scanner
Reading a delivery note instead of typing it — that is where a stock system really saves time, and it depends on hardware.
Suppliers and pricing
Purchase suggestions need supplier terms, minimum order quantities and lead times, or they propose quantities nobody would actually order.
Stocktake
Count sheets, discrepancies, valuation and the handover to accounts — once a year, but under time pressure when it comes.
An application like this for your business?
Stock Control is a made-up example. A real application follows the processes your business already runs.
Sample application by Awelior. Invented business, invented data, nothing stored.