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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Added aging column bucket

(0) ShareShare
ReportReport
Posted on by 1,174

Hi expert,

Can I make additional column bucket more than 6 columns in AR and AP aging report?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Satya Kejriwal Profile Picture
    210 User Group Leader on at

    It will be a customization. Not sure, how major it will be since no client has asked for more than this so far.

  • agus Profile Picture
    1,174 on at

    thanks satya,

    my client really need more than this, because in aging period definition setup can make more than 6 columns.

    perhaps any other expert can help me to give an idea for this case.

  • Suggested answer
    Satya Kejriwal Profile Picture
    210 User Group Leader on at

    Another way out without customization is to configure two set of aging buckets and generate it separately. Then using excel, you can merge the two reports. That's what I would suggest to the client instead of going for this customization.

    Secondly, since AX really hard coded it up to 6 and increasing it beyond 6 will mean doing it from the scratch or doing some major redesign. Aging snapshot/Customer statement/Aging reports-all these are dependent on this set up. Increasing the number of lines in the set up through customization will need customization in all these 3 processes. If you really need it only for aging report, then you can remove the validation on the set of aging bucket (that should be easy thing) + customize the aging report (it will need redesign)

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Agus,

    I fully support what Satya replied. Making an adjustment to the 6 default aging buckets quickly can end up in very very much work due to the hard coded specification. Please try to use the Workaround suggested.

    All the best,

    Ludwig

  • Verified answer
    agus Profile Picture
    1,174 on at

    ok guys, I'll will consider what you advice. thanks for your help.

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans