Template
Location Inventory Tracking
An app to help track inventory at various locations
This app is a ready-made solution for anyone looking for a way to track inventory at locations. While not as fully-functional as it could be, this app features everything needed to completely track inventory for multiple locations over a long span of time.
This is a (Premium-Lite) app; meaning it's not a fully-fledged platform on which you can run your business (or a certain part of you business).
- This app handles only a portion of that load: the record keeping of "what went where, when, who received it, how much is there, how much the count at that location has changed over time."
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
This app features several hierarchies inside it:
- The Audit table sits over every data-collection table (helping facilitate security filters)
- Orders
- OrderDetails
- Monthly Summaries
- Location Inventory Monthly Summaries
- Location Inventory
- Location Inventory Adjustments
There are also a couple of supporting tables:
- Products
- Locations
----------------------------------------------------------------------
You take (Locations) and make (Orders) for them, creating (OrderDetails) about what (Product) and how much, which are then received and a (Location Inventory) record is made/updated. Every month a (Monthly Summary) is created, with individual (Location Inventory Monthly Summaries) created for each location's active inventory. All of these tables are connected to an (Audit) group; so when you've collected too much data in your app, and it's starting to run slow and hard, you can archive that old data and "start fresh" - but not really from scratch, as you've already got counts, and those are maintained.
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...