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