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: