Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

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

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
    vinothmv9406 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
    Olister Rumao 3,957 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
    Soft Devil 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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans