Project Inventory template
Materials and products consumed by each project: a material catalogue with validated EAN-13 barcodes and HS codes, projects carrying a material allowance, and an issue log that prices every drawdown and rolls it up per project so spend can be read against budget while the job runs.
Tables
Projects
Project code, Project, Status, Project manager, City, Material budget, Start, Planned completion, Material issues, Issues raised, Material spend, Budget used %, Notes
Materials
Material code, Material, Group, Unit, Unit cost, EAN-13, HS code, Central stock, Reorder level, Stock value, Stock status, Material issues, Quantity issued, Notes
Material issues
Issue reference, Project, Project record, Project manager, Material, Material record, Unit cost, Quantity, Issued on, Reason, Issued by, Issue value, Chargeable to, Notes
Views
- Issue log (grid)
- Issues by reason (kanban)
- Issue calendar (calendar)
- Spend by project (chart)
- Material catalogue (grid)
- Stock by group (kanban)
- Projects (grid)
- Project programme (timeline)
Forms
- Request materials for a project
Automations
- Notify the store on a new request
- Email purchasing when a material changes
- Daily reorder sweep
- “Projects” reached “Complete”
- Daily sweep — still open in “Projects”
- Large value in “Quantity”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.