Deferred Revenue Balance Aging Search

1.  Login to Administrator role
2.  Navigate to Transactions>Management>Saved Searches>New
3.  Click on Revenue Recognition Schedules
4.  On Criteria tab>Standard subtab

Status is set to None of Complete

5.  On Results tab>Column subtab

- Transaction fields...Name
---- Summary Type is Group

- Formula (Currency)
---- Summary Type is Sum
---  Formula - case when trunc({today})-{scheddate} between 1 and 30 then {deferredamount} end
---- Custom Label - 1-30 Days

- Formula (Currency)
---- Summary Type is Sum
---  Formula - case when trunc({today})-{scheddate} between 31 and 60 then {deferredamount} end
---- Custom Label – 31-60 Days

- Formula (Currency)
---- Summary Type is Sum
---  Formula - case when trunc({today})-{scheddate} between 61 and 90 then {deferredamount} end
---- Custom Label – 61-90 Days

- Formula (Currency)
---- Summary Type is Sum
---  Formula - case when trunc({today})-{scheddate} > 90 then {deferredamount} end
---- Custom Label – > 90 Days

- Remaining Deferred Balance
---- Summary Type is Sum

6.  Enter the Name of the search
7.  Click Save and Run