Inventory Management — Africa Coffee Park ERP

CEO: Nelson Tugume | Inventory Oversight Officer: Kubariho Venture (Project Manager) — kubariho@africacoffeepark.com

Low Stock Alerts

SKU Catalog

SKU	Name	Category	Unit	Current Stock	Reorder Point	Unit Cost	Total Value	Location	Status	Actions

SKU	Name	Unit	Current Stock	Reorder Point	Unit Cost	Total Value	Status

SKU	Name	Unit	Current Stock	Unit Cost	Total Value	Status

SKU	Name	Unit	Current Stock	Reorder Point	Unit Cost	Status

Stock Movements

Ref#	Date	Type	SKU	Item	Qty In	Qty Out	Balance	Reference	Done By

Ref#	Date	SKU	Item	Qty In	Balance After	Reference	Done By

Ref#	Date	SKU	Item	Qty Out	Balance After	Reference	Done By

Ref#	Date	SKU	Item	Qty In	Qty Out	Reference	Done By

Active Batches

Batch ID	SKU	Item	Received	Best Before	Qty Received	Qty Remaining	Source	Status	Actions

Batch ID	SKU	Item	Received	Best Before	Qty	Source	Status

Stock Count

Current Stock Valuation

How to Use — Inventory Management

Step-by-step guidance for Inventory Controllers and Stock Officers

📚 SKU Catalog ▼

The SKU Catalog is the master list of all materials, packaging, and finished goods tracked by the inventory system.

Tip: Every physical item that enters or leaves the estate must have a registered SKU. Do not create movements for unregistered items — register the SKU first.

Click + Add Item and fill in the SKU code, description, category (Raw Material / Packaging / Finished Good / Consumable), unit of measure, and reorder level.
Use the sub-tabs to filter items by category.
Edit reorder levels as consumption patterns change — this keeps the Reorder Alerts accurate.

⇆ Stock Movements ▼

The Movements tab provides a full audit trail of all stock entries and exits linked to GRNs, GINs, and production orders.

Tip: Never manually adjust stock movements without a corresponding source document (GRN, GIN, or adjustment note). All adjustments require Kubariho Venture's approval above 500 kg.

Filter movements by SKU, date range, or movement type (In / Out / Adjustment).
Click any movement row to see its linked source document.
For stock adjustments (write-offs, found stock), log an adjustment movement with a reason code and supervisor name.

🚨 Reorder Alerts & Stocktake ▼

Reorder Alerts highlight items whose current stock has fallen below the minimum level. Stocktake allows periodic physical counts to be reconciled against system balances.

Tip: Review reorder alerts every Monday morning. Raise a purchase requisition in Finance for any item showing a red alert status.

In Reorder Alerts, click Raise PR next to any item to initiate a purchase requisition.
For Stocktake: create a new count session, select the warehouse zone, and assign counters.
Enter counted quantities per SKU — the system shows variance vs system balance.
Approve the stocktake to post adjustment movements for any variances.

💰 Valuation & Reports ▼

The Valuation tab shows the monetary value of current stock using weighted average cost. Reports generates summaries for management and audit.

Tip: Run the monthly valuation report on the last working day of each month and share with Finance. Stock value must reconcile with the Finance module's asset register.

In Valuation, select the category and date to see stock value by SKU or category.
Use Reports to generate: Stock Summary, Movement Report, Batch Tracking Report, or Valuation Report.
Export reports as CSV or print directly from the browser for filing.