Asset Management Module
End-to-end asset tracking across dairy, MCC and VLCC levels with batch transfers, bulk Excel uploads, one-step receiving and full audit logs.
Overview
I owned the Asset Management module end to end: registration, transfer, reassignment, receiving, tracking history and logs for assets moving between the dairy, milk collection centres (MCC) and village-level centres (VLCC).
The challenge
Assets move in large numbers between centres. Receiving them one by one was slow and error-prone, bulk changes had to stay auditable, and the new design had to work with years of existing records.
What I built
- Batch transfer: every asset dispatched in one action shares a batch identity, so the receiving centre accepts the whole consignment in a single step with one receiving document.
- Bulk Excel transfer: users download a template, fill it in and upload it. Each row is validated, the transfer runs, and every row reports its own outcome, so one bad row never blocks the rest.
- Audit trail: Excel import/export plus transfer logs with a detail view, so every bulk action can be reviewed after the fact.
- Back end: stored procedures, schema changes and .NET endpoints designed so existing records keep working without any data backfill.
Result
Centres can move and receive whole consignments in one step, bulk work is fast but fully auditable, and existing records kept working without a data backfill.