OFFICE 365: I am trying to generate an Inventory Summary table (list) with data the comes from three other SharePoint lists on the same site. I have a Procurement list, Inventory Receipt List, and an Inventory Usage list.
In the procurement list, I need to identify the number of unique entries to populate the Summary table, then load the total number ordered for each item. To that record, I need to add the total number received for each item from the Inventory Receipt list. Then I need to bring in the total number of each item used from the Inventory Usage list. From that I can calculate the number on hand and the number to be procured.
I have tried going through the Workflow option, but this is all new to me and I haven't been able to connect the dots. I was planning on using SPD, but I can't get the required access level to open the site in SPD. Any guidance would be greatly appreciated.