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

Add additional fields in Purchase Order report

(0) ShareShare
ReportReport
Posted on by

I need to add phone number from Table "Ship-to Address" in purchase order report and apply conditional formatting on it, i have some idea that we cannot apply conditional formatting in Word layout but we can in RDLC layout. I alos know that we can not add fields to the data set of built in layouts.
So, i created a new RDLC report in AL language and included "Purcahse Header" table as dataset and inside it i also included fields from table "Purchase Line" following this document. But when i run the report in business central data of the fields from "Purchase Line" is showing on report but data of fields from "Purchase Header" is not showing.
I need suggestions to achieve my goal.

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    150 on at

    Would suggest reviewing the standard PO RDLC layout to aid you but this blog explains what is going on here: navfreak.com/.../

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,045 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans