Create a summary list of items sold

I need a summary of all the items sold and not manufactured yet with the number required for each item.
Is that possible?

John