Share
ReportWe are receiving the above error when attempting to insert a sales order into GP2015 via eConnect. Our original document included all of the necessary components (customer, addresses, lines, payment, header, etc.) and has worked for many other clients in the past. Here I have broken it down and submitted the customer and addresses separately successfully, just to confirm that eConnect was working at all. I continued to break down the order document until I was left with nothing but the absolutely required fields in the header, and yet still we receive the error. If I log into GP and manually create a sales order entry, using only the same required fields, it completes and saves successfully. Below is the eConnect xml document that I am trying to post, and the stack trace returned. Any suggestions to move past this would be greatly appreciated.
<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../XMLSchema">
<SOPTransactionType>
<taSopHdrIvcInsert>
<SOPTYPE>2</SOPTYPE>
<DOCID>ORDERS</DOCID>
<SOPNUMBE>1008</SOPNUMBE>
<DOCDATE>01-13-2016</DOCDATE>
<CUSTNMBR>TESTERYH0001</CUSTNMBR>
<BACHNUMB>WEB</BACHNUMB>
</taSopHdrIvcInsert>
</SOPTransactionType>
</eConnect>
Microsoft.Dynamics.GP.eConnect.eConnectException: Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
at Microsoft.Dynamics.GP.eConnect.ServiceProxy.HandleSqlException(FaultException`1 ex)
at Microsoft.Dynamics.GP.eConnect.ServiceProxy.CreateEntity(String connectionString, String xml)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)
at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML)
at DirectDocSenderDotNet.FrmDocSender.btnSend_Click(Object sender, EventArgs e) in c:\Users\ekersey\Desktop\eConnect 14.0\eConnect Samples\CSHARP DirectDocSender\frmDocSender.cs:line 384
*This post is locked for comments
All responses (
Answers (
3