Hi,
I am creating an inventory management workflow. Components:
Materials List/Table
Contains ~200 SKUs/items that we order. Unique identifier is Material number. Also includes Qty/pack, Unit Price, Material Description, Expiration, etc...
Consumption/Ordering Tool
Tabular Datapage that lists each item, # consumed in last X Days, and some calculations, based on consumption rates, how many would need to be ordered to replace what was consumed, for X number of Days (User Defined)
Final piece I'm having trouble figuring out is a simple way for user to count and document how many are still in stock - and then be able to factor that into calculation for how much to order. At a high level - I envisioned a template/form/datapage that starts with the materials list, where user can add a Qty for each item, and the count would be date stamped and its history not lost. Can't get my head around how to get a form to work - because they are designed to update single records - and the workflow requires entering a QTY for ~ 200 unique items. Maybe its a seperate table - just don't know how to make the data entry easy, i.e. user doesn't have to select/add each item to count (like a shopping cart) - the list of items is there at beginning and they just fill in the blanks and then how to reference it and perform calculations based on the counts. I have attached a smample of Materials table and Tabular Datapage layout for reference.
Thx in advance for any assistance...
Materials_2020-May-26_1541.zip
Material Consumption Datapage.xlsx