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
kv 1/15/2016 11:26:18 AM

eConnect Validation Error

Editor's note: the main article for this error is here 

Hi, I've tried everything suggested, even got a team viewer session onto their server to check but cannot figure out why this is not working on their test system but it works on my sample data system

eCONNECT VALIDATION ERROR: Microsoft.Dynamics.GP.eConnect.eConnectException: Sql procedure error codes returned: 

Error Number = 4612  Stored Procedure= taPopRcptLineInsert  Error Description = Invalid Account Index
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 3
POPRCTNM = R000095
ITEMNMBR = Laynards x 30
Related Error Code Parameters for Node : taPopRcptLineInsert
INVINDX = Note: This parameter was not passed in, no value for the parameter will be returned.


<taPopRcptLineInsert>
  <POPTYPE>3</POPTYPE>
  <POPRCTNM>R000095</POPRCTNM>
  <ITEMNMBR>Laynards x 30</ITEMNMBR>
  <ITEMDESC>Laynards x 30</ITEMDESC>
  <VENDORID>TAN002</VENDORID>
  <RCPTLNNM>1</RCPTLNNM>
  <UOFM>Each</UOFM>
  <UNITCOST>43.20</UNITCOST>
  <EXTDCOST>86.40</EXTDCOST>
  <NONINVEN>1</NONINVEN>
  <QTYSHPPD>2</QTYSHPPD>
  <QTYINVCD>2</QTYINVCD>
  <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
  <LOCNCODE>NO PROJECT</LOCNCODE>
  <CURNCYID>GBP</CURNCYID>
</taPopRcptLineInsert>

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String ConnectionString, String sXML)
   at RemoteServerTest.Program.PostXMLToDynamics()

 

XML

<?xml version="1.0" encoding="UTF-8"?>
    <POPReceivingsType>
        <taPopRcptLineInsert_Items>
            <taPopRcptLineInsert>
                <POPTYPE>3</POPTYPE>
                <POPRCTNM>R000095</POPRCTNM>
                <ITEMNMBR>Laynards x 30</ITEMNMBR>
                <ITEMDESC>Laynards x 30</ITEMDESC>
                <VENDORID>TAN002</VENDORID>
                <RCPTLNNM>1</RCPTLNNM>
                <UOFM>Each</UOFM>
                <UNITCOST>43.20</UNITCOST>
                <EXTDCOST>86.40</EXTDCOST>
                <NONINVEN>1</NONINVEN>
                <QTYSHPPD>2</QTYSHPPD>
                <QTYINVCD>2</QTYINVCD>
                <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
                <LOCNCODE>NO PROJECT</LOCNCODE>
                <CURNCYID>GBP</CURNCYID>
            </taPopRcptLineInsert>
        </taPopRcptLineInsert_Items>
 
        <taPopRcptLineTaxInsert_Items>
            <taPopRcptLineTaxInsert>
                <VENDORID>TAN002</VENDORID>
                <POPRCTNM>R000095</POPRCTNM>
                <TAXDTLID>PSTD</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <ACTINDX>102</ACTINDX>
                <ACTNUMST>1300-00</ACTNUMST>
                <TAXAMNT>8.64</TAXAMNT>
                <RCPTLNNM>1</RCPTLNNM>
            </taPopRcptLineTaxInsert>
        </taPopRcptLineTaxInsert_Items>
 
        <taPopRcptHdrInsert>
            <POPRCTNM>R000095</POPRCTNM>
            <POPTYPE>3</POPTYPE>
            <VNDDOCNM>87521</VNDDOCNM>
            <receiptdate>01/01/0001</receiptdate>
            <BACHNUMB>15012016042005</BACHNUMB>
            <AUTOCOST>1</AUTOCOST>
            <TAXSCHID>PSTD</TAXSCHID>
            <USINGHEADERLEVELTAXES>2</USINGHEADERLEVELTAXES>
            <CURNCYID>GBP</CURNCYID>
        </taPopRcptHdrInsert>
 
    </POPReceivingsType>
</eConnect>

 

Posting Accounts - all set up

 

GL00105 table:

ACTINDX: 102 

ACTNUMST: 1300-00                                                                                                                          

 

 

What else am I missing?  Thanks a lot

Version: GP 2010
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