Query
Hoping to find you well. I was exploring the Aging Options functionality found on your typical A/R or A/P Summary report.
In my specific scenario, I am looking into the A/P side of things. When creating a custom Summary Aging report, upon previewing, at the bottom, where the filtering section is located, one may notice an Aging Options button, which would allow the user to specify any aging related brackets.
Trying to do the same thing (i.e. enabling grouping of amounts based on aging brackets) in the corresponding Details report, does not seem to be possible, or at least, I did not manage to find a suitable way of doing so.
As a result of this, my query is two-fold:
a) Is this requirement even possible to achieve at details level, using the Report Builder?
b) If it is achievable, would it be possible to guide me to either the documentation which outlines the process, or alternatively, what option to search in the Filtering section of the report which would ultimately enable this functionality, please?
Solution
ou won’t be able to customize the summary report, as the summary won’t include the detailed document numbers with amounts. Summary – by default – is the vendors with total due within the buckets.
What you can do is recreate the AP Aging with a saved search. SuiteAnswer 72814
Scenario
User wants to create a Saved Search to reflect the A/P Aging Summary Report.
Solution
- Navigate to Reports > Saved Searches > All Saved Searches > New
- Click Transaction
- Search Title: Enter Title
- Click Criteria tab
- Click Standard subtab
- Filter:Select Account TypeAccount Type: Select any of
- Select Accounts Payable
- Click Set
- Select StatusStatus: Select none of
- Select Bill:Paid in Full
- Click Set
- Select PostingPosting: Select Yes
- Click Set
- Click Results tab
- Click Columns subtab
- Field:
- Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.Select Formula (Currency)Summary Type: Select Sum
- Formula: Enter case when ({today})-{duedate} between 1 and 30 then {amountremaining} end
- Summary Label: Enter 1-30
- Select Formula (Currency)Summary Type: Select Sum
- Formula: Enter case when ({today})-{duedate} between 31 and 60 then {amountremaining} end
- Summary Label: Enter 31-60
- Select Formula (Currency)Summary Type: Select Sum
- Formula: Enter case when ({today})-{duedate} between 61 and 90 then {amountremaining} end
- Summary Label: Enter 61-90
- Select Formula (Currency)Summary Type: Select Sum
- Formula: Enter case when ({today})-{duedate} > 90 then {amountremaining} end
- Summary Label: Enter Over 91
- Select Formula (Currency)Summary Type: Select Sum
- Formula: Enter NVL (case when trunc({today})-{duedate} between 1 and 30 then {amountremaining} end, 0) + NVL (case when trunc({today})-{duedate} between 31 and 60 then {amountremaining} end, 0) + NVL (case when trunc({today})-{duedate} between 61 and 90 then {amountremaining} end, 0) + NVL (case when trunc({today})-{duedate} >90 then {amountremaining} end, 0)
- Summary Label: Enter Total Outstanding
- Click Save & Run