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 Category | Key Fields Visible |
|---|---|
| Material Details | Item ID, Item Short Name, Brand, Stage (RM/PM/SA), and HSN Code. |
| Quantities | User Qty, Final Qty, Standard UOM, and Alternate UOM (with conversion factors). |
| Procurement Audit | Requestor ID, Authorization Status, Lead Time, and Indent Status (Open/In Process/Closed). |
| Partner Info | Preferred Party Group, Party Name, and Payment Terms. |
4. Source Transactions đ
The report engine integrates data from the following transaction points:
- Purchase Indent Module: Primary source for requirements, requested quantities, and delivery schedules.
- Indent Status Configurations: Tracks the lifecycle stage of each request.
- Goods Receipt Note (GRN): Deducts fulfilled quantities to calculate net pending balances in real time.
- 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.