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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Business Central - Modify dataset of built-in reports

(0) ShareShare
ReportReport
Posted on by 60

Hello experts,

I need to make few changes to some of the built-in reports like Sales Order, Sales - Shipment, Sales - Invoice, Purchase Order, etc. The changes are simple ones like adding new columns to the report dataset, modifying the date format of date fields, etc. Some of the new fields I am trying to add are custom fields that are added using Table Extensions.

I have done extensive search but the only suggestion I could find is to create a new custom Report using AL code in extensions which feels too complex when what we actually want is just to add couple of new fields and be able to use them in Word layout documents.

Is there any other alternative to this cumbersome approach.

Being new to Business central I would ask your advice on how you would handle such requirements. Many thanks...

Regards,

Amar

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Hi Amar,

    You have no choice but creating a new report because Reports in D365BC are not extensible like page and table objects. As you cannot extend report, try to create a new one and add/modify what you like.

    If you have Dynamics NAV 2018, you can use the Txt2Al conversion tool to convert the native reports you need from C/AL to AL code. Then you can add your logic (fields and date format,...).

    Note that you might need make some changes to the converted code (AL code).

    Regards,

  • Amar Deep Profile Picture
    60 on at

    Thanks, just what I was thinking I will end up doing. I wanted confirmation before I started the long journey.

    I have heard of Txt2AL conversion tool, but dont have access to it, nor have used any previous version of NAV.

  • Dave Boehm Profile Picture
    645 on at

    The ability to modify the underlying dataset for a BC report, shows up as a new feature (see the Roadmap's "October Release Notes").  This doesn't help you today, but at least you have something to look forward to.

  • Amar Deep Profile Picture
    60 on at

    Thank you Dave for sharing the information.

    Note: Linking your older post about similar issue.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans