Build Cloud Inventory Management App with PowerApps and SharePoint
Budget: $250 – $750 AUD
.very basic app required,
.Main home screen with 4 buttons
"Edit Stock" Button = increase or decrease the levels of stock available in the storeroom
"Use Stock" Button = move stock from the storeroom to the "used" report
"Reports" Button = date range reports to show when stock is increased or used per product or all products
"Edit Product" Button = add, edit, enable or disable a product
"Edit Stock" gives you a drop-down menu of products and you can increase or decreases the amount on hand in the storeroom and select a date that it was changed and notes. ie stock take count
"Use stock" gives you a drop-down menu & a search menu to look up products once you choose a product you can choose the number of items to move from the storeroom to used and the date it was moved
"reports" you can choose either all products or a single products from the drop down menu and then choose either "all" or custom dates and then the type of report "used", "in stock" , "Delivered" or stocktake
stocktake will show a list of all enabled products and the quantiles on hand and a space to wright a number
"Edit products" scrolls current products you can select the product that you want to edit the description or enable/disable it from all other menus/ reports, at the top of the list should be "Add Products"
when you add a product, it will ask for Supplier code. product code, description, Unit type,
see attached for example
.Main home screen with 4 buttons
"Edit Stock" Button = increase or decrease the levels of stock available in the storeroom
"Use Stock" Button = move stock from the storeroom to the "used" report
"Reports" Button = date range reports to show when stock is increased or used per product or all products
"Edit Product" Button = add, edit, enable or disable a product
"Edit Stock" gives you a drop-down menu of products and you can increase or decreases the amount on hand in the storeroom and select a date that it was changed and notes. ie stock take count
"Use stock" gives you a drop-down menu & a search menu to look up products once you choose a product you can choose the number of items to move from the storeroom to used and the date it was moved
"reports" you can choose either all products or a single products from the drop down menu and then choose either "all" or custom dates and then the type of report "used", "in stock" , "Delivered" or stocktake
stocktake will show a list of all enabled products and the quantiles on hand and a space to wright a number
"Edit products" scrolls current products you can select the product that you want to edit the description or enable/disable it from all other menus/ reports, at the top of the list should be "Add Products"
when you add a product, it will ask for Supplier code. product code, description, Unit type,
see attached for example