Item Master
Item Master - User Guide
1. Introduction đ
The Item Master is the core database of all materials and services your business handles. This includes Raw Materials (RM), Work-in-Progress (WIP), Finished Goods (FG), and even Service Items. It defines how items are categorized, taxed, stocked, and moved across your organization.
Key Objectives of Item Master:
- Inventory Control: Define safety levels and re-order triggers.
- Statutory Accuracy: Link HSN codes and GST rates for automated invoicing.
- Logistics Management: Track storage locations (Racks) and packing standards.
- Unit Conversions: Manage procurement in one unit (e.g., Kgs) while stocking in another (e.g., Sheets).
2. Getting Started with Item Master đ
Accessing the Module
To access the Item Master module, navigate to the Common Masters > Item section from the main menu.
The Index Page
Upon opening, the Index Page displays a comprehensive list of all parts and services. Here, you can:
- Search/Filter: Look for items by Item Id, Group Code, Name, Short Name, or Active Status using expandable filter panels.
- Navigation: Click on an Item Id to view detailed configurations.
- Bulk Management: Access Create New, Export to Excel, and Import tools.
- Export Filter Prompt: When clicking Export To Excel, the system opens an option selector prompting you to choose between Active (
Y) or InActive (N) items, ensuring downloaded spreadsheets match your reporting scope.

Item Master Details & Operational Shortcuts
The Details view provides deep lifecycle management and data validation:
- Core Info: Manage Item Name, Short Name, Group, Segment, Category, and Class classifications.
- Statutory: Link the statutory HSN / SAC Code and GST rate percentage.
- Units: Define UOM-1 (Standard base unit) and UOM-2 (Alternate procurement/sales unit) with conversion math.
- Check Duplicate Item: Launches an immediate duplicate check dialog to compare the item name against existing items in the database, preventing accidental re-creation of existing catalog products.
- Modify Rack Info Shortcut: For active items, provides a direct link (
/itemmstmodifyrackinfo) to adjust storage rack locations and standard packaging parameters quickly without reopening the full master form. - Re-Activate Item: For inactive items (
IsActive == 'N'), provides an instant re-activation action.

Other Features & Auxiliary Masters
Clicking “Other Features” opens a portal to specialized configuration and bulk update tools:
- Classification Masters: Direct links to Group Master, Segment Master, Class Master, Category Master, and HSN Master.
- Measurement Master: Direct link to UOM Master (Unit of Measure configurations).
- Inventory Balancing: Direct access to IIRS Stock Adjustment (
/iirsadjuststockindex) for inventory reconciliation. - Specialized Spreadsheet Workflows: Links for updating Safety Stock (
itemmstimport/S), deactivating items (itemmstimport/D), updating rack information (itemmstimport/R), and bulk updating general item fields (itemmstimport/M).

3. Structural Breakdown đī¸
Each item is defined by a multi-layered classification system:
- Unique Identity:
ItemId(Auto-generated 6-digit code). - Classification Hierarchy:
- Group: High-level grouping (e.g., Metals, Electronics).
- Segment/Category: Internal classification for reporting.
- Class: Determines if the item is a core product, a freight item, or a service.
- UOM Management:
- Standard UOM: The base unit for stock valuation.
- Alternate UOM: Used for procurement or sales.
- Conversion Factor: The math used to convert Alt UOM to Std UOM.
- Statutory Data: Mandatory HSN/SAC Code and applicable GST Rate percentage.
4. Inventory & Logistics Controls âī¸
The system uses these parameters to drive automated alerts and reports:
| Feature | Description |
|---|---|
| Re-Order Level (ROL) | When stock falls below this number, the system triggers replenishment alerts. |
| Safety Stock Qty | The “buffer” stock maintained to avoid stock-outs during lead-time variances. |
| Minimum Order Qty (EOQ) | The lowest quantity you typically order to maintain cost-efficiency. |
| Lead Time | The expected number of days (0-180) it takes to receive the item after ordering. |
| Rack Info | Specific physical storage location within the warehouse. |
5. Bulk Management & System Updates đ
Given the volume of catalog records, the module provides specialized spreadsheet-driven bulk tools:
- Item Master Import (New): Upload new items in bulk using
ImportItemMst.xlsx, validated against a 16-factor audit (AâP codes) verifying GST rates, UOM validity, HSN existence, and field lengths. - Specialized Bulk Operations:
- Safety Stock Update (
UpdateSafetyStock.xlsx): Adjust minimum buffer inventory quantities across multiple items.â ī¸Safety Stock Overwrite Alert: When importingUpdateSafetyStock.xlsx, the system will erase existing Safety Stock quantities for all items and replace them strictly with the values provided in your spreadsheet. Items omitted from the sheet will have their safety stock cleared. - Rack Info Update (
UpdateRackInfo.xlsx): Bulk map or relocate items across warehouse storage racks. - Bulk Deactivation (
DeactivateItem.xlsx): Deactivate obsolete parts and log mandatory deactivation reasons in the system audit log. - Bulk Master Update (
BulkUpdateItemMst.xlsx): Modify classifications, names, and operational parameters for existing items.
- Safety Stock Update (
6. Lifecycle & Data Integrity đ
đĢ Deletion Safety (Deep Audit)
The Item Master uses a “Full System Scan” before allowing a deletion. The system checks:
- Active BOMs (Bill of Materials).
- Pending Purchase/Sales Orders.
- Job Work or Production Plans.
- Stock Ledger (Transactions). If any record uses the Item ID, deletion is blocked. In such cases, the item should be marked “Inactive” instead.
â Release Status & Criticality
- Release Status: Determines if an item is ready for operational use (Sales/Purchase).
- Is Critical: Flags high-value or long-lead-time items for intensified tracking in inventory reports.
7. Integration Points đ
The Item Master is a prerequisite for:
- BOM Management: Items are the “ingredients” for your products.
- Quality Protocols: QC parameters are linked to specific Item IDs.
- Price Lists: Standard costs and selling prices are mapped per item.
8. Best Practices đĄ
- Consistent Short Names: Use Short Names that follow a pattern (e.g.,
RM-MAT-01) for faster searching during transaction entry. - Accuracy of Conversion Factors: Ensure the conversion between Alt and Std UOM is exact, as this impacts financial valuation.
- Deactivation over Deletion: If an item has history, never try to delete it; simply deactivate it to preserve historical reports.