Dynamics Community Forum Thread Details

Create Data Exchange Definition

I'm trying to create a new Data Exchange Definition in NAV 2017 (CU 11) to import an XML file from which I want to create a Sales Order via Incoming Documents. Needless to say I have been unable to get it working. I tried to follow the MSDN documentation and below is how far I got. Somewhat related, I did manage to successfully create a bank import for a file from our bank with variable length format, but XML is problematic.

Is the Codeunits/XMLport I selected correct?

4428.Capture1.PNG

I'm not sure I fully understand how to interpret the screens below.

2870.Capture2.PNG

5584.Capture3.PNG

0218.Capture4.PNG

Here is my XML file that I would like to import.

<?xml version="1.0" encoding="UTF-8" ?>
<SalesInvoice>
	<SalesHeader>
		<CustomerNo>C0002</CustomerNo>
		<ExtDocNo>PO009581</ExtDocNo>
		<DueDate>30-11-2017</DueDate>
	</SalesHeader>
	<SalesLines>
		<Line>
			<Type>Item</Type>
			<Item>YMAZ</Item>
			<Quantity>50.62</Quantity>
			<Price>700</Price>
		</Line>
		<Line>
			<Type>Item</Type>
			<Item>YMAZ</Item>
			<Quantity>30.55</Quantity>
			<Price>700</Price>
		</Line>
		<Line>
			<Type>Item</Type>
			<Item>YMAZ</Item>
			<Quantity>80.144</Quantity>
			<Price>700</Price>
		</Line>
	</SalesLines>
</SalesInvoice>

Quick Links