I need to create a Purchase Order tracker. There are a few parameters that I'm unsure how to account for in building the solution.
Our system allows multiple items to be ordered under a single PO number (could be 1 item, could be 20+ items - all various types, prices, etc).
I need to track/count the quantities of the individual items ordered, annually (example - 2 monitors ordered today, 250 total for 2017)
I need to track the total amount spent by each department, annually.
All items have fluctuating prices.
I appreciate any help. Thank you!