Share
ReportI get the following SQL error code response when I try to post a bill to GP through eConnect.
Error Number = 349 Stored Procedure= taPMTransactionInsert
Error Description = Unable to update/create distributions
Error Number = 700 Stored Procedure= taPMDistributionCreate
Error Description = At least one input variable contains a null value in the
taPMDistributionCreate
We are setting all the mandatory fields in the input xml.
Sample input xml:
<?xml version="1.0"?>
<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>00000000000018299</VCHRNMBR>
<VENDORID><![CDATA[ABSOLUTE]]></VENDORID>
<DISTTYPE>6</DISTTYPE>
<DistRef>INV# 3147140</DistRef>
<ACTINDX>828</ACTINDX>
<DEBITAMT>230</DEBITAMT>
</taPMDistribution>
<taPMDistribution>
<DOCTYPE>1</DOCTYPE>
<VCHRNMBR>00000000000018299</VCHRNMBR>
<VENDORID><![CDATA[ABSOLUTE]]></VENDORID>
<DISTTYPE>2</DISTTYPE>
<ACTINDX>69</ACTINDX>
<CRDTAMNT>230</CRDTAMNT>
</taPMDistribution>
</taPMDistribution_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taPMTransactionInsert>
<BACHNUMB>MT_INV</BACHNUMB>
<VCHNUMWK>00000000000018299</VCHNUMWK>
<VENDORID><![CDATA[ABSOLUTE]]></VENDORID>
<DOCNUMBR>3147140</DOCNUMBR>
<DOCTYPE>1</DOCTYPE>
<DOCAMNT>230</DOCAMNT>
<DOCDATE>3/7/2017</DOCDATE>
<PYMTRMID>Net 30</PYMTRMID>
<DUEDATE>4/6/2017</DUEDATE>
<PRCHAMNT>230</PRCHAMNT>
<CHRGAMNT>230</CHRGAMNT>
<TRXDSCRN>INV# 3147140</TRXDSCRN>
<CREATEDIST>0</CREATEDIST>
</taPMTransactionInsert>
<taMdaUpdate_Items xsi:nil="true" />
</PMTransactionType>
</eConnect>
Can some one please take a look at this and let me know what is the issue.
*This post is locked for comments
All responses (
Answers (
40
