[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ link=” linktarget=” link_hover=” padding=’0px’ border=” border_color=” radius=’0px’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-g8zfzo’]
[av_heading heading=’Report Extensions in Business Central’ tag=’h1′ link_apply=” link=’manually,http://’ link_target=” style=’blockquote classic-quote’ size=” subheading_active=’subheading_below’ subheading_size=’15’ margin=” margin_sync=’true’ padding=’10’ color=” custom_font=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-kqs7ml2c’ id=” custom_class=” admin_preview_bg=”]
Written by Mike Scalamogna
[/av_heading]
[/av_one_full]
[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ link=” linktarget=” link_hover=” padding=’0px’ border=” border_color=” radius=’0px’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-acrhes’]
[av_image src=’https://nmq52a.p3cdn1.secureserver.net/wp-content/uploads/2021/07/REPORTING-EXTENSIONS-1.png’ attachment=’14562′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-kqtm0898′ id=” custom_class=” admin_preview_bg=”][/av_image]
[av_hr class=’invisible’ height=’25’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqjt1j8o’ id=” custom_class=” admin_preview_bg=”]
[av_image av_uid=’av-ieu6wv’][/av_image]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-jiadqikr’ id=” custom_class=” admin_preview_bg=”]
One of the many reasons I love Business Central is the fact that Microsoft monitors the Ideas website (Ideas (dynamics.com)) and often adds new features based on popular requests from end-users. One of those requests was the ability to extend existing reports within the system. This feature is available in Business Central 2021 release wave 1, which is currently being deployed in the US.
For example, extending a report could come in handy when you need to add a field to the Sales Order document in BC. Rather than build an entirely new extension with a new copy of the sales order, we can build a report extension that just simply adds the field to the dataset.
In the below example I am adding the “Drop Shipment” field onto the sales line area of the order:
[/av_textblock]
[av_hr class=’invisible’ height=’10’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqs7r2fk’ id=” custom_class=” admin_preview_bg=”]
[av_image src=’https://nmq52a.p3cdn1.secureserver.net/wp-content/uploads/2021/07/report-extensions-1.jpg’ attachment=’14533′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-kqs7nerc’ id=” custom_class=” admin_preview_bg=”][/av_image]
[av_hr class=’invisible’ height=’10’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqs7r2fk’ id=” custom_class=” admin_preview_bg=”]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-jiadqikr’ id=” custom_class=” admin_preview_bg=”]
Now, when I publish this extension the Drop Shipment field will be available for me to add to the report using the Custom Report Layouts page. Before exporting a report to modify be sure to click on the “Update Layout” button. This will update the dataset when you export the report layout and the new field will be available.
[/av_textblock]
[av_hr class=’invisible’ height=’10’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqs7r2fk’ id=” custom_class=” admin_preview_bg=”]
[av_image src=’https://nmq52a.p3cdn1.secureserver.net/wp-content/uploads/2021/07/report-extensions-2.jpg’ attachment=’14534′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-kqs7nerc’ id=” custom_class=” admin_preview_bg=”][/av_image]
[av_hr class=’invisible’ height=’10’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqs7r2fk’ id=” custom_class=” admin_preview_bg=”]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-jiadqikr’ id=” custom_class=” admin_preview_bg=”]
Here is a screenshot of the field available in the dataset for me to add to the report:
[/av_textblock]
[av_hr class=’invisible’ height=’10’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqs7r2fk’ id=” custom_class=” admin_preview_bg=”]
[av_image src=’https://nmq52a.p3cdn1.secureserver.net/wp-content/uploads/2021/07/report-extensions-3-.jpg’ attachment=’14535′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-kqs7nerc’ id=” custom_class=” admin_preview_bg=”][/av_image]
[/av_one_full][av_hr class=’invisible’ height=’25’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqcg3uor’ id=” custom_class=” admin_preview_bg=”]
[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-jiadqikr’ id=” custom_class=” admin_preview_bg=”]
Want to learn more about Business Central? Contact the Opal team today!
[/av_textblock]
[av_hr class=’invisible’ height=’25’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-kqcg3uor’ id=” custom_class=” admin_preview_bg=”]
[av_button label=’Contact Us’ link=’manually,https://opalbiz.com/business-central/#contactbc’ link_target=” size=’x-large’ position=’center’ label_display=” title_attr=” icon_select=’no’ icon=’ue800′ font=’entypo-fontello’ color=’theme-color’ custom_bg=’#444444′ custom_font=’#ffffff’ av_uid=’av-jiak8jn0′ id=” custom_class=” admin_preview_bg=”]
