kpopov
Member
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.
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.