WorkestraDocs
ModulesStock

Stock Products

Product catalog with stock levels, reorder rules, and lot/serial tracking per warehouse.

Products in Stock are the same catalog used by Finance (for invoicing) and Sales (for quotations). Stock adds per-warehouse quantity tracking, reorder rules, and traceability options on top of the shared product record.

Stock-Specific Product Properties

The following fields are added to the shared product record when Stock is enabled:

FieldDescription
TrackedYes/No — whether stock levels are maintained for this product
Valuation MethodFIFO, AVCO, or Standard Cost (overrides the workspace default)
Lot TrackingTrack stock by lot number (batch)
Serial TrackingTrack stock by individual serial number
Reorder PointMinimum quantity that triggers a reorder
Reorder QuantityHow much to order when the reorder point is reached
Preferred VendorDefault vendor used when creating reorder POs
Internal ReferenceSKU or internal product code
BarcodeEAN/UPC or QR code for scanning

Stock Levels per Warehouse

On the product record, a table shows current stock at each warehouse:

ColumnDescription
On HandUnits physically present in the warehouse
ReservedUnits committed to outgoing orders
AvailableOn hand minus reserved
IncomingUnits on open, approved purchase orders

Lot Tracking

Products with lot tracking enabled require a lot number on every receipt and dispatch.

Each lot carries:

  • Supplier lot reference
  • Expiry date (optional)
  • Quantity received
  • Full movement history — which PO it arrived on, which orders it was dispatched on

Serial Tracking

Products with serial tracking enabled require a unique serial number per individual unit.

Each serial number has a full lifecycle record:

  • Received in PO X → stored at warehouse Y → transferred to warehouse Z → dispatched in order W

Serial numbers cannot be split or merged — one number, one unit, always.

Reorder Rules

Configure automatic reorder rules on the product record under the Reorder Rules tab:

  1. Click Add Rule
  2. Select the warehouse the rule applies to
  3. Set the reorder point (minimum qty before a PO is triggered)
  4. Set the reorder quantity (how much to order)
  5. Select the preferred vendor

When stock at that warehouse drops below the reorder point, a draft PO is created in Procurement pre-filled with the vendor, product, and reorder quantity.

The reorder check runs daily as a scheduled job. For urgent situations, navigate to Stock > Reorder Rules and click Run Now to trigger the check immediately.