Thursday, 26 June 2025

Query to find receipt number from Invoice number (link between ra_customer_trx_all and r_cash_receipts_all)

 SELECT
    acra.receipt_number,
    rcta.trx_number
FROM
    ar_receivable_applications_all  araa,
    ar_cash_receipts_all            acra,
    ra_customer_trx_all             rcta
WHERE
        araa.status = 'APP'
    AND araa.cash_receipt_id = acra.cash_receipt_id
    AND araa.applied_customer_trx_id = rcta.customer_trx_id
    --AND rct.customer_trx_id IN (1111111 )
    AND rcta.trx_number = '1111111'
;

No comments:

Post a Comment