Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary

AR Cloud Report

Content

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,
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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