web
You’re offline. This is a read only version of the page.
close
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

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
    3,967 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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans