Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Aged Balances Overdue ...
Finance forum
Answered

Aged Balances Overdue Amount column including Current aging period

Posted on by 138

Hi, in our Aged Balances form, the Overdue Amount column is including the Current amount along with the actual overdue periods.  We update the Aging Snapshot daily, I can confirm the totals in all periods are correct, so our aging period definitions are calculating the open transaction amounts correctly.  Any ideas what's wrong here?

pastedimage1626632372999v3.png

pastedimage1626632298602v2.png

  • CU09070411-0 Profile Picture
    CU09070411-0 2 on at
    Aged Balances Overdue Amount column including Current aging period
    Hi David, 

    how did you solved this issue, have you got an answer from MS
  • David Penna Profile Picture
    David Penna 138 on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Agreed Ludwig Reinhard, unfortunately since I am not on IT staff, I cannot contact MS support directly; if I can figure out how to submit an issue on Lifecycle Services, I will log it there.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Hi D Papa,

    I would try to open a support call with the MS support team. If you are 'lucky' then they accept this as a bug and might provide a fix. It's worth trying in my opinion. Nothing to lose.

    Best regards,

    Ludwig

  • David Penna Profile Picture
    David Penna 138 on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Hi Ludwig Reinhard,

    Not sure what you mean by "personalization" - we are able to insert columns with Grid Options by right-clicking a column heading or using the ellipse at last column heading.

    Anyway, thanks for posting that.  Your screenshot shows Overdue Amount behavior consistent with ours, which I would consider to be a bug or design flaw, do you agree?  An open transaction billed on 30 days terms of payment is Current from days 1-30 and becomes Overdue on day 31.  So, transactions that are Current shouldn't be calculated in the Overdue Amount.

    I searched this issue on Lifecycle Services and didn't find it mentioned specifically, but I also confirmed from the Service Update Availability schedule that we are not at the latest version.  Would you suggest that I post this issue there anyway?

    Thanks,
    D Papa

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Good morning D Papa,

    I added this column through a personalization. 

    aging3.png

    Hope this helps. 

    Best regards, 

    Ludwig

  • David Penna Profile Picture
    David Penna 138 on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Hi Ludwig Reinhard thanks for the screenshots, would you be able to add the Overdue Amount column to one of your systems, just to see if your result is consistent with ours?  The one with blue highlighting would be a good example because there are amounts in a variety of columns.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Hello D Papa, 

    Below are two screenprints from two different systems 

    Hope this helps. 

    Best regards,

    Ludwig

    aging1.png

    aging2.png

  • David Penna Profile Picture
    David Penna 138 on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Hi Ludwig Reinhard,

    No personalization that I know of, just inserted columns.  I tried Personalize > Clear but the layout didn't change.

    I'm wondering if D365's "overdue" criteria is different than what we would consider (any transactions  with a due date on or later than the aging snapshot date).

    Just out of curiosity can you post a screenshot of your form?  I'd like to see how it is different.

    Thanks,

    D Papa

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Aged Balances Overdue Amount column including Current aging period

    Hi D Papa,

    My aging online form looks different.

    Has somebody added the last column through a personalization?

    Have you tried resetting the forms layout to the standard one by opening the personalization pane and then selecting 'clear'?

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans