06 / MATERIALS AND STOCK

Warehouse, stock and documents

The warehouse follows material from goods receipt through to its use in a specific work order. It is not a separate ledger that someone reconciles afterwards — an issue is tied to the order it was issued for, so at any moment you know where material went and what that job actually consumed.

For joinery production that matters more than it might seem, because most of the value sits in profiles and glass — and that is exactly where the offcuts nobody records are generated.

Warehouse overview: items below minimum, open reservations, purchase orders and stock value, with document counters and the latest goods receipts
HOW IT WORKS

What Warehouse actually does.

01

A control screen before anything is issued

The warehouse overview shows what is holding up work in one place: how many items have fallen below their minimum, how many reservations are open, which purchase orders are outstanding and what the stock is worth. Alongside sit document counters by type for the last seven days and a warning about late deliveries. The below-minimum list also proposes an order quantity.

Below minimum
Items whose stock has fallen under the set threshold, with a proposed quantity.
Stock and free stock
Total stock and what genuinely remains once reservations are deducted.
Open commitments
Reservations and purchase orders that are not yet closed.
Late deliveries
A warning about ordered goods that have not arrived on time.
02

Documents that cover the real work

Every movement has its own document rather than just a changed number. Receipts bring material in, issues take it out against an order, dispatch notes accompany delivery, returns bring back what was not used, write-offs remove what has been spoiled, corrections fix mistakes, and transfer notes move stock between warehouses. Stocktakes are kept as documents, including the annual one.

Receipt and issue
Material in, and issued against a work order.
Dispatch note
The delivery document, with the positions that actually leave.
Return and write-off
Unused material returned and spoiled material removed.
Correction
A booking correction, with a record of who corrected it and when.
Transfer note
Movement between warehouses without losing traceability.
Stocktake
A stock count kept as a document, including the annual stocktake.
03

Stock value, not only quantity

Stock is valued on a FIFO basis, so material cost follows the actual purchase order rather than an average that hides price rises. Average price and book value are maintained alongside. Production costs are tied to the order, so you can see how much material genuinely went into a specific job.

FIFO
Valuation in order of purchase.
Average price
For comparison and a quick estimate of stock value.
Cost per order
Material issued to an order, tied to that job.
04

Analysis that shows where the money sits

ABC analysis ranks items by their share of value, XYZ by how predictable their consumption is. Together they show what is worth holding in stock and what should be ordered as needed. Ageing analysis shows what has been sitting too long — usually material bought for a job that fell through.

ABC
Ranking by share of total stock value.
XYZ
Ranking by predictability of consumption.
Stock ageing
An overview of what has sat untouched for too long.
Purchase proposal
What needs ordering, against order demand, minimum levels and stock on hand.
05

Barcodes, traceability and offcuts

Items are labelled with barcodes, and scanning speeds up receipts and issues without typing codes. Traceability links the receipt, the issue and the order, so in the event of a complaint you know which delivery the material came from. Finished pieces and load units are tracked separately from raw material, because they behave differently.

Barcode and scanning
Receipts and issues without typing item codes.
Traceability
The receipt–issue–order chain, for complaints and checks.
Finished pieces and offcuts
Separate tracking of produced pieces, load units and profile offcuts.
Return to supplier
Material returned against the original purchase order.
CAPABILITIES / 01—06

What the module covers.

01

Every warehouse document

Receipts, issues, dispatch notes, returns, write-offs, corrections, transfers and stocktakes.

02

FIFO valuation

Valued in order of purchase, alongside average price and book value.

03

ABC and XYZ analysis

Ranking by share of value and by predictability of consumption.

04

Barcode and scanning

Receipts and issues by scanning, without typing item codes.

05

Traceability

The link between receipt, issue and work order, for complaints and checks.

06

Tied to the order

Material is issued to a specific job, so the true cost of that order is visible.

Limits, plainly stated

The warehouse is a separate module and its availability depends on the package and licence. Values are calculated from the data entered — without purchase prices there is no stock value. Reservations and demand-against-stock comparison work when the bill of materials and orders are connected to the warehouse. The software does not manage the physical layout of racking.

FREQUENTLY ASKED QUESTIONS

Clear and specific.

01Which warehouse documents does it keep?

Receipts, issues against orders, dispatch notes, returns, write-offs, booking corrections, transfer notes and stocktakes, including the annual stocktake.

02How is stock valued?

On a FIFO basis, so cost follows the actual order of purchase. Average price and book value are maintained alongside, for comparison and quick estimates.

03Can I see how much material a given order consumed?

Yes. Issues are tied to the work order, so material cost is attributed to that job and can be compared against the costing in the bill of materials.

04What are ABC and XYZ analysis for?

ABC ranks items by their share of stock value, XYZ by how predictable their consumption is. Together they show what is worth holding in stock and what to order as needed.

05Does the warehouse support barcodes?

Yes. Items are labelled with barcodes, and receipts and issues can be done by scanning, without typing item codes.

06Can I trace which delivery a material came from?

Yes. Traceability links the receipt, the issue and the work order, so in the event of a complaint the originating purchase can be established.

NEXT STEP

See warehouse through your actual workflow.

Send an enquiry LEMY CNC SISTEM d.o.o.