06 · Power Apps · SQL
Inventory and procurement
Technicians stop because the material is not there.
See the shortage, the reorder advice and place the order in the same session.
Demo on fictional data — never customer data.
Reorder advice = four weeks of use, minus stock, minus open orders. MAT-0087 belongs to PRJ-0087.
MAT-0087 · YMvK cable 5×2.5
On hand 12 · advice 60 · PRJ-0087
MAT-0048 · Distribution board 48
On hand 0 · advice 4
MAT-0151 · Valve 151
On hand 0 · advice 48
MAT-0175 · Valve 175
On hand 0 · advice 40
MAT-0229 · Luminaire 229
On hand 0 · advice 4
MAT-0237 · Luminaire 237
On hand 0 · advice 4
MAT-0254 · Filter 254
On hand 0 · advice 32
MAT-0314 · Sensor 314
On hand 0 · advice 16
MAT-0343 · Valve 343
On hand 0 · advice 4
The current buy price of the cable on PRJ-0087 is €180. The invoice further on uses that higher price.
SELECT sku,
on_hand,
weekly_use * lead_days / 7 + weekly_use AS reorder_point
FROM product
WHERE on_hand < weekly_use * lead_days / 7 + weekly_use;