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

Announcements

News and Announcements icon
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

I have the same question (0)
  • Soft Devil Profile Picture
    30 on at

    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.

  • Suggested answer
    Olister Rumao Profile Picture
    4,009 on at

    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

  • vinothmv9406 Profile Picture
    30 on at

    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.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 707 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 481 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans