Inventories & Stock ModuleOptional Module

Current Stock Balance

1. Overview & Purpose

What is Current Stock Balance?

Stock Balance delivers real-time visibility into physical and available inventory across every branch, retail outlet, warehouse storage bin, and item batch. It tracks physical on-hand stock, active reservations, incoming shipments, average costs (HPP), and perishable expiration dates.

Menu Location:/admin/inventories/stock-balance

2. When to Use Stock Balance

Multi-Branch Stock Inquiry for Omnichannel / Walk-In Customers

A walk-in customer at Mall Kelapa Gading wants to buy 3 units of an out-of-stock sneaker, and the sales associate checks if the nearby Grand Indonesia branch has stock.

Recommended Action:Filter Stock Balance by SKU to view real-time on-hand, reserved, and available quantities across all enterprise retail outlets simultaneously.

Negative Stock Auditing in High-Velocity Retail Counters

During high-traffic weekend sales, items are sold at POS before warehouse personnel finish digital Goods Receipt logging under "Allow Negative Stock" mode.

Recommended Action:Filter the balance view for negative on-hand quantities to pinpoint unregistered inbound delivery shipments that must be posted immediately.

Perishable Batch Expiry Tracking (FEFO - First Expired, First Out)

Quality control inspects dairy, bakery, or cosmetic batches nearing shelf-life expiration thresholds (e.g. less than 14 days remaining).

Recommended Action:Use the Near Expiry filter to isolate expiring lots, prompting store managers to initiate 50% discount markdowns or return claims before expiry.

Storage Bin Capacity & Reorder Buffer Monitoring

Warehouse coordinators monitor frontline picking bins to ensure fast-moving SKUs are replenished from high-bay bulk reserve pallet racks before running dry.

Recommended Action:Filter by specific Storage Bin to monitor stock levels against configured minimum safety thresholds and generate internal transfer requisitions.

Active Sales Order Reservation & Available to Promise (ATP) Inspection

Wholesale sales reps verify how many units can be promised to a new client without stealing stock already reserved for existing pending Delivery Orders.

Recommended Action:Inspect the "Available Stock" column (Physical On-Hand minus Active Order Reservations) to quote accurate delivery commitments to commercial buyers.

3. Data Dictionary & Fields

Field specifications for the consolidated stocks table view:

Field / Column	Input Type	Requirement	Description & Operational Guide
productName	String	Required	Registered brand, model, and descriptive trade name of the inventory item. Example: Kemeja Katun Oxford Lengan Panjang
skuBarcode	String	Required	Unique Stock Keeping Unit code or scanned retail barcode. Example: SKU-KMT-NAVY-L / 8992761002341
locationStorage	String (Location / Storage)	Required	Physical outlet and nested storage bin holding the specific stock allocation. Example: Jakarta Central > Bin A-12
batchNumber	String	Optional	Manufacturing lot or purchase shipment batch code. Example: LOT-2026-04B
expiryDate	Date	Optional	Expiration date for lot-tracked or perishable goods. Example: 2027-04-30
quantity	Decimal	Required	Total physical on-hand quantity present in the designated storage bin. Example: 120.00
reservedQuantity	Decimal	Required	Quantity earmarked for approved stock transfers, unfulfilled sales orders, or active shift checkout. Example: 20.00
availableQuantity	Decimal	Required	Net free stock available for immediate sale or dispatch (quantity minus reservedQuantity). Example: 100.00
averageCost	Decimal	Required	Weighted moving average cost price (HPP) per base unit. Example: 75000.00
stockValue	Decimal	Required	Total inventory valuation calculated as on-hand physical quantity multiplied by averageCost. Example: 9000000.00
minStockAlert	Decimal	Optional	Safety stock threshold triggering low-stock alerts when available quantity falls below limit. Example: 15.00

4. Interface Preview

Stock Balance console showing aggregate metric cards, multi-attribute filter badges, available quantities, and export actions.

inventories-web

Menu Location:Route: /admin/inventories/stock-balance

Screen Preview: Stock Balance Interface

Visual interface illustration and control layout for menu Route: /admin/inventories/stock-balance

1Summary Metric Cards2Multi-criteria Filters3Physical vs Available Stock4Export to Excel / PDF

Current Stock Balance overview showcasing real-time on-hand stock, active reservations, unit average costs, and shelf-life indicators.

5. Multi-Storage & Batch Filtering

Navigate to Stock Balance

Menu > Inventories > Stock Balance

Open the sidebar menu and select Inventories > Current Stock Balance.

Review Metric Overview Cards

Metric Cards Header

Inspect top summary cards for Total SKUs, Total Physical Stock (On-Hand), Low Stock Alerts, and Near Expiry counts.

Apply Multi-Criteria Filters

Filter Button > Apply Filters

Click the Filter button to isolate balances by Branch, Location, Storage Bin, Product, or Batch Number.

Active filter tags appear above the table for easy inspection and one-click removal.

6. Detail View & Valuation Metrics

Open Item Balance Details

Action > Detail

Click Detail on any table row to launch the comprehensive Stock Balance Details modal.

Inspect Stock Breakdown and Valuation

Quantities & Valuation Tabs

Examine detailed quantities including physical on-hand, active reservations, net available, and total stock valuation.

Review Expiry and Activity Timeline

Activity History Section

Check Days Until Expiry for lot batches alongside timestamps for Last Incoming, Last Outgoing, and Last Movement.

Items with no movements exceeding 90 days are flagged as slow-moving inventory to aid inventory optimization.

7. Data Export to Excel & PDF

Available Stock vs Physical Stock

Always rely on Available Stock when quoting customer orders or allocating wholesale deliveries. Physical on-hand stock includes items already committed to POS register baskets, active warehouse transfers, or pending sales shipments.

Configure Export Scope

Table Filter Toolbar

Filter the balance register to the desired branch, category, or warehouse facility before generating export files.

Export to Excel or PDF

Action > Export

Click Export and choose Export to Excel (.xlsx) for spreadsheet analysis or Export to PDF for official warehouse stock audit sign-off.

The export engine includes full batch numbers, storage bin designations, and valuation totals in the generated report.

8. Cross-Module Impact

Target Subsystem	Relational & Transactional Effect
Point of Sale (POS)	POS terminals validate net available stock in real-time, preventing sales beyond physical shelf availability.
Sales Orders & Dispatch	Approving sales orders creates stock reservations that immediately reflect in the reservedQuantity column.
Procurement & Purchase Orders	Purchasing managers utilize low-stock alert thresholds in Stock Balance to generate automated reorder suggestions.
General Ledger Accounting	Total Stock Value aggregates provide the authoritative asset valuation balancing with the 1300 Inventory Asset account.

Operational Best Practices

Always monitor the Available column rather than On-Hand when allocating stock for customer orders.
Use the Near Expiry filter monthly to formulate First-Expired-First-Out (FEFO) promotional stock clearances.
Filter by specific storage bins to streamline physical spot-checks during cyclic inventory reviews.