Purchase Order Report - Report for Goods Received

I was looking for a 'Delivered Purchase order report' - basically one that had all of the Goods Received Note details on it, but it also included POP items too from the original PO.

The standard GRN reports exclude things like price, etc. which is what i was needing in the report.

So that when it comes to month-end, i can run a report that shows me all my goods received (Purchase order number, purchase order date, goods received number, goods received date, goods received value, goods received quantity... i can then summarise this at GRN level or line level.)  This enables me to compare it with my purchase ledger as a double-check to ensure i have received purchase invoices for all deliveries (and conversely, that i have received all deliveries that i have been invoiced for by suppliers).

I couldn't find a way to get this report, so one of the stars in the report design team (Angela Sheehy, I'm looking at you! :) ) helped me to design a custom report for this and it gives me what i want.

However, i've run into an issue whereby the report must look at historical data - i guess when POP items are placed 'on-order', it must save it to a data table... so if our purchasing team edit any of these PO's afterwards (add/remove items), the report will not reflect this, so it reports inaccurately... ie. it doesn't report on the 'live' data as per what is on sage right now.

does anyone have any experience with this?