Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
R13 Query Open AR Invoices — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

R13 Query Open AR Invoices

Accepted answer
edited Jun 13, 2020 1:02AM in Reporting and Analytics for ERP 7 comments


AR Cloud Report


Hello :

I was wondering if you can hep me about an AR Invoices Report for Cloud.

Please Advise

Below is the SQL but it only works for EBS R12, I was wondering if you can share with me , something similar for Cloud
/* Query to fetch summary data*/
SELECT hc.cust_account_id            
      ,min(hc.account_number)         customer_number
      ,sum(amount_due_remaining)      amount_due_remaining
      ,sum(aps.amount_due_original)   amount_due_original
      ,count(aps.payment_schedule_id) open_invoices
  FROM ra_customer_trx_all       ra,
       ra_customer_trx_lines_all rl,
       ar_payment_schedules_all  aps,

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!