How to Substitute Report in Business Central

Today we will see how we can substitute our own document report with Standard report in business central.

To override report we need to use ReportManaagement Codeunit and from that we need to use OnAfterSubstituteReport event

Suppose we have created own customize report called ‘Detail Inventory Transaction’ and now we have to replace standard report for Inventory Transaction Detail

[EventSubscriber(ObjectType::Codeunit, 44, 'OnAfterSubstituteReport', '', true, true)]
    procedure SubstituteInventoryTransactionReport(ReportId: Integer; var NewReportId: Integer)
    begin
        If ReportId = Report::"Inventory - Transaction Detail" then
            NewReportId := Report::"Detail Inventory Transaction";
    end;

Publish your extension and check the report .You will find new report is substituted with standard report.

Hope this will help you.

Stay tuned for more..

6 responses to “How to Substitute Report in Business Central”

How to Substitute Report in Business Central – Dynamics 365 Business Central Community

February 12, 2020

[…] ReportManaagement Codeunit and from that we need to use OnAfterSubstituteReport event Suppose we… Read the full text. Read Complete Post and Comments $(window).load(function(){ $('.post .full-post […]

tahaimtiazkhan

February 12, 2020

how do we get complete vendor purchase order report i.e posted ,released ,open ,etc under a single head in business central d 365 thanks .

tahaimtiazkhan

February 12, 2020

how do we get complete vendor purchase order report i.e posted,released open invoiced etc under a single head in business central d 365 thanks.

Ammolh Saallvi

February 12, 2020

You need to customize this report

Loading…

Reply

How to Substitute Report in Business Central – 365 Community

February 12, 2020

[…] How to Substitute Report in Business Central […]

Upcoming New Features with Business Central – Ammolh Saallvi Blog

January 31, 2021

[…] if we need to change in any base app report then we need to copy that report ,make changes and use report substitution to display the customize report. Looking forward for new report extension object where in one can […]

BCAIHUB — Business Central & AI Consulting