Report Request Page Extension

(0) Share

Report

Posted on by Community Member

Hello Experts,

I have extended and created custom Sales Invoice Reports with different layouts. Since there is different custom reports for Sales Invoice it is not sufficient to make it one as default report selection. In our business scenario these different reports needs to be printed for a Sales Invoice when it is posted. So that I would like to have a drop down to select desired Report ID in the Report Request Page and for users this will make handy to select different Report ID & run from single window for same sales invoice .See the below screen shot for the expectation.

Thank you sharing your thoughts.

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Inge M. Bruvik 1,083 Moderator on at

Like (0)

Report

RE: Report Request Page Extension

My initial thought around this is that i would do something like this.

Add a field on the sales order where you can select the "report need" and then have a related table where the different reports needed for this type of sale set up.

Then i would write some code that automatically printed / email the report(s) defined in the "report need" for this type of sales.

End users usually have a hard time relating to report id but a category for what reports are needed is easier to relate to.

Just my thoughts around this.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Request Page Extension

Hi Inge M. Bruvik,

Thanks for sharing your thought. In our scenario we cannot determine the Report based on the order type, we need to print 3 reports for all Sales Invoices. So that it is easy for user if having a drop down in Report Request Page to select Report and print, instead of going to Report Layout screen.

Best Regards,

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,083 Moderator on at

Like (0)

Report

RE: Report Request Page Extension

Well,

You know your own business best. But i guess there has to be something with the sales order that the user looks at when they decide if they should run report A,BC or report D,E,F during or after post.

Your approach is doable but in my eyes it is not following the "BC way" of doing things. But that does not mean that it is necessarily wrong.

When i customize Business Central i try to make the solution as close as possible to other similar functions is the standard system.

And you already have the Sales Report selection where you can select different reports printed when you print an invoice. You can also define document setup pr. customer.

But then again - you know your business best.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Request Page Extension

Hi Inge M. Bruvik,

Totally agree with you. I could to select the three different desired report ID's in "Report Selection - Sales" screen and these report layouts are getting printed as per defined sequence for Posted Sales Invoices.

Thank you for your time and advice.

Best Regards,

Ranjith

Was this reply helpful? Yes No
Inge M. Bruvik 1,083 Moderator on at

Like (0)

Report

RE: Report Request Page Extension

You are more than welcome.

My pleasure to help.

Inge

Was this reply helpful? Yes No
Verified answer

YUN ZHU 94,649 Super User 2025 Season 2 on at

Like (0)

Report

RE: Report Request Page Extension

Hi, just adding some info.

For now, you can do following thing.

Select a report layout before printing

https://yzhums.com/25943/

And in next major version:

Choose the report layout on request page

https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/users-choose-report-layout-request-page

Hope this info helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Request Page Extension

Hello ZHU,

It's great and interesting. Thank you for sharing.

Best Regards,

Ranjith

Was this reply helpful? Yes No
Revathi.T 76 on at

Like (0)

Report

RE: Report Request Page Extension

Sir, could you tell me how to get CGST, SGST, IGST and total with GST values in sales invoice report through report extension in business central?

Was this reply helpful? Yes No