§ 20 · Money & operations

Inventory & stores

Inventory tracks what the university physically holds and what it is worth. It has its own workspace rather than the usual module bar, and it is period-controlled like the ledger — which means the same lesson applies: nothing posts into a closed period.

What it is for

Running stores: what is held, where, in what condition and at what value.

Who can do it

Inventory ManagerStore ManagerStorekeeperReceiving OfficerStock Counter

Needed first
  • Stores and locations defined
  • An item catalogue
  • Opening stock loaded
  • An open inventory period
Where it ends

A stock position and valuation that finance can rely on.

The Inventory Dashboard

The Inventory Dashboard: a current-period band, six tiles for total inventory value, total items, total stock on hand, total stores, total requisitions and total issues, then Stock Status Summary, Inventory Value by Category, Stock Movement, Low Stock Alerts, Expiring Items and Pending Approvals panels.
Inventory Dashboard. Note the band top right: the date and Current period. Everything below is period-scoped.
  • Stock Status Summary splits stock three ways: On hand, Damaged and Quarantined. Only the first is issuable.
  • Inventory Value by Category — where the money is sitting.
  • Low Stock Alerts — items below their reorder level, with the store named. This is the reorder list, and it feeds straight into a procurement requisition.
  • Expiring Items — batches expiring within 30 days. For a university with medical and food supplies this is a safety list, not an accounting one.
  • Pending Approvals — requisitions, goods receipts, adjustments and transfers waiting on someone.
This module has its own furniture

Inventory does not use the module bar and task sidebar described in Finding your way around. It has its own header, its own breadcrumb and its own sidebar, and it logs out from its own button. It is the same sign-in — just a different workspace. On a narrow screen its tables run wider than the window, so scroll the table sideways rather than looking for a missing column.

The five movements

Everything that happens to stock is one of five movements. Learn these and the module is straightforward.

MovementScreenStock goesNeeds
ReceiptReceipts & InspectionInA purchase order, or an opening-stock load
IssueIssues & ReturnsOut, to a departmentAn approved requisition
TransferTransfersBetween storesBoth stores defined; goods in transit are tracked
AdjustmentAdjustmentsUp or down, with a reasonApproval — this is the movement auditors read first
CountStock CountsNowhere; it establishes truthA count sheet, and sign-off on the variance
The Inventory Requisitions screen listing internal requests for stock with their approval status.
Requisitions. A department asks the store for stock. There is a separate non-catalogue route for something the catalogue does not carry, and an availability check before you promise anything.
The Inventory Receiving screen for booking goods into a store against a purchase order.
Receipts & Inspection. Goods are booked in and inspected. Anything failing inspection goes to Quarantine & Disposal rather than into issuable stock.
The Issues and Returns screen listing stock issued to departments and returns received back.
Issues & Returns. Issued against an approved requisition; there is a direct-issue route for genuine exceptions, and it is visible as such.
The Transfers screen showing stock moving between stores, including a transit view.
Transfers. Stock in transit belongs to neither store. The transit view is what you check when a count does not agree.
The Stock Counts screen listing counts with their variances.
Stock Counts. The count is the truth; the variance is the report. Shrinkage has its own screen beside this one.

Worked example

Worked example

The Registry asks for 10 reams of A4 paper

1. Check availabilityRequisitions → Availability — Standard A4 Photocopy Paper at Main Store Juba. The dashboard's Low Stock Alerts already flags it at 5.00 available against a reorder level of 23.00
2. Not enoughTwo paths: transfer from another store, or raise a procurement requisition. Do not issue stock you do not have — a negative position is worse than a delay
3. RequisitionRegistry raises one for 10 reams. It goes to Pending Approvals
4. ApproveThe store manager approves against availability
5. IssueIssues & Returns → issue against the requisition. Stock on hand falls by 10; the issue is attributed to Registry
6. ValueValuation reflects the movement in the current period
7. LaterAt the count, the physical shelf and the system should agree. If not, an Adjustment with a reason — never a quiet edit

Periods, valuation and control

The Inventory Valuation screen showing stock value by item and store for the period.
Valuation. What the stock is worth, for the period. This is the figure finance carries.
The Inventory Settings screen with module configuration.
Inventory Settings. Its own permission, inventory.manage_settings, separate from running the stores day to day.
Period control, exactly like the ledger

Period Control opens and closes inventory periods. Once a period is closed, movements cannot be posted into it — so a receipt for goods that arrived last month must either be dated into an open period or wait for a deliberate reopening. Close the period after the count, never before.

If stores will not behave

SymptomCauseFix
A movement refuses on its dateThe inventory period is closedPeriod Control
Stock is there but cannot be issuedIt is Damaged or Quarantined, not On handStock Status Summary — only On hand is issuable
A count does not agree and nothing is missingStock is in transit between storesTransfers → Transit
Columns appear to be missing from a tableThe table is wider than the windowScroll the table sideways
An item cannot be requisitionedIt is not in the catalogueUse the non-catalogue requisition route, or add the item
Goods arrived through procurement but stock did not moveProcurement receiving and inventory receipt are two recordsReceipts & Inspection
Asset Management looks emptyAssets are a separate phase from stockSee Accounting — Asset Management is not yet in service