web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Customize Warehouse Pi...

Small and medium business | Business Central, N...

Suggested Answer

Customize Warehouse Pick RDLC to Add fields from sales order

(0) Share

Report

Report

Posted on by Anita75

1,165

Hi All

I have created a new data set for warehouse pick report and try to pull fields from sales order by linking sales header table as below:

dataitem(SalesOrder; "Sales Header")

{

DataItemLink = "No." = FIELD("Source No.");

DataItemTableView = WHERE("Document Type" = CONST(Order));

DataItemLinkReference = WhseActLine;

However new report doesn't show info from sales order. Not sure if the above link is correct?

Thanks

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Anita75 1,165 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually I did another test and i can get the fields to display on warehouse pick line level but not on header. This makes sense but since the business process does not include multiple sales orders on one pick i want to find a way to display customer address on header and i'd assume this is a common requirement. Maybe there is a way to do this

Was this reply helpful? Yes No
Suggested answer

THE Italian Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

With the info provided is hard to say. In the Sales Header dataset you could also create an array of values like e.g. CustAddr[x] where X is the number of elements that qualify for the address (e.g. name, street, country, county, and so on). Then in the dataset add the column CustAddr[1], then CustAddr[2], etc.

Was this reply helpful? Yes No
Anita75 1,165 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Duilio, I could try array as this could be a pattern i could use for this type of scenario.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 1,687 Super User 2026 Season 1

#2

YUN ZHU 1,041 Super User 2026 Season 1

#3

Grigorios Mavrogeorgis 974 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans