Added once, to every line of the document. Nothing else on a dispatched document can be changed here.
UPS shipment file
Photographs
What was wrong with them?
These units will come off stock and be recorded against a non-conformance number. The number is issued for you.
One line on what was done and why. If it was minor and needed no investigation, say so — the record has to show that decision either way.
This document number has been used before
Lazarus EU — Dispatch & Live Stock
Enter a dispatch once · stock updates automatically · export both spreadsheets
Europe
Dispatch details
Products0 lines
Category
Colour / Type
Size
Batch / LOT
Qty
Side
Unit £
Total £
Lines total£0.00
Recording adds one row per product line to the Dispatch Record and subtracts the quantity from Live Stock (matched on CODE + BATCH under the ship date).
Dispatches waiting to be double-checked
Nothing waiting. Everything recorded has been double-checked — add a dispatch on the New Dispatch tab.
One card per document number. Check each one against its delivery note, then clear it from the list — the dispatch stays in the record and stock is already updated.
Copy / paste blocks (for pasting straight into your master spreadsheets)
On its way from the UK
Sent
Document
Carrier
What is on it
Units
These left UK stock when the dispatch was committed and have not been booked in here yet, so they are on neither record. Book one in and its lines fill themselves — change a quantity only where what arrived differs from what was sent.
Goods in — book a consignment into EU stock
Nothing is manufactured in Europe, so stock gets here by arriving. Book the consignment in against the batch numbers it was made under — those numbers are what tie a boot on this shelf back to the routing document that made it, so they never change when goods move.
Type
Colour
Code
Batch
Sent
In UK
Here now
Qty received
Batch
Sent
Actually arrived
Difference
Consignments received
Received
From
Reference
Type
Colour
Code
Batch
Units
Booked in by
Every consignment ever booked into this record. Like a dispatch, a consignment is a record of something that physically happened, so it is never edited and never removed.
Shows active batches only — anything fully shipped moves to the Closed Stock tab. Amber = low (≤2). “Available” reflects your spreadsheet plus everything recorded in this session.
A batch moves here automatically once every unit has shipped. Click a batch to see each shipment.
Stock records
When
Code
Batch
Action
What happened
Who
Every batch that has gone into stock, every change to a balance, and the moment a batch is fully fulfilled. Recorded by the database itself, so it captures every change whichever page made it.
Who has been in
When
Who
Access
Record
What they did
The stock record above logs changes, so a look-but-do-not-touch login would never appear in it. This is the other half: every time somebody opened a record, printed a stock list or signed out.
Non-conformances
Units written off because something was wrong with them. They leave stock the same way a dispatch does, so nothing disappears without a record, and each one says why.
Every dispatch grouped by ship date, newest first — document number, destination, product, batch and quantity. Pick a day to isolate it and tick it off against your courier manifest.