web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Purchase order list and Vendor List

(3) ShareShare
ReportReport
Posted on by 507

Hi All,

I wanted to add a column into purchase order list on each purchase order users are adding notes in the attachment section and they wanted to see this along with othe column in the purchase order list how to add the same.  On Vendor list we wanted to add VAT number and email address of vendor how to add them, I have tried in personalize but I couldnt find the same.

 

Thanks,

babu

  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    3,383 Super User 2026 Season 2 on at

    Hi Babu, two different things here. On the vendor list both fields do exist on the Vendor table, so personalise works, the names are what catches people. In the Add Field pane search for VAT Registration No. and for E-Mail with the dash, not VAT Number or Email, they are sitting there.

    The purchase order one you can't do with personalisation. Those notes live in their own table, attachments and notes are not fields on Purchase Header, and Add Field only offers what belongs to the page source table, so there is nothing to drag onto the list.

    To have it as a column you need a small extension, a field or a flowfield on Purchase Header and then on the page. Without code, the attachment factbox on the right shows it for the selected order, not what they asked for but no development.

    Glad to help - follow up if anything is unclear.   

    â–º  If this solved it, marking it verified helps others too.       

    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

  • Suggested answer
    OussamaSabbouh Profile Picture
    19,544 Super User 2026 Season 2 on at

    Hello Babu,

    For the Purchase Order List, the notes entered under the Attachments FactBox are related records, not fields on the Purchase Header, so they cannot be added as a column through Personalization; you would need a small AL page extension to read the related note and display it (for example, latest note or combined notes). For the Vendor List, try Personalize → + Field and search for VAT Registration No. and E-Mail; current Business Central versions allow additional table fields to be exposed through personalization, but if they aren't available in your version/page, a simple page extension is required to add them.

    Regards,
    Oussama Sabbouh

  • BBBCMAN Profile Picture
    507 on at

    Hi Both,

    I tried to add VAT and e-mail but I cannot see them under vendor list.  Can you share me any screenshot where you see them.

    Thanks,

    babu

  • BBBCMAN Profile Picture
    507 on at

    Bump anybody there who can help me with this.

     

    Thanks,

    babu

  • Suggested answer
    Teagen Boll Profile Picture
    3,908 Super User 2026 Season 2 on at

    Hi Babu, you sometimes need to change the Profile (Role) itself. Check to see the role you have assigned from your settings:

    Note down the role you have assigned:

    Search for Profiles (Roles) and find that role and then select Customize Pages:

     

    In the role customization window that opens you can add any fields as columns that are in the vendor table:

    For notes or attachments those are separate tables and have to be added via a customization.

     

    Best,

     

    Teagen Boll, CPA
  • Suggested answer
    Mansi Soni Profile Picture
    10,422 Super User 2026 Season 2 on at

    Hello @BBBCMAN ,

    For the Purchase Order list, the standard Notes from the Attachments/FactBox area cannot be added directly as a normal column because Notes are a separate system part, not a field on the Purchase Header table. If users need to see note information in the list, you would need a custom field/page extension (for example, showing the latest note or a Notes indicator). For the Vendor List, VAT Registration No. and Email may be available as underlying Vendor fields, but if they don't appear in + Field during personalization, an administrator can add them through page customization; Microsoft confirms that administrators can expose table fields that aren't currently defined on the page.

    I hope this answer helps. If you find it helpful, please consider marking it as the verified answer.

    Regards,
    Mansi Soni

  • Suggested answer
    YUN ZHU Profile Picture
    103,223 Super User 2026 Season 2 on at

    Hi, hope the following helps.

    Business Central 2023 wave 2 (BC23): Add existing table fields to optimize your pages (Adding Table Fields to Page without Page Extensions)

    https://yzhums.com/43183/

    Business Central 2025 wave 1 (BC26.2): Add fields/columns from related tables in analysis mode (No customization)

    https://yzhums.com/62564/

    Thanks

    ZHU

  • Suggested answer
    CU03020606-0 Profile Picture
    88 on at

    For the Notes requirement, this is a little different from adding a normal field through personalization.

    The Purchase Order List is based on the Purchase Header, so you can read the notes attached to each PO using its RecordId. For example:

    RecordLink.SetRange("Record ID", Rec.RecordId);
    RecordLink.SetRange(Type, RecordLink.Type::Note);
    RecordLink.SetAutoCalcFields(Note);
    
    if RecordLink.FindFirst() then
        NoteText := RecordLinkMgt.ReadNote(RecordLink);

    This will work if you only want to display one note. The thing to keep in mind is that a PO can have multiple notes. If you concatenate all of them into one column, the Purchase Order List can quickly become difficult to read.

    For that reason, I would probably recommend showing Has Notes (Yes/No), Notes Count, or perhaps a short preview of the latest note instead.

    The standard Notes themselves are stored in the Record Link table, and Microsoft provides Record Line Management.ReadNotes() for reading them.

    If this helps, please mark the answer as Accepted Answer.

    Sanket

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 757 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 451 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 391 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans