Template
Dynamic inventory
This app shows how to get current stock from sales and purchases
Industry:
n/a
In a business, you often want to keep track of the current stock of your products. The current stock is equal to the number stocked minus the number sold. This app shows how to do it.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We've got three tables:
- Products
- Purchases (additions to the inventory)
- Sales (subtractions from the inventory)
Each row of the Purchases table represents an item that was purchased and added to the current stock. Each row of the Sales table represents an item that was sold to a customer.
We created a Current Stock virtual column on the Products table. This will compute the current level of inventory. To do this, we simply count the number of related Purchases and Sales and subtract them:
COUNT([Related Purchases]) - COUNT([Related Sales])
We also used the "repeat scan" to make for rapid barcode scans of incoming purchases and outgoing sales.
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...