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

Extend fields to Picking List to use on Word Developer > XML Mapping Pane

(5) Share

Report

Posted on by CU01021823-0

Hi.

I am struggling so hard with extending my Picking List to include "location to: fields on it...
So basically I want to include the delivery location on the picking lists but when I open it on Word it does not exist within the Dataset... I could get it right with other modules like the invoice but I can't do it on the picking list...
Please help me with a basic (Or not basic) piece of code.

Also I would appreciate it if anyone could give me advice on where I can learn more about AL development?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

To include the delivery location on the Picking List in Business Central, you need to create a Report Extension for the standard Picking List report (e.g., Report 5752) and add the required field (such as Location Code from Sales Header or Sales Line) to its dataset using AL code.

After publishing the extension, refresh the Word layout dataset so the new field appears in the XML Mapping pane, then insert it into the layout.

For learning AL development, the best resources are Microsoft Docs, YouTube channels like AJ Kauffmann, community forums, and books like Mastering Microsoft Dynamics 365 Business Central Development by Stefano Demiliani.

1 people found this reply helpful.

Was this reply helpful? Yes No
CU01021823-0 70 on at

Like (1)

Report
Copy link

Link copied!

Do you have an example for me with Picking List?

I have spent almost 2 days and can't even publish a basic field to this report layout... So I have no idea where to start anymore, I have added multiple fields to "Sales Order" reports, Statement reports ect... But for some reason I can't even do a basic field into Picking List.

I would appreciate it, thank you!

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,808 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The “delivery location” fields don’t appear on your picking list because they’re not in the report dataset.

You must add them with a report extension, then insert them into your Word layout.

Mini-example:

reportextension 50100 PickingListExt extends "My Picking List"

{

dataset

{

add("Sales Header")

{

column(ShipToName; "Ship-to Name") {}

column(ShipToAddress; "Ship-to Address") {}

column(LocationCode; "Location Code") {}

}

}

}

Publish → edit Word layout → insert these new fields from the XML Mapping pane.

Where to learn AL:

Microsoft Learn (Business Central Developer docs).

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

Report extensibility (ReportExtension Object)

https://yzhums.com/10723/

Why are custom columns/fields added via Report Extension not found in standard layouts exported from Report Layouts page?

https://yzhums.com/58299/

Thanks.

ZHU

Was this reply helpful? Yes No