Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Customer Aging Balance...
Microsoft Dynamics SL (Archived)

Customer Aging Balances not progressing to past due

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

Hi,

I have a bunch of Customers with invoices (generated via the Invoice Entry Screen) whose balances due are only showing under Current Balance in the Customer Activity Screen. Their balances are not showing in the 1-15 days, 16-45 days, etc. Past Due textboxes under the Aging Balances section. For example, an unpaid invoice with a Doc Date of 11/15/2016 is still only showing under Current Balance.

The Aging balances are stored in the AR_Balances table.

What process progresses the Customer's Aging Balance from Current to 1-15 Days past Due Date, 16-45 Days, etc.?

Any ideas on how to resolve this?

Any help is appreciated.

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer Aging Balances not progressing to past due

    Closing is a process you run to move a module, like AR, from one accounting period to the next.  Close statement cycle is a process you run when you are using balance forward style statements.  The close statement cycle process rounds up documents that were on a previous statement cycle that still have a balance and uses that figure for the balance forward amount on the statement.  New documents that have not been on a previous statement (e.g., part of a previous statement cycle close) show as new charges on the statement and are marked as being a member of that statement cycle close.

    If you only use open item statements then you would not normally close a statement cycle but you would then need to run the Age Customer Detail process to advance your aging whereas, if you use the close statement cycle process then you can have it also age the balances.

    I hope the above explanation helps clear up what I had first said.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer Aging Balances not progressing to past due

    Thanks Rick! I will mark your reply as the correct answer.

    If I may ask, I don't recalling running a Close Statement Cycle. Usually we only run the "Closing". What does it mean/do to Close Statement Cycle?

    Thanks

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer Aging Balances not progressing to past due

    Balances are aged either during the close statement cycle process or by running the age customer detail process.  In order for the balances to be aged during the close statement cycle process you must have that option checked.  Please keep in mind that the balances are aged based on the document's due date and not the document date itself.

    While this is probably obvious, make sure the statement cycle for the customers in question has been recently closed.  The close statement cycle screen will show you the last time the aging was done and the last time the statement cycle was closed.

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