Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Aging Analysis
Microsoft Dynamics SL (Archived)

Aging Analysis

(0) ShareShare
ReportReport
Posted on by Business Card 595

Hi everyone

I set up customer aged analysis in Microsoft Dynamics SL 6.5 and anytime i want to close my montly cycle i'll first aged customer detail despite that i will uncheck include future document and change my business date to last day of the month under review it will still include the future transaction in the aging  report because we always close our module late sometime 15th day of the following month and any transaction from the begining of the month will be posted to future period i.e the month that follow the month under review, can someone give useful advice and any contribution will be highly appreciated.

Thanks

*This post is locked for comments

  • Omidiran Abiodun Profile Picture
    Omidiran Abiodun on at
    Re: Re: Re: Re: Aging Analysis
    Yes, i mean the one i generated on 30th November, the balance i got when i run the aging after some day is not the same, anyway, i will try the step u provide in your reply. Thanks
  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Re: Re: Aging Analysis

    When you say "the one I have Earlier"... does this mean one that you ran on the 30th of November?   Or the one you ran just before you ran the Period Sensitive one?

    The period sensitive aging report looks at each invoice, and only shows the ones that were closed by payments (or cm's) that were posted to that period or before.  In other words, it ONLY shows the items that are part of the AR balance in the GL at the end of November.

    If you run the Aged AR on November 30, and then a week later you post an invoice back to period 11, that invoice will show as open on the period sensitive report, even though it was entered in December (but posted to November)

    Conversely, if you run the Aged AR now, NO MATTER WHAT DATE YOU USE, it will always show *all* open invoices that are open now, no matter what the date (even if it is for next year).  But if you run the Period Sensitive Aged AR, it will look at the period in the report screen and it will only show items that were open as of that period. (it would not show one posted to next year, for example)

     

  • Toni Savage Profile Picture
    Toni Savage 260 on at
    Re: Aging Analysis

    You might also consider closing your AR module a little earlier.  You can always post back to the previous period if you get entries for that period, but it sounds like most of your entries are to the current month.

    As Laura said, you can always use the "period sensitive" report to balance to any prior period's GL.

    Regards,

    Toni

  • Business Card Profile Picture
    Business Card 595 on at
    Re: Re: Aging Analysis

    when i generated the report using period sensitive aged report the balance am having is not the same with the one i have earlier, can you give me the procedure from aging customer balanc ethe the close of cycle to generating statement.

    Thanks

  • Laura Barber Profile Picture
    Laura Barber on at
    Re: Aging Analysis

    Hi,

    Use the Period Sensitive Aging reports instead of the "regular" aging reports.

    When you start a month, make sure all activity for that new month is correctly posted to the new month (vs the old month which is still open).  You can do this by advancing the Period to Post at the top of all your batches.

    Laura

     

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