AWRA OpsHub Search
Advanced Certificate on pass

Advanced Inventory Control

Move beyond stock on hand into availability control, traceability, variance response, and replenishment decisions.

3 lessons 45 min 5-question assessment 80% to pass

What you’ll learn

  • Separate stock ownership from sellable availability
  • Use holds, releases, transfers, and traceability to protect promises
  • Turn count variance into a controlled investigation
  • Use balancing and reorder signals before buying blindly

Course content

3 lessons · 45 min of reading
01
Lesson 1 of 3 Workshop 14 min

The control stack behind a trustworthy balance

A mature inventory team does not ask only, "How much do we have?" It asks a better question: how much do we own, how much is sellable, where is it, what evidence created the balance, and what should happen next.

That shift matters because a single on-hand number can hide risk. Some stock may be on hold, in transit, damaged, awaiting count approval, or sitting in the wrong branch. AWRA lets you treat those differences as control states instead of side notes.

In practice, take an item that shows 120 on hand in one warehouse while sales can only promise 85. Open Inventory → Stock Status and filter to the item: 20 units sit as Inspection pending from yesterday’s receipt and 15 are Damaged. Those 35 are owned but not available, and they are held on purpose. The inspector records the pass on the 20 under Receiving inspections, which releases them to sale on its own; the 15 damaged units are disposed of with a reason, a witness and photos, which raises an adjustment rather than making the quantity vanish. Every step leaves a record, so the next person who asks why 120 became 105 reads the answer instead of guessing.

Inventory control stack

1

Master data

Clean SKUs, categories, units, tax treatment, default warehouse, and reorder levels.

2

Availability state

Available, held, quarantined, in transit, damaged, or pending review.

3

Movement evidence

Receipts, issues, transfers, adjustments, scans, attachments, and approvals.

4

Count discipline

Sessions, submitted lines, approvals, recounts, variance rules, and reason codes.

5

Decision loop

Transfer, reorder, hold, dispose, investigate, or release stock based on the signal.

Control moves

  • On-hand is not the same as available.
  • Every control state should explain what a user can safely do next.
  • A trusted balance has master data, movements, counts, and evidence behind it.
  • Hold statuses such as Inspection pending, Quarantined and Damaged keep owned stock out of the available figure until someone releases or disposes of it.
02
Lesson 2 of 3 Lab 16 min

Availability decisions: hold, release, transfer, reorder

Advanced inventory control is mostly decision quality. The same shortage can mean different actions: transfer excess from another branch, reorder from a supplier, release stock after inspection, or hold stock because the physical condition is doubtful.

A good operator does not rush to purchase every time a shelf is low. They check location-level availability, in-transit stock, pending receipts, and hold status before creating more supply.

In practice, when one branch falls below its floor for an item, open Inventory → Stock Balancing before raising a requisition. Balancing compares each location with the warehouse’s own minimum for that item where one is set, otherwise the item’s reorder point, and suggests a transfer from a place holding surplus. If it names a source, raise the transfer: it is signed at dispatch and again at receipt, so a shortfall on arrival sits between two named people. Only when balancing has nothing to offer, because the shortage is real everywhere, does the request go to procurement. And where a workspace has switched on Releasing held stock needs approval under Settings → Inventory Defaults, a release waits under Release requests until someone other than the requester decides it.

Decision matrix

Signal First check Likely action
Low stock in one branch Other branches with excess stock Create a transfer before buying
Stock exists but cannot be sold Hold reason and inspection status Release, dispose, or keep quarantined
Short count variance Recent issues, transfers, scans, and attachments Investigate before adjustment
Slow-moving excess Demand trend and storage cost Transfer, discount, bundle, or stop reordering
Pending receipt PO delivery date and receiving status Escalate vendor before duplicate purchase

Key takeaways

  • A shortage is a signal, not automatically a purchase.
  • Location-level visibility prevents buying what another branch already has.
  • Hold and release controls protect customers from bad stock.
  • Stock Balancing suggests a transfer from surplus before a purchase, but nothing moves until a person raises the transfer.
03
Lesson 3 of 3 Practice 15 min

Variance response and balancing rhythm

Counts become powerful when they create a rhythm: count, submit, review variance, approve or recount, then apply the adjustment with a reason that leadership can read later.

The strongest inventory teams look for patterns, not just corrections. A recurring loss reason in one location, or repeated overstock in another, is a management signal. The count fixed the number; the pattern fixes the operation.

In practice, a monthly cycle count runs from a count plan scoped to one warehouse with blind count on, so counters submit what they see rather than confirm the system figure. Suppose a line comes back 8 short on an item the system shows at 200. Before approving, the reviewer checks for an unposted receipt, a transfer still in transit, or stock on a quality hold, the usual explanations for a variance nobody can source, and sends the line back with a recount request if the figure looks wrong. Once approved, applying the count does not overwrite the balance: it raises a stock adjustment for minus 8 (gains and losses travel as separate documents), and the session sits in Adjustment pending until that adjustment is approved. A variance rule scoped to the warehouse can auto-adjust small differences within tolerance and send everything else for approval.

Watch these three signals

Variance %

Count accuracy

Large or repeated variance means the process needs attention.

Age

Transfer aging

Long in-transit stock can create hidden availability problems.

Cover

Days of stock

Too little creates stockout risk; too much traps cash.

Simple variance read

Variance % = absolute(system quantity - counted quantity) / system quantity x 100

Use the number to prioritize investigation. A small variance on a high-value item can matter more than a large variance on a low-value item.

Key takeaways

  • A count session moves Open → Counting → Review → Adjustment pending → Adjusted, and the review step cannot be skipped.
  • Applying a count raises adjustments for the difference; it never edits the balance directly.
  • Check unposted receipts, in-transit transfers and quality holds before accepting a variance you cannot explain.
  • Variance rules set tolerances by quantity, percentage or value, and decide what auto-adjusts and what needs approval.

Finished the material?

Take the 5-question assessment and earn your certificate — 80% to pass.

Take the assessment

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center