Hello @Michael Ndungi ,

I found two posts related to adding more Aging Periods to the AP Aging.  The steps to add more Aging Periods to the AR Aging will be very similar. These two posts by LTussing03 as they worked through the similar change in AP:

This one answered by Reza:

I hope this helps you!

Laura

I thought of a way to achieve this, from the statement cycle there is a backet for 90days and over.
Meaning, from there one can get the balance for 120, 180 and above this too if one was to add a condition to restrict the periods.

 

example;
= IIF(
    $BucketNumber = 4 
    AND DateDiff('m', fARRegisterReport.DocDate], @AgeDate) = 5,
    $DocBal, 
    0
)
if bucket is 4(over 90 days) and the date restriction matches 5, give out the balances in there.

Thank you for sharing your solution with the community @Michael Ndungi!