Prepayment transactions for TDS eligible invoices - Unable to Link Return TDS Inv and CM
When we create a Prepayment type of transaction for a TDS eligible supplier. It creates below 4 transactions:
Standard TDS Invoice
Standard TDS CM
Return TDS invoice
Return TDS CM
I am able to find the link between original Prepayment invoice and Standard TDS Invoice and Standard TDS CM from the TDS table using the below query
select DM_INVOICE_NUM "Standard TDS CM", TDS_INVOICE_NUM "Standard TDS Invoice"
from jai_ap_tds_invoices
where 1=1
and invoice_id = "Invoice ID of prepayment Invoice"
;
How and where can I can find the link between the original Prepayment invoice/ Standard TDS Invoice and the related Return TDS Invoice and CM?