Plaza 365
Plaza 365

No results found for your search

RegisterLog in

5

Dynamics 365 Business Central: Can we change the default sorting/line ordering of standard reports

Visit article

#change

#default

#reports

Dynamics 365 Business Central

Category

Oct 29, 2024

Published date

Text

Article Type

AI Summary

  • The article discusses changing the default line sorting/ordering of standard reports in Dynamics 365 Business Central.
  • The DataItemTableView property of the report determines the sorting order for lines in reports like "Standard Sales
  • Order Conf."
  • The DataItemTableView property cannot be customized, so alternative methods like using the OnAfterPreDataItem trigger in a report extension are suggested.
  • Two examples provided in the article demonstrate how to customize sorting by "No." in descending order or by quantity in ascending order.
  • The default sorting method for reports like "Inventory
  • List" is by the primary key, such as Item No.
  • To modify sorting in reports without predefined methods, developers may need to explore the standard code or recreate the report.
  • A codeunit example is given for subscribing to events like OnAfterLineOnPreDataItem to customize sorting for reports like "Standard Sales
  • Pro Forma Inv."
  • Additional resources and test suggestions are provided for further customization in Dynamics 365 Business Central reports.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.