Skip to main content

Notifications

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

Report Request Page Extension

Posted on by Microsoft Employee

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.

Report-Request-Page.JPG

Thank you sharing your thoughts.

  • Revathi.T Profile Picture
    Revathi.T 76 on at
    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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report Request Page Extension

    Hello ZHU,

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

    Best Regards,

    Ranjith

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    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

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Report Request Page Extension

    You are more than welcome.

    My pleasure to help.

    Inge

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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,

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans