Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
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