We are importing AP invoices into Dynamics through E-Connect, and while we are able to get it to create the transaction, it will not pull in all the distribution line items. Below is the xml data we are currently attempting to import.
<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
<PMTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateVendorRcd xsi:nil="true" />
<taCreateVendorAddress_Items xsi:nil="true" />
<taPMTransactionTaxInsert_Items xsi:nil="true" />
<taPMDistribution_Items>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>1002</VCHRNMBR>
<VENDORID>XXXXXXXXXX</VENDORID>
<DSTSQNUM>2</DSTSQNUM>
<DISTTYPE>2</DISTTYPE>
<DistRef>1</DistRef>
<ACTNUMST>0106-20000-0000-000-000000-000</ACTNUMST>
<CRDTAMNT>3281.47</CRDTAMNT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>1002</VCHRNMBR>
<VENDORID>XXXXXXXXX</VENDORID>
<DSTSQNUM>2</DSTSQNUM>
<DISTTYPE>6</DISTTYPE>
<DistRef>1</DistRef>
<ACTNUMST>0106-14200-0000-000-000000-000</ACTNUMST>
<DEBITAMT>359.0</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>1002</VCHRNMBR>
<VENDORID>XXXXXXXXXX</VENDORID>
<DSTSQNUM>2</DSTSQNUM>
<DISTTYPE>6</DISTTYPE>
<DistRef>1</DistRef>
<ACTNUMST>0106-14200-0000-000-000000-000</ACTNUMST>
<DEBITAMT>2654.0</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>1002</VCHRNMBR>
<VENDORID>XXXXXXXXX</VENDORID>
<DSTSQNUM>2</DSTSQNUM>
<DISTTYPE>6</DISTTYPE>
<DistRef>1</DistRef>
<ACTNUMST>0106-57215-0000-000-000000-000</ACTNUMST>
<DEBITAMT>15.0</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>1002</VCHRNMBR>
<VENDORID>XXXXXXXXX</VENDORID>
<DSTSQNUM>2</DSTSQNUM>
<DISTTYPE>6</DISTTYPE>
<DistRef>1</DistRef>
<ACTNUMST>0106-51080-0000-000-000000-000</ACTNUMST>
<DEBITAMT>55.0</DEBITAMT>
</taPMDistribution>
</taPMDistribution_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taPMTransactionInsert>
<BACHNUMB>201711310</BACHNUMB>
<VCHNUMWK>1002</VCHNUMWK>
<VENDORID>XXXXXXXXXX</VENDORID>
<DOCNUMBR>20171031RM02</DOCNUMBR>
<DOCTYPE>1</DOCTYPE>
<DOCAMNT>3281.47</DOCAMNT>
<DOCDATE>11/6/2017 12:00:00 AM</DOCDATE>
<PRCHAMNT>3281.47</PRCHAMNT>
<CHRGAMNT>3281.47</CHRGAMNT>
<TRXDSCRN>Multi Line PO - 2 Inventory Replenishment and 1 charge to a Work Order</TRXDSCRN>
<PORDNMBR>1019</PORDNMBR>
<MDFUSRID>InvoiceIntegration</MDFUSRID>
<CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>
<taMdaUpdate_Items xsi:nil="true" />
</PMTransactionType>
</eConnect>
*This post is locked for comments
I have the same question (0)
