Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Changing Report Layout on Drop Ship function

(0) ShareShare
ReportReport
Posted on by 85

Our Purchase orders have a standard Word Layout

When a Sales Order is created and Drop Shipment Option is selected, I would like a slightly different layout to pop up for Purchase Order Report. I would still like to retain the older report for the Purchase Order without a drop shipment.

I am not familiar with Event triggers. Would be grateful for any ideas. The drop shipment function in the Sales Order Line is a Checkbox

and in the Purchase Order Page ->Actions->Drop Shipment->Get Sales Order

  • Leo99 Profile Picture
    85 on at
    RE: Changing Report Layout on Drop Ship function

    This answer started me in the path to fix it. I had to use Event Recorder to record all the events and then filter it to the event that could have happened.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    999 Moderator on at
    RE: Changing Report Layout on Drop Ship function

    Then you need to start by creating a copy of the report you want to modify and put the copy in the 50000 object range.

    Modify the word layout for your new report.

    Then you can try to use the event i have highlighted if you are printing purchase document:

    pastedimage1662154475423v1.png

  • Leo99 Profile Picture
    85 on at
    RE: Changing Report Layout on Drop Ship function

    Thanks for the reply. I write the code myself

  • Suggested answer
    Inge M. Bruvik Profile Picture
    999 Moderator on at
    RE: Changing Report Layout on Drop Ship function

    If you want the layout to change automatically depending on the drop shipping or standard order then you need to do some development. If you think it is ok for the user to select the layout they need then you can wait until version 21. Then the user can select layout during print.

    Do you write AL code yourself or do you have a programmer available ?

  • Leo99 Profile Picture
    85 on at
    RE: Changing Report Layout on Drop Ship function

    Hi Mr.Inge,

       Thanks for the answer. I only need to change the report layout a teeny tiny bit when the sales order is marked for drop shipment or else I want to display the older report. I am sure this is event management from some trigger or action. Not sure how to go about it

  • Suggested answer
    Inge M. Bruvik Profile Picture
    999 Moderator on at
    RE: Changing Report Layout on Drop Ship function

    Do you want to only make modifications to the layout of the standard report or do you want to change it to a completely different report?

    Here are doc for modifying your word layout:

    docs.microsoft.com/.../devenv-howto-report-layout

    And here are doc for substituting a report in AL

    docs.microsoft.com/.../devenv-substituting-reports

    Also remember that you can configure reports in report selection sales and report selection purchase.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,207 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans