Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Sort Accounts Payable Aging

(0) ShareShare
ReportReport
Posted on by 30

I want to sort my accounts payable aging, but I cannot find a sort option.  Is it possible to do this such that I can put the A/P aging in order by vendor name?

Thank you.

  • Verified answer
    Jhill Profile Picture
    Jhill 30 on at
    RE: Sort Accounts Payable Aging

    Thank you very much for your help!

  • Suggested answer
    JAngle Profile Picture
    JAngle 46 on at
    RE: Sort Accounts Payable Aging

    You will need to do a custom report layout change which is very easy to complete if you stick to RDLC. Note you will need at least SQL Report builder 2016 installed to do this. 

    Go to the custom report layouts page and create one for the corresponding report ID. GB is 322 so I've done that one. Export the layout and open it to reveal the below detail. Place the cursor where you see mine, you want that big orange bar on the left to appear.

    pastedimage1594659590034v1.png

    right click to get the tablix properties open. And this:

    pastedimage1594659893011v2.png

    Save and then import the layout to BC. Run the report and the sorting should be changed:

    pastedimage1594659941675v3.png

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,602 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,340 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans