The new DrillerDB is out of beta.See what's new

Stock Level Tracking

Reorder points, stock status, and negative-stock cleanup

Stock Level Tracking

Stock tracking in Products & Services is driven by item type. Material items carry a running quantity, a reorder point, and a stock status. Service and non-inventory items are stockless, so they track cost and usage without a quantity on hand.

How Material Stock Moves

For material items, the quantity on hand updates as work happens.

EventEffect on quantity
Materials used on a project or work orderDecreases automatically
Stock received or countedIncreases via an adjustment
Correction after a physical countSet to the exact count via an adjustment

Services and non-inventory items never change quantity; the list shows their type instead of a quantity.

Reorder Points and Status

Each material item has a single reorder point. The Items list compares the on-hand quantity to that threshold to set the item's status.

On handWhat you seeMeaning
Above the reorder pointThe quantity onlyNo action needed
At or below the reorder pointLow before the quantityReorder soon
Stockless itemNo quantityNot tracked

Only a reorder point above zero counts. Items at or below their reorder point are in the Low stock view on the Items tab, and the tab shows how many there are. Reorder in a row's menu, or on the item's page, starts a purchase order with the quantity that clears Low, so you can turn a reorder list into purchase orders quickly. Units already on a sent purchase order count toward that quantity, and the On order view lists the materials that have units on the way.

Set the reorder point to cover your typical lead time plus a safety buffer, then adjust it over time as you learn real usage patterns.

Setting and Correcting Quantities

Use Adjust stock on an item's page for any deliberate change.

AdjustmentUse for
AddReceiving a shipment or adding found stock
RemoveDamage, waste, or shrinkage
Set toOverwriting the count to match a physical count

Every adjustment is written to the item's stock history and the transaction log. The reason is optional; an adjustment saved without one is noted as "Manual adjustment". In the dialog, Remove cannot take away more than is on hand. For quick one-off changes on a wide screen, Add stock and Remove stock in a row's menu on the Items list change the quantity without opening the item.

Negative Stock

A material can go below zero when more usage is recorded than stock received. When that happens, the item's quantity shows in red and the item is in the Below zero view on the Items tab.

CauseFix
Usage logged before receivingRecord the receipt with an Add adjustment
A shipment was never enteredAdd the actual received quantity
A counting errorRun a physical count and record it with Set to

Below-zero items count as $0 in the stock value until you reconcile them. The Below zero tab shows how many there are. Click it to list only those items, with the total value of their negative quantities at the end of the tab row.

Best Practices

PracticeFrequency
Cycle counts on key materialsMonthly or quarterly
Resolve negative-stock itemsAs they appear
Review reorder pointsQuarterly
Log usage promptlyEvery job

Troubleshooting

Stock doesn't match a physical count?

  • Review recent transactions for duplicate or missed entries
  • Record it with Adjust stock, Set to, and a "physical count" reason

Low Stock warnings aren't appearing?

  • Confirm the item is a Material (services and non-inventory are stockless)
  • Check that a reorder point is set