Purchase Order Report w/ Item Details
It would be really helpful to have a way to run a purchase order report with details on the items and quantities. I want to be able to send each vendor a list of open orders with:
* Items on Order
* Qty on Order (still open)
* Due Date
The report could be simple, like this:
PO # - Item ID - Description - Qty - Due Date
PO 1234 - 4466 - White t-shirt - 5,000 - 6/1/15
PO 1234 - 4467 - Green t-shirt - 1,000 - 6/1/15
PO 1234 - 4468 - Blue t-shirt - 2,000 - 6/1/15
PO 1235 - 4469 - Yellow t-shirt - 8,000 - 7/15/15
Currently I copy all of the information into Excel and create a pivot table report.
Thank you!
Allison