Thursday, 23 July 2026

Query to find AR invoice Amount

 SELECT
    rcta.trx_number,
    rcta.trx_date,
    rcta.creation_date,
    apsa.amount_due_original,
    apsa.amount_line_items_original,
    apsa.tax_original
FROM
    ra_customer_trx_all       rcta,
    ar_payment_schedules_all  apsa
WHERE
        1 = 1
    AND rcta.customer_trx_id = apsa.customer_trx_id
    AND rcta.trx_number = '70682380'
    ;

No comments:

Post a Comment