DynDeveloper.com

I love my job. Really. Every day is something new.

Yesterday a major ISV contacted us for help with what appeared to be a failed eConnect install, they were using the Transaction Requestor functionality in eConnect to get data about a Vendor in GP and it was failing with an odd error. I've seen a great number of eConnect errors <smiles>, this one was new.

The error said (in part):

Error getting Vendor for vendor ID '<vendor name>': The specified schema name "dbo" either does not exist or you do not have permission to use it.
Cannot find the object 'raRequesterVendor2', because it does not exist or you do not have permission.
Could not find stored procedure 'dbo.taRequesterVendor2'

During the troubleshooting, we discovered that the eConnect_out_setup table had only 1 line. It should have around 500. In our case, it only had the Cash_Receipt line, which is the first one in our demo install.

There should also be two or three stored procedure in the database that start with 'taRequester' for each line in eConnect_out_setup. We had only three, the three that go with Cash_Receipt: taRequesterCash_Receipt0, taRequesterCash_Receipt1, taRequesterCash_Receipt2.

This article discusses how to troubleshoot and repair this failed eConnect install.

I know that this is a forum dedicated to Dynamics GP development, but this issue has happened to me too many times not to blog. I just want to have the answer handy so the next time it happens I can get back to work quickly. I'll file this under 'off topic'

The issue is that Outlook sometimes opens up with the favorites folders rearranges and resists efforts to re-arrange them.

Hi,

So I managed to get a working eConnect solution in dev, have deployed to live and am getting the following validation error:

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 = R000033
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>R000033</POPRCTNM>
  <ITEMNMBR>Item x 30</ITEMNMBR>
  <ITEMDESC>Item 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()

Ihave attempted to add the INVINDX to the eConnect object, but for some reason this parameter does not serialise

My C# is 

[code]

 

                //Invoice Header Details
                invoiceHeader.POPRCTNM = invoice.SupplierDocumentNumber;    //receipt number placeholder
                invoiceHeader.POPTYPE = 3;                                  //Shipping/invoice
                invoiceHeader.VNDDOCNM = invoice.InvoiceNumber;             //invoice number
                invoiceHeader.CURNCYID = "GBP";                             //currency defaults to GBP
                invoiceHeader.TAXSCHID = invoice.TaxSchedule;               //Tax Code
                invoiceHeader.receiptdate = invoice.InvoiceDate.ToString("dd/MM/yyyy");
                invoiceHeader.USINGHEADERLEVELTAXES = 2;
                invoiceHeader.AUTOCOST = 1;
                invoiceHeader.BACHNUMB = batchNumberPlaceHolder;

                oPOPReceivingsType.taPopRcptHdrInsert = invoiceHeader;

                //Invoice lines

                oPOPReceivingsType.taPopRcptLineInsert_Items = new taPopRcptLineInsert_ItemsTaPopRcptLineInsert[invoice.InvoiceLines.Count];

                foreach (OutgoingInvoiceLine line in invoice.InvoiceLines)
                {

                    taPopRcptLineInsert_ItemsTaPopRcptLineInsert ecLine = new taPopRcptLineInsert_ItemsTaPopRcptLineInsert();

                    ecLine.POPRCTNM = invoice.SupplierDocumentNumber;
                    ecLine.VENDORID = vendorReference;
                    ecLine.CURNCYID = "GBP";
                    ecLine.ITEMNMBR = line.ItemDescription;
                    ecLine.ITEMDESC = line.ItemDescription;
                    ecLine.UOFM = "Each";
                    ecLine.QTYINVCD = line.Quantity;
                    ecLine.QTYSHPPD = line.Quantity;
                    ecLine.UNITCOST = Decimal.Parse(line.UnitCost.ToString());
                    ecLine.EXTDCOST = Decimal.Parse(Convert.ToString(line.UnitCost * line.Quantity));
                    ecLine.Purchase_IV_Item_Taxable = 3;
                    ecLine.EXTDCOSTSpecified = true;
                    ecLine.UNITCOSTSpecified = true;
                    ecLine.NONINVEN = 1;
                    ecLine.LOCNCODE = "NO PROJECT";  //default Location Code
                    ecLine.RCPTLNNM = lineNumber;
                    ecLine.POPTYPE = 3;
                    ecLine.INVINDX = 0;

                    oPOPReceivingsType.taPopRcptLineInsert_Items[lineIndex] = ecLine;

                    totalTax += line.UnitCost * line.Quantity;
                    lineIndex++;
                    lineNumber++;
                }

                //Invoice Tax
                invoiceTax.TAXTYPE = 0;
                invoiceTax.POPRCTNM = invoice.SupplierDocumentNumber;
                invoiceTax.VENDORID = vendorReference;
                invoiceTax.TAXDTLID = invoice.TaxDetail;
                invoiceTax.TAXAMNT = totalTax;
                invoiceTax.MSCTXAMT = Decimal.Parse("0.00");
                invoiceTax.FRTTXAMT = Decimal.Parse("0.00");


                oPOPReceivingsType.taPopRcptLineTaxInsert_Items = new taPopRcptLineTaxInsert_ItemsTaPopRcptLineTaxInsert[] { invoiceTax };

[/code]

Having a look around I suspect this is a GL Account set up issue (difference between the databases) - but I can't actually see where I would set this within the XML

Error: Purchase order number does not exist

Trying to receive inventory and I'm getting the following error.

Error Number = 2052  Stored Procedure= taPopRcptLineInsert  Error Description = Purchase order number does not exist Node Identifier Parameters

<?xml version="1.0" encoding="UTF-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <POPReceivingsType>
      <taPopRcptLineInsert_Items>
         <taPopRcptLineInsert>
            <POPTYPE>3</POPTYPE>
            <POPRCTNM>REC65999</POPRCTNM>
            <PONUMBER>4400001168</PONUMBER>
            <ITEMNMBR>ASENA00008</ITEMNMBR>
            <VENDORID>SPE00011</VENDORID>
            <VNDITNUM>ASENA00008</VNDITNUM>
            <QTYSHPPD>250</QTYSHPPD>
            <QTYINVCD>250</QTYINVCD>
         </taPopRcptLineInsert>
      </taPopRcptLineInsert_Items>
      <taPopRcptHdrInsert>
         <POPRCTNM>REC65999</POPRCTNM>
         <POPTYPE>3</POPTYPE>
         <VNDDOCNM>REC65999</VNDDOCNM>
         <receiptdate>1/5/2016</receiptdate>
         <BACHNUMB>R-1-5-2016</BACHNUMB>
         <VENDORID>SPE00011</VENDORID>
      </taPopRcptHdrInsert>
   </POPReceivingsType>
</eConnect>

Error: Decimal Places passed in for UNITCOST does not match setup

Hello, Can anyone guide me on how to resolve the decimal places passed error. I'm using GP version 9 and trying to process the PO manually, I found the error in scribe console error. I have tried to process the po after removing the decimal places but still it is not working.

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

Posting Accounts - all set up

GL00105 table:

ACTINDX: 102 

ACTNUMST: 1300-00                                                                                                                          

What else am I missing?  Thanks a lot

How to know a particular user is having access to contents in smartlist, How can we check this in SQL or in application itself...

Scenario is one of the user is having access to all the smartlist contents, but the other user is having only some of them, how can we provided access to all and update his smartlist view...I have already done the below steps but still there is no luck

Step 1. I have provided access in Smart list Security

Step 2. I have provided access in Smartlist builder - user security windows - update smartlist, View Smartlist with SQL tables

Could anyone help me with this issue...

Hello Everyone,

I have a large monthly batch that billers are constantly adding invoice transactions to, in doing so, this batch is constantly being sent to batch recovery with a status of "posting interrupted" and I'm not sure why.  We use the password functionality on the sales batches so none of the billers can accidentally post this monthly batch too soon.   I know how to fix the monthly batch by running the scripts in sql but I'm more interested and knowing why its happening.  Is it because two people are trying to add to it at once?  Is it because one of them is maybe trying to print and edit list while the other is trying to add to it?

Any feedback would be much appreciated as I would like to put in a better process to improve this daily reset of the stuck batch.

 thanks in advance!

Hi all,

I'm doing an enter match invoice entry for a  client>

I know the procs I need to enter in order but can I process each line item separately?

 Example:  I need to process the following 3 econnect procs per Invoice per Item

<taPopRcptLineTaxInsert>
<taPopDistribution>
<taPopEnterMatchInvLine>

Can I call Tax, Disbribution and the Line proc in order per item on the invoice?

Or do I need to insert all the Tax Lines before doing the Distribution for all items?  Then for all items do the EnterMatchInvLine?

Thanks

Mark