Purchase Orders can have many line items and many projects. I would like to create a summary report that totals the Purchase Order line items of the current Project only. PO 1=$500 however it is divided between 2 projects. When I view Project A, I would like to Line item to total $200 based on a filter of "current project" (Project A in this case). Is this possible?
PO 1- Material 200
PO 1-Labor 300