Dynamics Community Forum Thread Details

Hello all,

While integrating expense reports in Dynamics GP Analytical Accounting, getting below error

Message:GPPayablesInvoiceUpload.cs Microsoft.Dynamics.GP.eConnect.eConnectException: An item with the same key has already been added.
at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateTransactionEntity(String connectionString, String xml)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessEntityImport(String connectionString, String sXML, Boolean isTransaction)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateTransactionEntity(String connectionString, String sXML)

Is there something I am missing?

Below is the sample XML I am using.

<?xml version="1.0" encoding="utf-8"?>
<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>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DSTSQNUM>24155</DSTSQNUM>
<DISTTYPE>6</DISTTYPE>
<DistRef>1 AIR EAGLE | 02/08/23</DistRef>
<ACTNUMST>999-9999-01</ACTNUMST>
<DEBITAMT>136.37</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DSTSQNUM>24150</DSTSQNUM>
<DISTTYPE>6</DISTTYPE>
<DistRef>Internal Project</DistRef>
<ACTNUMST>999-9999-01</ACTNUMST>
<DEBITAMT>181.82</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DSTSQNUM>24141</DSTSQNUM>
<DISTTYPE>6</DISTTYPE>
<DistRef>SHOP Project</DistRef>
<ACTNUMST>999-9999-01</ACTNUMST>
<DEBITAMT>181.82</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>000-1104-00</ACTNUMST>
<DEBITAMT>5.00</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>000-1105-00</ACTNUMST>
<DEBITAMT>10.01</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>000-1106-00</ACTNUMST>
<DEBITAMT>14.99</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DISTTYPE>6</DISTTYPE>
<ACTNUMST>000-1107-00</ACTNUMST>
<DEBITAMT>19.99</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>GE5582-0</VCHRNMBR>
<VENDORID>ACETRAVE0001</VENDORID>
<DISTTYPE>2</DISTTYPE>
<ACTNUMST>000-2100-00</ACTNUMST>
<CRDTAMNT>550.0000</CRDTAMNT>
</taPMDistribution>
</taPMDistribution_Items>
<taAnalyticsDistribution_Items>
<taAnalyticsDistribution>
<DOCNMBR>GE5582-0</DOCNMBR>
<AMOUNT>200.00</AMOUNT>
<aaAssignedPercent>100</aaAssignedPercent>
<DistSequence>24141</DistSequence>
<ACTNUMST>999-9999-01</ACTNUMST>
<aaTrxDim>SHOP Project</aaTrxDim>
<aaTrxDimCode>22-11-10063</aaTrxDimCode>
<aaSubLedgerDistID>1</aaSubLedgerDistID>
</taAnalyticsDistribution>
<taAnalyticsDistribution>
<DOCNMBR>GE5582-0</DOCNMBR>
<AMOUNT>200.00</AMOUNT>
<aaAssignedPercent>100</aaAssignedPercent>
<DistSequence>24150</DistSequence>
<ACTNUMST>999-9999-01</ACTNUMST>
<aaTrxDim>Internal Project</aaTrxDim>
<aaTrxDimCode>22-11-10062</aaTrxDimCode>
<aaSubLedgerDistID>2</aaSubLedgerDistID>
</taAnalyticsDistribution>
</taAnalyticsDistribution_Items>
<taPMTransactionInsert>
<BACHNUMB>GORILLA</BACHNUMB>
<VCHNUMWK>GE5582-0</VCHNUMWK>
<VENDORID>ACETRAVE0001</VENDORID>
<DOCNUMBR>GE5582-0</DOCNUMBR>
<DOCTYPE>1</DOCTYPE>
<DOCAMNT>550.0000</DOCAMNT>
<DOCDATE>02/09/2023</DOCDATE>
<PRCHAMNT>550.0000</PRCHAMNT>
<CHRGAMNT>550.0000</CHRGAMNT>
<CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>
<taMdaUpdate_Items xsi:nil="true" />
</PMTransactionType>
</eConnect>