Hello everyone,
I need to add 150 and 180 aging days to my AR Aging report. I have explored various ways but could not get to the bottom of this.
Kindly assist
Urgent
Any kind of response will be appreciated.
Thank you all
Best answer by Michael Ndungi
View original
+18
Hello
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', [ARRegisterReport.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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.