PO Receipts Report

I'm trying to create a report in Crystal Reports, based on the F43121 table. I need to show all receipts for material as soon as it is received at our dock (even if the invoice has not been paid yet).

I figured out that I'll need to look only at PRDCT = OV records, but there are multiple records for some PO line items with different PRDOC numbers and different status codes PRLTTR and PRNXTR.

How can I tell which record for a specific PO line is the most current receipt? What if there are multiple valid receipts for partial shipments?

Any help will be greatly appreciated.

Thanks.

PRNLIN is incremented with each receipt. The first receipt against a line will have the value 1, the second receipt will have a value of 2, ...