In case of 3 way matching, missing linkage between PO, Receipt and Invoice at line level
Summary:
PO has receipt but when searching in the invoice workbench to match invoice with PO and Receipt then the search results with no data.
We need to match the invoice line with receipt to establish a direct link with invoice and receipt for our custom report.
Content (please ensure you mask any confidential information):
We have a PO, against which, few receipts have been issued based on quantity received and they have been partially/ fully invoiced. Having said that, we need to display the PO#, corresponding receipt# and how much is received, invoiced and un-invoiced quantity against the receipt. So, we need to identify what are the invoices engaged against the specific receipt and here lies the problem. While checking from back end, we can map the invoices which have been issued against the PO. Again, we can map the receipts against the PO. But we are unable to link between receipt and invoice