Store & Purchase Management System
Fully automated material procurement lifecycle.
Inventory Stock Allocation Ledger
Live stock allocations showing Reserved for active requisitions vs Available balance
Material Details Gross Stock Reserved Stock Available Stock Material Ageing Profile (Days) Alert Level Status
MAT-CEM-OPC53
Cement OPC 53 Grade
UltraTech Cement · Bags
 4,500 500 4,000
0-30d: 60% 31-90d: 30% 91d+: 10%
Adequate
MAT-STL-TMT16
TMT Reinforcement Steel 16mm
Tata Tiscon · MT
 120 25 95
0-30d: 60% 31-90d: 30% 91d+: 10%
Adequate
MAT-AGG-20MM
Coarse Aggregates 20mm
Titan Aggregates · CU.M
 1,500 500 1,000
0-30d: 60% 31-90d: 30% 91d+: 10%
Adequate
MAT biT biT60
Paving bitumen 60/70
IOCL bitumen · Drums
 35 0 35
0-30d: 60% 31-90d: 30% 91d+: 10%
Low Stock Outbreak
MAT-PIP-PVC4IN
PVC Plumbing Pipe 4" (6m)
Supreme Pipes · PCS
 850 25 825
0-30d: 60% 31-90d: 30% 91d+: 10%
Adequate
Quality Batch & Expiry Tracker
Tracking concrete batches, reinforcement logs, and perishable chemical expirations
Material Details Batch Number Serial / Manufacturer Log Expiry Date Quality Status
Cement OPC 53 Grade
UltraTech Cement
 BCH-2026-032 SR-0-889 2026-11-15 QC Certified Passed
TMT Reinforcement Steel 16mm
Tata Tiscon
 BCH-2026-033 SR-22-889 No Perishable Expiry QC Certified Passed
Coarse Aggregates 20mm
Titan Aggregates
 BCH-2026-034 SR-44-889 No Perishable Expiry QC Certified Passed
Paving Bitumen 60/70
IOCL Bitumen
 BCH-2026-035 SR-66-889 2026-11-15 QC Certified Passed
PVC Plumbing Pipe 4" (6m)
Supreme Pipes
 BCH-2026-036 SR-88-889 No Perishable Expiry QC Certified Passed
Stock Transactions & Audit Logs
Every single stock dispatch, receipt, consumption, or transfer tracked with driver and vehicle indices
5 Log Entries
Log Date & Time Warehouse Depot Transaction Type Material Details Qty Log Closing Balance Action Source (Ref) Authorized User
2026-07-01 Chennai Yard Purchase Cement OPC 53 Grade +5,000 5,000 OB-2026 System
2026-07-20 Chennai Yard Consumption Cement OPC 53 Grade -1,200 3,800 ALC-001 Vignesh Kumar
2026-07-22 Chennai Yard Transfer Cement OPC 53 Grade -500 3,300 XFR-001 Vignesh Kumar
2026-07-23 Villupuram Yard Transfer Cement OPC 53 Grade +500 500 XFR-001 K. Subramaniam
2026-07-25 Villupuram Yard Purchase Paving Bitumen 60/70 +48 48 GRN-2026-001 K. Subramaniam