[Platform]

Inventory

On-hand stock, named locations, lots, serials, heat records, discrete pieces and reservations against demand. It owns the balance and the transaction behind it; the purchase receipt and the customer shipment belong to purchasing and sales.

WorkCell TeamPublishedUpdated
Inventorylots, serials, locations, traceability

Most shops know roughly what they have and precisely nothing about where it came from. On-hand is typed into a spreadsheet, the heat number lives on a mill certificate in a filing cabinet, and the material a job consumed gets reconstructed from the traveler. This module makes on-hand a result rather than an input. Every movement is an inventory transaction with a direction, a quantity, a cost and a location, and a balance per item and location is kept alongside it. Lots carry the heat they were cut from, serials carry the lot and the serial above them, pieces carry the piece they were cut from, and reservations hold stock against the order or job that needs it.

What It Does
01

Stock As A Ledger

On-hand is the running sum of inventory transactions, each one carrying a direction, quantity, unit cost and location, with a balance row per item and location kept alongside. The stock and transactions screens read the same ledger.

02

Heat Lot Traceability

Heat is its own record, not a note on a line. It carries the mill name, material specification, grade, country of melt and the PMI result, and every lot cut from that heat references it, so bar on the rack resolves to its certificate.

03

Lots And Serials

A lot names the item revision it was received under and the supplier behind it. A serial names its parent lot, the work order that made it and the serial above it in the assembly, so the records support a trace in both directions.

04

Discrete Piece Tracking

Inventory is tracked as discrete pieces: five sticks of bar, not one length. A piece carries its original and remaining quantity, whether it is owned, customer supplied or consigned, and the piece it was cut from, so a cut leaves a parent and children.

05

Reservations Against Demand

A reservation holds stock against the sales order line or work order that needs it, with a need date and a priority. Cover it from stock, from an open purchase order line, or by raising the purchase order or work order that covers it.

06

Locations And Availability

Locations nest under a site and an area and carry a type: storage, receiving, shipping, staging, quarantine or work in process. Availability is on-hand minus what open reservations hold at a location, and a pick is allocated from the largest free bin first.

07

Overview And Movement

The inventory overview totals on-hand quantity and value, counts tracked items with no stock, locations in use and open reservations, and charts received against issued quantity over the period you pick.

Frequently Asked Questions

How does WorkCell calculate on-hand inventory?

On-hand is derived, not typed. Every receipt, issue and transfer writes an inventory transaction carrying direction, quantity, unit cost and location, and a balance row per item and location is updated in the same step. The transactions screen shows the movements; the stock screen shows the balances they add up to. Nobody edits a quantity directly.

Can I trace a finished serial back to its heat?

The records support it in both directions. A serial names the lot it came from and the work order that made it, the lot names the heat it was cut from, and the heat carries the mill, the grade and the country of melt. Walking the other way, a heat lists its lots and those lots list their serials.

Why track inventory as pieces instead of a quantity?

Because forty feet of bar is not the same thing as one forty-foot stick. A piece record holds its original and remaining quantity, where it sits and the piece it was cut from, so a remnant stays findable and a cut leaves a parent with children rather than a smaller number.

What is the difference between on-hand, reserved and available?

On-hand is the physical balance at a location. Reserved is the part of it held by open reservation lines that name a location. Available is on-hand minus reserved. A reservation line pegged to a purchase order line is a promise about stock that has not landed, so it does not reduce what is available on the shelf.

How does a reservation get covered when stock is short?

Four ways, all from the reservation itself. Cover it from stock at a location, peg it to a line on an existing purchase order, raise a new purchase order for it, or raise a work order to make it. Each one writes a reservation line, and releasing the line or the whole reservation hands the quantity back.

[Platform]

One database, every module.

Tell us what you hold, how it is identified and who asks you to trace it, and we will show you how the balance, the lot and the heat line up.