unixtown 1/15/2015 5:48:11 PM

Attempting to update existing invoice using taCreateSopPaymentInsertRecord

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

Version: All
Section: Dynamics GP, eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3