DynDeveloper.com

DynDeveloper.com

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