How to use multiple tables(having relations) in a single custom entity? I am having purch order header and line table(custom), my task is to import data from excel to Ax through DIXF. I tried to create custom entity, but its only accepting single table. My question is, Do i need to create separate custom entity for both header and lines, or Can we use multiple related table in a single entity? Thanks in Advance..
You can allso use views in the DMF wizard.
I don't see a view with just purchline and purchtable. So you'll need to create one.Personally I have not tried this, I am curious about your findings. Normally I just do two imports for something like this. One for the header and one for the lines.
There are already standard entities for the sales header and lines. You can load them separately. You can have a look at Composite entities to have them grouped.
Have a look at the next blog which explains this: ax2012dmfdataimport.blogspot.nl/.../microsoft-dynamics-ax-2012-dmf.html
André Arnaud de Calavon | Microsoft Dynamics AX Solution architect | My blog | My company
This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.
Let's take a note from Andre, Perhaps using the allready available tools at your desposal is easier ;)
The link you provided is very helpful. I will try as you said. Thanks