Inventory and Fulfilment template
Follow orders, SKU stock, picking, reservations and documented dispatch checks. Fictional example: 60 linked records, 20 views, three dashboards, three private forms and nine paused workflows after installation.
Tables
Dispatch lines
Dispatch line, Reference, Status, Product family, Priority, Customer order, Stock item, Region, Evidence reference, Pick and dispatch evidence reviewed, Dispatch hold, Human decision reference, Picking bin reference, Recorded dispatch reference and 14 more
Customer orders
Customer order, Reference, Status, Region, Internal planning allocation (€), Start date, Due date, Stock item, Dispatch lines, Linked work items, Linked dispatch line amounts (€), Planning allocation difference (€), Notes
Stock items
Stock item, Product family, Status, Physical on hand (pieces), Physical reserved (pieces), Available physical (pieces), Next stock count, Example contact, Expected receipt (pieces), Example reorder point (pieces), Dispatch lines, Assigned work items, Notes
Stock reviews
Stock review, Status, Dispatch line, Customer order, Stock item, Review evidence reference, Example reviewer, Product family, Priority, Due date, Recorded quantity discrepancy (pieces), Example discrepancy target (pieces), Checks with matched quantities, Follow-up required and 2 more
Follow-up actions
Action, Status, Dispatch line, Customer order, Stock review, Follow-up evidence reference, Stock item, Priority, Due date, Effort (hours), Completed, Days overdue, Notes
Views
- All records (grid)
- Status board (kanban)
- Schedule (calendar)
- All records (grid)
- Status board (kanban)
- Schedule (calendar)
- All records (grid)
- Status board (kanban)
- Schedule (calendar)
- All records (grid)
- Status board (kanban)
- Schedule (calendar)
- …and 8 more
Forms
- Register a dispatch line
- Record a stock check
- Record a review follow-up
Automations
- Recorded review gap creates a traceable follow-up
- New work intake notification
- Documented approval records completion
- Completion closes the follow-up
- Recorded reservations exceed physical stock
- Daily overdue follow-up digest
- “Stock reviews” reached “Accepted”
- Daily sweep — still open in “Dispatch lines”
- Large value in “Requested pieces”
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.