Projects
Projects
Not a showcase demo, but the inventory system a real company relies on every single day.
Every serial number can be traced, from the day it arrives to the day it's used.
In surveillance maintenance, spare parts sit in clients' warehouses, faulty units need warranty tracking, and clients are billed every month by completion date — it all used to live in stacks of Excel sheets, reconciled line by line for years, where one wrong cell meant one payment never collected.
Once it came into my hands, we rethought the whole flow: scan and it's stocked, consignment stock adds up, month-end runs from start to finish in one flow, no duplicates, nothing lost, nothing left unbilled.
It runs every day now, and when month-end comes, I'm right there to close the books together.
Scan serial numbers with the phone camera, and stock-in, transfers and returns flow in one motion; every serial number's whole story is kept in the log.
Spare parts kept in clients' warehouses are still ours: available ＝ in-house stock ＋ consignment stock, with a gentle reminder before it runs low.
Import list → generate vouchers → trial settlement → invoice → create batch → close the books. Seven steps in order, each one checked before the next click.
Closed months are triple-locked and can't be edited or deleted; warranty and new-unit failures are automatically marked as non-billable.
Enter a serial number to see whether it's under warranty, which batch it came from and how many times it's been swapped; faulty units are followed all the way until their replacements return.
“How many of this model are left?” Just ask. A local model looks it up in the database and answers, and the data never leaves home.
All screens are real system screenshots; clients, contacts, serial numbers, amounts and locations have been replaced with demo data.