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

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Piterrr 8/9/2011 7:19:55 AM

Problem Sending a Payment to Dynamics

Folks,

I am new to eConnect. I have learned a lot all by myself solving lots of puzzles in the process. My work requires me to only know the basics and I almost know what is required of me. However, I have recently encountered a couple of issues which I am having great deal of troubles with. Here is one of them.

I am trying to create a SOP payment in Dynamics using the taCreateSopPaymentInsertRecord node, as per the xml below.

<?xml version="1.0" encoding="utf-8"?>
<eConnect>
   <SOPTransactionType>
      <eConnectProcessInfo />
      <taCreateSopPaymentInsertRecord_Items>
         <taCreateSopPaymentInsertRecord>
            <SOPTYPE>3</SOPTYPE>
            <SOPNUMBE>STDINV2267</SOPNUMBE>
            <CUSTNMBR>KENSINGT0001</CUSTNMBR>
            <DOCDATE>20/06/2011</DOCDATE>                      <!--EURO DATE FORMAT-->
            <DOCAMNT>20.00</DOCAMNT>
            <PYMTTYPE>4</PYMTTYPE>                                  <!--4=CASH, 5=CHECK, 6=CC-->
            <DOCNUMBR>PMT4CASH</DOCNUMBR>
            <ACTION>1</ACTION>                                              <!--1=NEW TRANSACTION, 2=MODIFY EXISTING-->
         </taCreateSopPaymentInsertRecord>
      </taCreateSopPaymentInsertRecord_Items>
   </SOPTransactionType>
</eConnect>

(I am testing this with Fabrikam).

I get the following error: ERROR: Microsoft.Dynamics.GP.eConnect.eConnectException: Node taSopHdrIvcInsert with required fields is required for new SOPTransactionTypes.

I want to add a (cash) payment against an EXISTING invoice. Why does econnect want me to create a new invoice which I don't need?

TIA

Piterrr

Version: Unknown or N/A
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