News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Aged Accounts Payable

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

Suggested answer

Aged Accounts Payable

(0) Share

Report

Report

Posted on by Community member

Hello, How i print my Aged Accounts Payable based on customer name in Ascending order, right now it is print based on Customer Number. where could i change ?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Aged Accounts Payable

Hi, This is more complicated than imagined. Because the DataItemTableView Property cannot be customized using the Report Extension, you must copy the standard report then create a new one.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-dataitemtableview-property

It is recommended to use what Inge mentioned, after exporting to Excel, sort outside the system.

Hope this helps.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

Aged Accounts Payable

You need to customize your report in order to achieve that.

You can not select the sorting on the standard report from the user interface.

One workaround can be to print the report to Excel and do the sorting in Excel after the report is finished.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans