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