Hello,
I am attempting to update an existing invoice with a payment.
Here is my message:
<?xml version="1.0"?>
<eConnect>
<SOPTransactionType>
<taCreateSopPaymentInsertRecord_Items>
<taCreateSopPaymentInsertRecord>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>INV00123935</SOPNUMBE>
<CUSTNMBR>500006</CUSTNMBR>
<DOCAMNT>87.50</DOCAMNT>
<PYMTTYPE>6</PYMTTYPE>
<CARDNAME>VISA</CARDNAME>
<DOCNUMBR>INV00123935</DOCNUMBR>
<Action>1</Action>
<UpdateExisting>1</UpdateExisting>
</taCreateSopPaymentInsertRecord>
</taCreateSopPaymentInsertRecord_Items>
<taSopHdrIvcInsert>
<SOPTYPE>3</SOPTYPE>
<DOCID>INV</DOCID>
<SOPNUMBE>INV00123935</SOPNUMBE>
<DOCDATE>2015-01-15</DOCDATE>
<CUSTNMBR>500006</CUSTNMBR>
<PYMTRCVD>87.50</PYMTRCVD>
<BACHNUMB>TEST_20150115_15</BACHNUMB>
<UpdateExisting>1</UpdateExisting>
</taSopHdrIvcInsert>
<taSopHdrIvcInsert>
<UpdateExisting>1</UpdateExisting>
</taSopHdrIvcInsert>
</SOPTransactionType>
</eConnect>
But gp2013 throws the following SQL error?
error attempting to insert into SOP010106 (INV00123935 , )
the extra spaces are logged in event manager.
Is this a SQL permissions issue, incorrect eConnect operation or message content?
Stephen