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
Answer
Adding new aging periods(150days, 180days) on AR Aging Report
Best answer by Michael Ndungi
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.
Michael
+19Hello
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
~ Laura Barber, WM Synergy
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.
Michael
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.