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 :
Microsoft Dynamics NAV (Archived)
Answered

XML mapping

(0) ShareShare
ReportReport
Posted on by

Hi all, 

I am trying to customise a purchase invoice and I've used an invoice template from Microsoft word. However, I can't find the data (or schema) that I need for XML mapping under "Custom XML part". For example, I can't find the field for "Vendor Address" under the pane. Please advise

3884.Untitled_2D00_1.png

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    AJAnsari Profile Picture
    5,754 on at
    RE: XML mapping

    Hi Chad,

    The process is a little different in Business Central, than it is in NAV.

    Regarding the difference in NAV and Business Central: in NAV, when a field is missing, a developer or power user can easily go to the C/SIDE Development Environment, design the Report object, add the dataitem(s) required, recompile and save the report, and the next time you export the Custom Report Layout, you will see the fields in the urn:microsoft-dynamics-nav Custom XML Part.

    In Business Central, if a field you desire is not in the report object's dataitems, the above process is not possible, since you cannot modify a base object. Also, there is (to my knowledge, to date) no ReportExtension like there is a TableExtension or a PageExtension. As a consequence, the only realistic way is to create a new custom report object. Or if you have access to a Container based Sandbox, you can open the C/SIDE Development Environment, open the base report object and save it as a new report object in the custom object range, add the desired dataitem(s), save and compile, export as text (in new format), get the deltas, use the Txt2AL script to get the AL code, use Visual Studio to compile/package the AL code as a .app and upload the app to the Production Environment. And then use Report Layout Selection > Custom Layout > Export for this new report. This will let you see the new fields in the XML mapping.

    And depending on how the report is accessed, you will either need to set it as the default report a particular usage type from 'Report Selection - Sales' (or the relevant ''Report Selection - ####'), or you'll need to also create a PageExtension to add the report as an action to the ribbon of a particular page so a user can run it from there.

    This thread already looks to be closed, so if you have any follow up questions on this, please create a new thread / post in the Business Central forum (and if need be, reference this thread), and I or someone else in the community can answer with a Business Central context there.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Community Member Profile Picture
    on at
    RE: XML mapping

    Were you able to find the additional XML parts?

    We are running into the same issue... We need to add a field to a form, but that field is not part of the Custom XML Part.

    Example.

    We are editing a Sales Order, but the field is not in this list..

    It offers the option to Add New Part, but that results in an upload window,, (vs connection to map fields from Dynamics 365 Business Central for example.

    1800f2e533d479642c11a80941c7ad6d.png

    1800f2e533d479642c11a80941c7ad6d.png

  • Suggested answer
    Zaid Tariq Profile Picture
    2,274 on at
    RE: XML mapping

    This may be because your desired DataItem is not in the DataSet of the report. Please open the report in design mode and add the required dataitem in Report Designer. Thanks

  • Community Member Profile Picture
    on at
    RE: XML mapping

    Hi Alexander,

    I understand. But the problem is, I can't seem to find the control to add. For example, I want the item that I want to purchase to be shown under description but there is no control for me to map

  • Verified answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: XML mapping

    By default, the Developer tab is not shown in the ribbon. Please refer here for the full process: msdn.microsoft.com/.../dn757229(v=nav.90).aspx (How to: Add Fields to a Word Report Layout). Post questions here if any.

  • Community Member Profile Picture
    on at
    RE: XML mapping

    And also, how do I "drag" the value to the box so that when the address will be inside the box when it is printed out?

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans