web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans