DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

This article contains sample XML for the eConnect PAContractType transaction. The code includes a sample Project, and three budget lines

 

This article contains the VB.NET code to create a PA Contracts, along with a sample Project and Budget lines

The code requires three tables, the SQL to create the tables is below the article. It also requires data access code to access the tables. That code is also at the bottom. 

This article contains a short, working code example for getting a list of vendors from GP using eConnect out

The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

Note that this article is specific to eConnect out

The solution was to edit the app.config file as shown below.

This is a working XML example of sending the POPEnterMatchInvoiceType schema. It includes no tax, but has freight and freight tax.

In order to recreate this you'll need to key a PO, the key a Shipment document against that PO. This Enter/Match will import the vendor invoice for the shipment. 

This is a WORKING XML document that shows how to code the POPEnterMatchInvoice type with a Freight Amount, Freight Tax, and Manual Distributions

Hello,

I am trying to delete a line item for an existing Purchase Order using eConnect. Skimming through the eConnect XML Node Reference I found that the '<taSopLineDelete>node exists (which seems to handle deleting Sales Order lines)  -  but I can't find an equivalent for a Purchase Order. The node '<taPopPoDelete>' appears to only handle deleting the entire Purchase Order.

I have tried to pass variations of the '<taPoLine>' node to eConnect but it always seems to add/update the line. I'm not certain what combination of properties I would need to pass in order to tell eConnect to remove the line. I have been setting the 'UpdateIfExists' flag to true, perhaps I need to be using Document Exchange instead (set this flag to false)?

I'm sure I could probably remove the record via a direct sql call, but I know that the POP10110 record is referenced from a few other tables and don't want to end up with a mess on my hands.

Any ideas?

I am currently trying to retrieve all active vendors from a particular company using eConnectOut.  I am able to retrieve a majority of the vendors but some of the newly created vendors are not being exported.

 

Here is the code I am currently using to do this.  Any information is greatly appreciated.

01.01.eConnectType myEConnectType = new eConnectType();
02.02.
03.03.// Create a RQeConnectOutType schema object
04.04.RQeConnectOutType myReqType = new RQeConnectOutType();
05.05.
06.06.// Create an eConnectOut XML node object
07.07.eConnectOut myeConnectOut = new eConnectOut();
08.08.
09.09.//SETUP: Vendor Name and ID Retrieval
10.10.myeConnectOut.DOCTYPE = "Vendor";
11.11.myeConnectOut.OUTPUTTYPE = 1;
12.12.myeConnectOut.FORLIST = 1;
13.13.myeConnectOut.ACTION = 1;
14.14.myeConnectOut.WhereClause = "VENDSTTS  = 1";
15.15.
16.16.// Add the eConnectOut XML node object to the RQeConnectOutType schema object
17.17.myReqType.eConnectOut = myeConnectOut;
18.18.
19.19.// Add the RQeConnectOutType schema object to the eConnect document object
20.20.RQeConnectOutType[] myReqOutType = { myReqType };
21.21.myEConnectType.RQeConnectOutType = myReqOutType;
22.

I'm getting the following eConnect error.  Can anyone help me figure out why?  The XML I'm sending is below

ERROR: Error updating EnterMatchInvHdr for PO - NLNPO0002951 - Sql procedure error codes returned: 

Error Number = 4807  Stored Procedure= taPopEnterMatchInvHdr  Error Description = No Freight Tax schedule, but a freight tax value was passed in

Error Number = 4810  Stored Procedure= taPopEnterMatchInvHdr  Error Description = No Misc Tax schedule, but a misc tax value was passed in

 

<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <POPEnterMatchInvoiceType>
    <eConnectProcessInfo xsi:nil="true"/>
    <taRequesterTrxDisabler_Items xsi:nil="true"/>
    <taUpdateCreateItemRcd xsi:nil="true"/>
    <taUpdateCreateVendorRcd xsi:nil="true"/>
    <taCreateVendorAddress_Items xsi:nil="true"/>
    <taPopRcptLineTaxInsert_Items>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <TAXDTLID>LAWRENCEVILLE</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>484</ACTINDX>
        <ACTNUMST>00-99999-1002-021-00000</ACTNUMST>
        <TAXAMNT>0.27</TAXAMNT>
        <TAXPURCH>75.73</TAXPURCH>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <TAXDTLID>LAWRENCEVILLE</TAXDTLID>
        <TAXTYPE>1</TAXTYPE>
        <ACTINDX>19655</ACTINDX>
        <ACTNUMST>00-90001-3012-065-00000</ACTNUMST>
        <TAXPURCH>75.73</TAXPURCH>
        <FRTTXAMT>0.25</FRTTXAMT>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <TAXDTLID>LAWRENCEVILLE</TAXDTLID>
        <TAXTYPE>2</TAXTYPE>
        <ACTINDX>418</ACTINDX>
        <ACTNUMST>00-90001-3012-010-00000</ACTNUMST>
        <TAXPURCH>75.73</TAXPURCH>
        <MSCTXAMT>0.26</MSCTXAMT>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true"/>
    <taAnalyticsDistribution_Items xsi:nil="true"/>
    <taPopEnterMatchLotInsert_Items xsi:nil="true"/>
    <taPopEnterMatchSerialInsert_Items xsi:nil="true"/>
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>NLNRCT0007105</POPRCTNM>
        <POPMtchShpRcpt>NLNRCT0007083</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>NLNPO0002951</PONUMBER>
        <QTYINVCD>2.00</QTYINVCD>
        <ITEMNMBR>CT2KIT51264BF160B</ITEMNMBR>
        <VENDORID>CDW</VENDORID>
        <VNDITNUM>CT2KIT51264BF160B</VNDITNUM>
        <UNITCOST>0</UNITCOST>
        <EXTDCOST>0</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <AUTOCOST>1</AUTOCOST>
        <POLNENUM>1</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items/>
    <taPopEnterMatchInvHdr>
      <POPRCTNM>NLNRCT0007105</POPRCTNM>
      <VNDDOCNM>test14565</VNDDOCNM>
      <receiptdate>01/03/2018</receiptdate>
      <BACHNUMB>TAP-01/09/2018</BACHNUMB>
      <VENDORID>CDW</VENDORID>
      <SUBTOTAL>0</SUBTOTAL>
      <TAXAMNT>0.27</TAXAMNT>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>LAWRENCEVILLE</TAXSCHID>
      <FRTSCHID>LAWRENCEVILLE</FRTSCHID>
      <MSCSCHID>LAWRENCEVILLE</MSCSCHID>
      <FRTTXAMT>0.25</FRTTXAMT>
      <MSCTXAMT>0.26</MSCTXAMT>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true"/>
  </POPEnterMatchInvoiceType>
</eConnect>

Error: Tax Schedule (TAXSCHID) does not exist in the TX00101 Table

I'm uploading PO data into GP using eConnect.  Part of this upload is header taxes, freight, and misc.  All the data is uploading, but the TYPE is not being set correctly.  They all show TAX.  But if you look at the XML, the TAXTYPE is set correctly for each line. 

TaxType=0=Regular
TaxType=1=Freight
TaxType=2=Misc

I then found out that setting the <FRTAMNT> and <MISCAMNT> will create the types I want, but I need those account string assigned to that FREIGHT line.  That is why I created 3 TAX lines in the XML.

Am I missing something in the Tax Lines?  Or the Header Line? 

<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <POPEnterMatchInvoiceType>
    <eConnectProcessInfo xsi:nil="true"/>
    <taRequesterTrxDisabler_Items xsi:nil="true"/>
    <taUpdateCreateItemRcd xsi:nil="true"/>
    <taUpdateCreateVendorRcd xsi:nil="true"/>
    <taCreateVendorAddress_Items xsi:nil="true"/>
    <taPopRcptLineTaxInsert_Items>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>32004</ACTINDX>
        <ACTNUMST>00-82034-6060-015-00000</ACTNUMST>
        <TAXAMNT>2.00</TAXAMNT>
        <TAXPURCH>32.50</TAXPURCH>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>1</TAXTYPE>
        <ACTINDX>31553</ACTINDX>
        <ACTNUMST>00-82034-6030-010-00000</ACTNUMST>
        <TAXPURCH>32.50</TAXPURCH>
        <FRTTXAMT>1.00</FRTTXAMT>
      </taPopRcptLineTaxInsert>
      <taPopRcptLineTaxInsert>
        <VENDORID>CDW</VENDORID>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <TAXDTLID>CITY OF BRYAN</TAXDTLID>
        <TAXTYPE>2</TAXTYPE>
        <ACTINDX>31554</ACTINDX>
        <ACTNUMST>00-82034-6030-017-00000</ACTNUMST>
        <TAXPURCH>32.50</TAXPURCH>
        <MSCTXAMT>1.50</MSCTXAMT>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true"/>
    <taAnalyticsDistribution_Items xsi:nil="true"/>
    <taPopEnterMatchLotInsert_Items xsi:nil="true"/>
    <taPopEnterMatchSerialInsert_Items xsi:nil="true"/>
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>NLNRCT0007120</POPRCTNM>
        <POPMtchShpRcpt>NLNRCT0007037</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>NLNPO0002538</PONUMBER>
        <QTYINVCD>2.00</QTYINVCD>
        <ITEMNMBR>88011-99</ITEMNMBR>
        <VENDORID>CDW</VENDORID>
        <VNDITNUM>88011-99</VNDITNUM>
        <UNITCOST>0</UNITCOST>
        <EXTDCOST>0</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <AUTOCOST>1</AUTOCOST>
        <POLNENUM>1</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items/>
    <taPopEnterMatchInvHdr>
      <POPRCTNM>NLNRCT0007120</POPRCTNM>
      <VNDDOCNM>test123cpt1</VNDDOCNM>
      <receiptdate>12/17/2017</receiptdate>
      <BACHNUMB>TAP-01/11/2018</BACHNUMB>
      <VENDORID>CDW</VENDORID>
      <SUBTOTAL>0</SUBTOTAL>
      <FRTAMNT>1.00</FRTAMNT>
      <MISCAMNT>1.50</MISCAMNT>
      <TAXAMNT>2.00</TAXAMNT>
      <AUTOCOST>1</AUTOCOST>
      <TAXSCHID>LAWRENCEVILLE</TAXSCHID>
      <Purchase_Freight_Taxable>1</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>1</Purchase_Misc_Taxable>
      <FRTSCHID>LAWRENCEVILLE</FRTSCHID>
      <MSCSCHID>LAWRENCEVILLE</MSCSCHID>
      <FRTTXAMT>1.00</FRTTXAMT>
      <MSCTXAMT>1.50</MSCTXAMT>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true"/>
  </POPEnterMatchInvoiceType>
</eConnect>

 

 

In this screen shot, I want the FREIGHT Line to contain the Account String from one of those TAX lines.  Same with the MISC Line.

Hi, 

I am trying to do a return sales through econnect. Also I want to inventory transfer to take place in  proper site in respective bin. I have copied my xml structure below. But the inventory transfer takes in in default bin. But I want to take it the bin I want not in the default bin. Also the quantity gets added twice in default bin. Can you please help me?

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <SOPTransactionType>
    <taSopLineIvcInsert_Items>
      <taSopLineIvcInsert>
        <SOPTYPE>4</SOPTYPE>
        <CUSTNMBR>AMAZ01</CUSTNMBR>
        <DOCDATE>2018-01-16</DOCDATE>
        <LOCNCODE>SJ_RETURNS</LOCNCODE>
        <ITEMNMBR>IBAT40XRP</ITEMNMBR>
        <UNITPRCE>143.7</UNITPRCE>
        <XTNDPRCE>287.4</XTNDPRCE>
        <QUANTITY>2</QUANTITY>
        <PRCLEVEL>FOBUSA</PRCLEVEL>
        <QTYONHND>2</QTYONHND>
        <DOCID>R</DOCID>
        <SOPNUMBE>RTN00000000018274</SOPNUMBE>
      </taSopLineIvcInsert>
    </taSopLineIvcInsert_Items>
    <taSopMultiBin_Items>
      <taSopMultiBin>
        <SOPTYPE>4</SOPTYPE>
        <ITEMNMBR>IBAT40XRP</ITEMNMBR>
        <BIN>100TRI_RETURNS</BIN>
        <QUANTITY>2</QUANTITY>
        <CreateBin>1</CreateBin>
        <USRDEFND1>Check the bin set to 100 tri</USRDEFND1>
        <SOPNUMBE>RTN00000000018274</SOPNUMBE>
      </taSopMultiBin>
    </taSopMultiBin_Items>
    <taSopHdrIvcInsert>
      <SOPTYPE>4</SOPTYPE>
      <DOCID>R</DOCID>
      <LOCNCODE>SJ_RETURNS</LOCNCODE>
      <DOCDATE>2018-01-16</DOCDATE>
      <TRDISAMT>0</TRDISAMT>
      <CUSTNMBR>AMAZ01</CUSTNMBR>
      <CSTPONBR>PRIYAdfdg</CSTPONBR>
      <SUBTOTAL>287.4</SUBTOTAL>
      <DOCAMNT>287.4</DOCAMNT>
      <BACHNUMB>PRITEST110</BACHNUMB>
      <SOPNUMBE>RTN00000000018274</SOPNUMBE>
    </taSopHdrIvcInsert>
  </SOPTransactionType>
</eConnect>

Thanks

Priya