Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Missing column in XML mapping field list while creating Custom Report layout in word

(0) ShareShare
ReportReport
Posted on by

Hi

I am working on sales invoice (1306) report in word template. I need to add Customer Email id on the report but it is not available in XML mapping field list. How can I achieve this?

Regards

  • vinothmv9406 Profile Picture
    30 on at
    RE: Missing column in XML mapping field list while creating Custom Report layout in word

    Hi Soft Devil.,

    I have followed your procedure upto point 1 to 7.

    Not getting from point 8 to 10.

    Could you please explain me bit more clear.

    Thanks.

  • Suggested answer
    Olister Rumao Profile Picture
    3,959 on at
    RE: Missing column in XML mapping field list while creating Custom Report layout in word

    The easiest way of doing this is by installing Business Central On Premise version 14.

    Then make a copy of this report at C/Side with different Object ID, and make changes in C/Side.

    Then Export this object to text and then use Txt2Al to convert this to AL and install as an extension.

    Another possible way is install BC-On Premise Version 15, copy the Report  from the Base App with a different Object ID and name, and make changes in AL and deploy as an extension

  • Soft Devil Profile Picture
    30 on at
    RE: Missing column in XML mapping field list while creating Custom Report layout in word

    You can not make changes in standart reports.

    You need to copy the report and add it to a extension, by using the AL object Designer in Visual Studio Code.

    For version 15 or newer

    1. Make new or use existing BC extension

    2. Install AL object Designer by Márton Sági

    3. Download symbols from a sandbox

    4. Open AL object Designer by pressing F1 and type in AL object Designer in the search box.

    5. Find the report to copy and click on the report name. AL object Designer will open a new tab with code for the report.

    6. Copy the code to new .al file and change id and name. and add the field.

    7. Upload the extension to the sandbox.

    8. download the original layout and upload it to the new report and press update layout.

    9. download the new report and add the field to the layout.

    10. change to the new report in report selection.  

    if other languages then English is used.

    Use NAB tools to translate lables and captions.  

    For version 14 or Older

    user a docker container and export the report object as .txt , and then use the Txt2Al Conversion Tool.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans