kretek 5/5/2016 2:00:17 PM

Attaching a payment to a Sales Order through econnect

Hi,

I am trying to update a payment that exists already and to a Sales order that already exists. I have the SO saving without the payment. however with the payment which is a EFT its giving me an invalid payment type.

 

This works with a SOTYPE of 3, however i am trying to attach it to a sales order and not a invoice

 

Action:

Service Create

 

Current User Name:

KRETEK2\eConnectService

 

Input parameters:

 

Exception type:

Microsoft.Dynamics.GP.eConnect.eConnectException

 

Exception message:

Sql procedure error codes returned:

 

Error Number = 4006  Stored Procedure= taCreateSopPaymentInsertRecord  Error Description = Invalid Payment Type (1=Cash Deposit, 2=Check Deposit, 3=Credit Card Deposit, 6=Credit Card Payment) Node Identifier Parameters: taCreateSopPaymentInsertRecord SOPNUMBE = 2148256 SOPTYPE = 2 PYMTTYPE = 5 Related Error Code Parameters for Node : taCreateSopPaymentInsertRecord PYMTTYPE = 5

 

 

<taCreateSopPaymentInsertRecord>

  <SOPTYPE>2</SOPTYPE>

  <SOPNUMBE>2148256</SOPNUMBE>

  <CUSTNMBR>TEST</CUSTNMBR>

  <DOCDATE>5/5/2016</DOCDATE>

  <DOCAMNT>146.93000</DOCAMNT>

  <CHEKNMBR>EFT00002493</CHEKNMBR>

  <PYMTTYPE>5</PYMTTYPE>

</taCreateSopPaymentInsertRecord>

 

 

Stack Trace:

   at Microsoft.Dynamics.GP.eConnect.EntityMessageProcessor.ExecuteSqlCommands(XElement transactionNode, EntityMessage message)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessMessageImport(EntityMessage message)

   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 Microsoft.Dynamics.GP.eConnect.Service.CreateEntity(String ConnectionString, String sXML) Exception type:

Microsoft.Dynamics.GP.eConnect.eConnectException

 

Exception message:

Error Number = 4006 Stored Procedure taCreateSopPaymentInsertRecord  Error Description = Invalid Payment Type (1=Cash Deposit, 2=Check Deposit, 3=Credit Card Deposit, 6=Credit Card Payment) 

 

 

 

Stack Trace:

 

Version: GP 2013
Section: 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