Blog
Blog

Dynamics 365 Business Central / Navision: How to Show Notes on Page & Report?

Posted on 08-Sep-2023 by Anil Verma

Hi, Readers.

Today I will demonstrate how to display notes on pages and reports in Dynamics 365 Business Central.

Let's begin with an example: First, we start with the process of displaying the note on a page.

  1. This is the Customer List page, where we add notes.
    Dynamics 365 Business Central Customer list page shows the fields for attachments, links and notes.
     

  2. Add Note: This is my note!
    Adding note in the note box field "This is my note"
     

  3. Create a procedure GetNote.
    AL code example in Dynamics 365 Business Central showing how to create procedure to display notes on a page

    Business Central AL code snippet for retrieving and filtering record notes from Notes table
     

  4. Call the GetNote procedure in the place where you want to display the notes.
    AL page extension code used to show customer notes on Customer List page in Business Central
     

  5. In the My_Notes column of the Customer List page we can see This is my note!
    Customer List page in Dynamics 365 Business Central displaying notes column added using page extension
     

Now, we start the process of displaying the note in the report.

  1. Create a Customer Data report and invoke the procedure GetNote in the column.
    AL report extension code for displaying notes in report layout in Business Central
     
  2. Add DataSets to the layout. And don't forget to add a Note column to display the note.
    Report design view in Business Central showing Notes field added to report layout
     
  3. We can see This is my note! on report.
    Final report output in Dynamics 365 Business Central displaying customer notes correctly

Post a Comment

Your email address will not be published. Required fields are marked (*)

Captcha
can't read? refresh

WhatsApp Now