Indent Analysis Report

Indent Analysis Report - User Guide

1. Introduction 📝

The Indent Analysis Report is a critical tool for the Procurement and Supply Chain departments. It tracks internal purchase requisitions (Indents) from the point of creation to their conversion into a Purchase Order or Goods Receipt.

â„šī¸

Purpose of this Report:

  • Pipeline Visibility: Monitor all active and historical purchase requests.
  • Lead Time Management: Identify delays in the procurement cycle using color-coded aging.
  • Fulfillment Tracking: Ensuring that critical raw materials or components are ordered on time.
  • Audit Trail: Review authorization status and specialized project notes for each request.

This module is primarily used by Purchase Managers, Store Keepers, and Production Planners.


2. Report Types & Performance Indicators 🚀

Option A: Pending Indent Report

  • Purpose: Focuses on active, unfulfilled requisitions that remain open in the procurement pipeline.
  • Unique Feature: Visual Aging System:
    • The system compares the Aging (days since request) against the Lead Time (expected fulfillment window) to assign a status color:
    • đŸŸĸ Green: Under 33% of Lead Time (Safe).
    • 🟡 Yellow: 33% to 66% of Lead Time (Monitor).
    • 🔴 Red: 66% to 100% of Lead Time (Urgent).
    • âšĢ Black: Exceeding Lead Time (Escalate).
  • Key Data: Required-by Date, Expected Delivery Date, Aging Days, and Remaining Pending Quantity.

Option B: Indent Register Report

  • Purpose: A comprehensive historical register of all indents created within the chosen date range.
  • Currency Flexibility: Can be viewed in Base Currency (INR) or Foreign Currency for imported components.
  • Key Data: Indent Number, Item/Brand details, Stage, Ordered Quantity, Cost Master Rate, Total Amount, and follow-up notes.

3. Data Visibility & Insights 🔍

Data CategoryKey Fields Visible
Material DetailsItem ID, Item Short Name, Brand, Stage (RM/PM/SA), and HSN Code.
QuantitiesUser Qty, Final Qty, Standard UOM, and Alternate UOM (with conversion factors).
Procurement AuditRequestor ID, Authorization Status, Lead Time, and Indent Status (Open/In Process/Closed).
Partner InfoPreferred Party Group, Party Name, and Payment Terms.

4. Source Transactions 🔄

The report engine integrates data from the following transaction points:

  1. Purchase Indent Module: Primary source for requirements, requested quantities, and delivery schedules.
  2. Indent Status Configurations: Tracks the lifecycle stage of each request.
  3. Goods Receipt Note (GRN): Deducts fulfilled quantities to calculate net pending balances in real time.
  4. Inventory Master: Provides standard lead times, alternate UOM conversions, and item category classifications.

5. Report Options & Filters đŸ› ī¸

  • Report Type: Select between Pending Indent (Option A) and Indent Register (Option B).
  • Filter Criteria: Filter results across 5 distinct levels:
    • All (0): Complete organization-wide dataset.
    • Party Group (1): Grouped by vendor category.
    • Party Name (2): Specific supplier requisitions.
    • Item Group (3): Specific material classification (e.g., Raw Materials, Consumables).
    • Item Name (4): Specific component or item.
  • Unit Filter: Consolidate across all operating locations or isolate a single plant.
  • Authorization Status: Filter by Authorized (approved requisitions) or Pending Approval (awaiting manager authorization).

6. Best Practices / Tips 💡

  • Identify Critical Bottlenecks: Regularly filter the Pending Indent Report for Black and Red color codes to prevent production shutdowns due to missing materials.
  • Validate Lead Times: If items consistently show up as “Black” despite prompt ordering, the Lead Time in your Item Master may need to be updated to match current market conditions.
  • Alternate UOM Monitoring: In the Indent Register, pay close attention to the Qty1 (Alternate Qty) column if you buy in one unit (e.g., Tons) but consume in another (e.g., Kilograms).
  • Notes Audit: Review the Non-Standard Note column for any special instructions or deviations requested by the user.