Back to the software solutions

Example site for an entirely fictional business — not a real company.

Stock ControlRidgeline Laboratory Supplies

Sample data

Goods receipt

Booked-in deliveries, open delivery notes and the inspection at the gate.

Deliveries, 11 to 15 August

Accepted on business days from 7:00 AM to 3:00 PM at gate 2; hazardous goods mornings only.

Mon 11 Aug

  • 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 12 Aug

  • 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 13 Aug

  • 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 14 Aug

  • 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 15 Aug

  • 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 noteSupplierOrderLinesArrivedInspection
LS-88417SupplierNorthgate Chemicals, St. LouisOrderB-24118Lines7Arrived14 Aug, 8:05 AMInspectionBeing checked
LS-88412SupplierWestbrook Laboratory Trading, LouisvilleOrderB-24102Lines12Arrived13 Aug, 9:30 AMInspectionDiffers from the order
LS-88409SupplierRedstone Plastics Engineering, EvansvilleOrderB-24095Lines4Arrived11 Aug, 10:20 AMInspectionPutaway open
LS-88404SupplierNorthgate Chemicals, St. LouisOrderB-24088Lines9Arrived13 Aug, 7:15 AMInspectionBatch number missing
LS-88398SupplierThorncroft Glassware, AkronOrderB-24071Lines3Arrived12 Aug, 8:10 AMInspectionMoved to quarantine
LS-88391SupplierWestbrook Laboratory Trading, LouisvilleOrderB-24066Lines6Arrived11 Aug, 7:35 AMInspectionPart delivery

6 delivery notes open — on two of them the quantity received differs from the order.

Goods inspection, LS-88417

  1. Delivery accepted

    14 Aug, 8:05 AM · gate 2

  2. Delivery note checked against the order

    Line 3 short: 48 bottles instead of 96

  3. Visual check and batch capture

    4 of 7 lines recorded

  4. Putaway to the bin

    C-04-12 to C-04-14

  5. Report the shortfall to purchasing

    Decide between back order and credit note

  6. 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

Item
40-118 — buffer solution pH 7.00, 1 l

shortfall of 48 bottles

from the supplier's label

Bin location
C-04-12
Inspection result
Accepted with a discrepancy

goes into the query sent to the supplier

This form does not submit anything.
The project frame

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
4

Five screens, in all four 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.

Talk through your project

Sample data

An application like this for your business?

Stock Control is invented — the way it is cut is not. Applications like this come out of the processes a business already runs.

Talk about a solutionBack to the software solutionsThe service page: Business software

Sample application by Awelior. Invented business, invented data, nothing stored.