Hi,
I want to design a report that will tell me what item will be running out of stock and when in sequence.
I have a table that tells me when an item is going to be used and how much of it.
I have another table that has the current stock of all the items.
What I would like to design is a report grouped by month then by item, that will show me when the item will run out of stock in the correct date sequence and by how much such as this table below. I am not sure how to build this however. Later one I will group that report by vendor as well.