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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Extend fields to Picki...
Small and medium business | Business Central, N...
Suggested answer

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

(2) ShareShare
ReportReport
Posted on by Devon Jordaan 54

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)
  • Suggested answer
    Jainam M. Kothari Profile Picture
    Jainam M. Kothari 14,632 Super User 2025 Season 2 on at
    Extend fields to Picking List to use on Word Developer > XML Mapping Pane
    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.
  • Devon Jordaan Profile Picture
    Devon Jordaan 54 on at
    Extend fields to Picking List to use on Word Developer > XML Mapping Pane
    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!
  • Suggested answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 3,328 on at
    Extend fields to Picking List to use on Word Developer > XML Mapping Pane
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,236

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,402 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,078 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans