Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Customized A/R AGING R...
Microsoft Dynamics NAV (Archived)

Customized A/R AGING Report over 720 days

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I need to make a customized A/R aging report over 720 days in 30 day buckets.  I have 3 other aging reports that are all under 365 days.  I have coded the 720 day aging the same as the other 3.  The 3 under 365 day reports, all buckets match, the reports are good.  With the 720 report the buckets are off by maybe 2 or 3 buckets, and the problem can be verified by a number or 2 going to one buckets or the other as if the Microsoft is not paying attention to the 365 day rule.  And it is usually the 30-60 and 60-90 day buckets that are off.  Because this is happening in the early buckets that are visible on all reports,  the 720 report is wrong.  I have even gone as far as taking out the CALCDATE command and treating the buckets and dates as numbers, thinking if the calcdate was not used this problem would not exist, however that is not true either.  Has anyone ever ran into this before?  How do you handle this problem?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customized A/R AGING Report over 720 days


    IF FORMAT(PeriodCalculation) <> '' THEN
    EVALUATE(PeriodCalculation,'-' + FORMAT(PeriodCalculation));
    IF FORMAT(ShowOnlyOverDueBy) <> '' THEN
    EVALUATE(ShowOnlyOverDueBy,'-' + FORMAT(ShowOnlyOverDueBy));
    IF AgingMethod = AgingMethod::"Due Date" THEN BEGIN
    PeriodEndingDate[2] := PeriodEndingDate[1];
    FOR j := 3 TO 9 DO
    PeriodEndingDate[j] := CALCDATE(PeriodCalculation,PeriodEndingDate[j - 1]);
    END ELSE
    FOR j := 2 TO 9 DO
    PeriodEndingDate[j] := CALCDATE(PeriodCalculation,PeriodEndingDate[j - 1]);

    If you have a version that works may I see how you did it because I have worked on this for months and can not get it to work.  But again you are saying 365  I was saying over 1 year at 720 days.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Customized A/R AGING Report over 720 days

    Hi,

    I have used upto 365 days and have been giving correct result.  I think it must not be a problem.  Have you checked whether the age bucket formula is correct?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans