Announcements
No record found.
Hi,
I am creating a PO using an import xml file. Everything is OK in the standard, but I have a problem with the custom file. How can I customize the xml file I get from an external company to match the import into D365 for (sales orders composite V3) "SalesOrderV3Entity data entity?
I have been trying to create an xslt file so that I can convert the file I receive to one that will fit into d365.
Could someone please give me some suggestions on what steps I should take?
Thanks in advance.
Add an entity and close the dialog. The double-click View map field, which opens Map source to staging form. Switch to Tranformations tab - that's where you can add transformations.
Another option is transforming the file even before using it in F&O.
Hi Martin,
Thank you for your answer.
OK, but is this dialog the "raw" xml file from the customer should be uploaded?
When I do that, I getting this result, with no available mapping and no place to load the XSLT file..
btw, is it a good practice for the end-user to import PO into D365 in this way?
There is no way for an end-user to receive a differently structured XML file from their customer.
There is a place to upload the XSLT. You missed the step of double-click the View map field (the red cross), which will open the form where transformations can be set up.
I think it'll be easier if your upload an already transformed file. If you tested your transformation, you should already have such a file available.
It is not clear to me how this mechanism works.Should I load an XSLT file as the first file, which itself is a "recipe" is to translate the XML file from the client to an XML file that is accepted in the D365 import?
In my opinion, the first dialog should load the "raw" file from the client and then in the form with transformations, select the XSLT file and apply it?
Could you give me an existing example where I could follow this process step by step?
I tried to load the XSLT file..
The transformation (XSLT) should be added at the Transformation tab (your last screenshot).
You can find examples on internet, e.g. XSLT transformation in Dynamics 365 for operation.
OK, thanks. I've already analyzed this example.
So the first file I load into the system is the "raw" XML from the external customer?
Do I need to transform it somehow before uploading it to the system (first screenshot in my previous post)?
As I mentioned, I'm getting an XML file that completely does not match the PO import into D365.
Steps I understand:1. System administration ->Data management -> Import2. Add file3. Source data format -> XML-Element4. Entity name -> Sales orders composite V35. Upload data file -> I choose the "raw" XML file from the customer6. View map -> view map7. Transformations -> New -> Upload file 8. Apply transforms
No, use the transformed file. Use your XSLT to transform it. As I said, if you tested your XSLT, you should already have a tranformed file available.
OK, I get it.
I can do that because I have access to Visual Studio.
But in general, this task will fall to the end user at the client, who will not have the knowledge or access to Visual Studio etc.
Is there any way to transform the XML file just using D365?
Users can easily get a file in the right format by exporting some data through the entity.
Regarding your other question, yes, you can use other programming language to write transformation logic, such as X++ or C#. But than it's completely out og hands of end users. If you want something that (power) users can do by themselves, consider Power Automate.
By the way, Visual Studio is just one of many tools that can be used to develop and test XSLT.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 659
André Arnaud de Cal... 465 Super User 2026 Season 1
Syed Haris Shah 304 Super User 2026 Season 1
