In this blog we are going to see sample SQL of AR Aging Statement. There is a seeded report for AR Aging Statement, but that is very complex and in case if any customization needed it will be very difficult to do that. So I have prepared below SQL for AR Aging Statement (7 bucket) report which picks all open Invoices, Credit Memos, Debit Memos and Unapplied Payments. SQL: with ar_txn as ( select rt . type Transaction_Type , hp . party_name Customer_Name , hp . party_number Customer_Number , aps . due_date , addr . city city , hps_bill . party_site_number , aps . gl_date , coalesce (: p_as_of_date , sysdate ) - aps . due_date total_days , ra . trx_date Transaction_Date , ra . trx_number Transaction_Number , aps . amount_due_original , aps . amount_due_remaining from ra_customer_trx_all ra , ar_payment_schedules_all aps , ra_cust_trx_types_all rt , hz_cust_accounts h...