We have a customization, where in the uninvoiced receipt report we need to show the receipt date as well as receipt number. Can anyone tell me the screen in the application wherein I can get the receipts (after a purchase order is received) against which no invoice is matched. I was trying to link the table rcv_transactions with ap_invoice_distributions_all, but neither we have rcv_transaction_id column populated in ap_invoice_distributions_all nor do we have invoice_id populated in rcv_transactions. Any other way to find out which invoice has been generated against which receipt?
Also let me know, if there is any way to find this information other than the above two tables.
Thanking you for all your help and time in advance. Any help will be really appreciated.
One option is to start with those records in po_distributions_all for whom no matchin record exists in ap_invoice_distribution_all. And then you can use the po_distribution_id (or po_line_location_id) to get the receipt information from rcv_transactions.