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

Aged Accounts Payable

(0) Share

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:

Business Central

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 73,378 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.