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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Create New Page get da...
Small and medium business | Business Central, N...
Suggested Answer

Create New Page get data from Purchase Header and Purchase Line

(1) ShareShare
ReportReport
Posted on by Hoang Ng 307
I would like to create new Page which get data from Purchase Header and Purchase Line. With Purchase Header, some conditions are applied for it.
 
I can use a Query to populate data into a Page.
 
I wonder whether is there any easier way to join 2 tables Purchase Header and Purchase Line than using a Query ?
 
Thank you.
 
Categories:
Dynamics 365 Business Central
  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at
    You can also use the OnAfterGetRecord trigger on the Purchase Header dataitem on your page if you want to create a list that have some data from the purchase header and some accumulated data from the purchase lines.
    It would be easier to help you further if you presented the exact data that you want to display in your page.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 103,809 Super User 2026 Season 2 on at
    Hi, here is a simple example, I hope it can give you some help.
     
    Thanks
    ZHU

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 September Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 768 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 541 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 324 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans