Saved Search to Re-create A/R Aging Summary Report

1. Navigate to Reports > Saved Searches > All Saved Searches > New > Click on Transactions

2. Under Criteria tab > Standard sub tab set the following:

a. Account Type: is any of Accounts Receivable
b. Status is none of Invoice: Paid in Full , Invoice: Pending Approval
c. Amount Remaining = is not equal to 0.00

3. On the Results tab > Columns sub tab > Click Remove All button and then add the following:

Set Show Totals = T

a. Formula (Currency) 
Set Summary Type = Sum

Formula:
case when trunc({today})-{duedate} < 0 then {amount} end

Custom Label: Current

 
b. Formula (Currency)
Set Summary Type = Sum

Formula: 
case when trunc({today})-{duedate} between 1 and 30 then {amount} end

Custom Label:  1-30
 
c. Formula (Currency)
Set Summary Type = Sum
 
Formula: 
case when trunc({today})-{duedate} between 31 and 60 then {amount} end

Custom Label: 31-60
 
d. Formula (Currency)
Set Summary Type = Sum

Formula:  
case when trunc({today})-{duedate} between 61 and 90 then {amount} end

Custom Label: 61-90
 
e. Formula (Currency)
Set Summary Type = Sum

Formula:  
case when trunc({today})-{duedate} > 90 then {amount} end

Custom Label: Over 91
 
f. Formula (Currency)
Set Summary Type = Sum

Formula:  
NVL(case when trunc({today})-{duedate} < 0 then {amount} end,0)+ NVL(case when trunc({today})-{duedate} between 1 and 30 then {amount} end,0) + NVL(case when trunc({today})-{duedate} between 31 and 60 then {amount} end,0) + NVL( case when trunc({today})-{duedate} between 61 and 90 then {amount} end ,0)+ NVL(case when trunc({today})-{duedate} > 91 then {amount} end,0)
 
Custom Label: Total Outstanding
 

4. Add a Search title eg. A/R Aging Summary Search
5. Click on Save & Run