Monitoring Stock Levels with Stock Level Reports

Monitoring Stock Levels with Stock Level Reports

Overview

This article gives you an overview of the Stock Level Report which delivers critical insights into current and projected stock quantities.



Types of Stock Level Reports

1. Stock Projected Quantity Report

The most comprehensive stock report, showing:


  • Current stock levels

  • Pending orders and reservations

  • Projected future availability


Access Path:
Stock > Main Report > Stock Projected Quantity




Key Metrics in Stock Level Reports

1. Actual Quantity (Actual Qty)

  • Definition: The physical stock currently available in the warehouse.

  • Use Case: Determines immediate fulfillment capability.


2. Planned Quantity (Planned Qty)

  • Definition: Items scheduled for production via Work Orders but not yet manufactured.

  • Example: 100 units planned for production next week.


3. Requested Quantity (Requested Qty)

  • Definition: Items requested via Material Requests but not yet ordered.

  • Workflow Impact: Helps procurement teams prioritize purchasing.


4. Ordered Quantity (Ordered Qty)

  • Definition: Items with active Purchase Orders but not yet received.

  • Supplier Management: Tracks pending deliveries.


5. Reserved Quantity (Reserved Qty)

  • Definition: Items allocated to Sales Orders but not yet shipped.

  • Customer Service: Prevents overselling available stock.


6. Projected Quantity (Projected Qty)

  • Definition: The forecasted available stock after accounting for all pending transactions.

  • Calculation:


Projected Qty = Actual Qty + Planned Qty + Requested Qty + Ordered Qty - Reserved Qty  


  • Strategic Importance: Used for reorder point calculations and demand planning.



How to Use Stock Level Reports Effectively

1. Preventing Stockouts

  • Set up automatic alerts when Projected Quantity falls below safety stock levels.

  • Use the Reserved Qty column to identify committed inventory.


2. Optimizing Replenishment

  • Compare Ordered Qty vs Actual Qty to identify procurement delays.

  • Analyze Requested Qty to prioritize urgent purchases.


3. Production Planning

  • Monitor Planned Qty to ensure raw materials are available for scheduled manufacturing.

  • Use the report to balance inventory across multiple warehouses.



Advanced Features

1. Multi-Warehouse Views

Filter data by specific warehouses to:

  • Identify surplus stock for inter-warehouse transfers

  • Locate items closest to customers for faster fulfillment


2. Export Capabilities

Download reports in Excel/PDF for:

  • Supplier negotiations

  • Financial planning

  • Audit documentation


3. Integration with Reorder Points

The system can automatically:

  • Flag items needing reorder

  • Suggest order quantities based on lead times and demand patterns



    • Related Articles

    • Field-Level Permissions in iVendNext: Mastering Perm Levels

      Overview Not all fields in a document should be visible—or editable—by every user. With Field-Level Permissions and Perm Levels in iVendNext, you can: Hide sensitive fields (e.g., salary, cost prices). Make fields read-only for certain roles (e.g., ...

    • Operational Reports

      This article provides an overview of the key reports available in iVendNext. It also shows how to create custom reports and explains how to add, remove, and rearrange columns, apply both predefined and custom filters, and sort the data. Introduction ...

    • Understanding Reports and Dashboards

      Overview This article gives you an overview of iVendNext's reporting tools, showing how dashboards, charts, and number cards turn data into clear insights for smarter decisions. Key Takeaway: Dashboards provide real-time snapshots of business health, ...

    • Correlation between reports

      This article provides a comprehensive analysis of how POS sales, tender collections, and stock ledger reports interrelate to provide a holistic view of business performance. Introduction iVendNext is a comprehensive, web-based retail management ...

    • Creating and Managing Custom Reports

      Overview This article will guide you through the process of creating and managing custom reports in iVendNext. Why Create Custom Reports? Custom reports in iVendNext allow businesses to extract specific data points and analyze them in a way that ...