Open Forum

Expand all | Collapse all

eConnect error - invoicing drop-ship PO

  • 1.  eConnect error - invoicing drop-ship PO

    Posted Feb 12, 2020 04:24 PM
    We're trying to integrate an app via eConnect and I can't figure out why we're getting an error.
    We're getting the error back "taPopRcptLineInsert: You can only enter Invoice receipts for a Drop Ship Purchase Order" but it is a drop-ship PO.
    Here is an example of what we're sending:

    <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

      <POPReceivingsType>

        <eConnectProcessInfo>

          <ConnectionString>Data Source=SERVER; Initial Catalog=TEST; Integrated Security=SSPI; Persist Security Info=False; Packet Size=4096</ConnectionString>

        </eConnectProcessInfo>

        <taRequesterTrxDisabler_Items xsi:nil="true" />

        <taUpdateCreateItemRcd xsi:nil="true" />

        <taUpdateCreateVendorRcd xsi:nil="true" />

        <taCreateVendorAddress_Items xsi:nil="true" />

        <taPopRcptLotInsert_Items xsi:nil="true" />

        <taPopRcptSerialInsert_Items xsi:nil="true" />

        <taPopRcptLineInsert_Items>

          <taPopRcptLineInsert>

            <POPTYPE>3</POPTYPE>

            <POPRCTNM>RCT12345</POPRCTNM>

            <PONUMBER>PO00001234</PONUMBER>

            <ITEMNMBR>WIDGET</ITEMNMBR>

            <VENDORID>12345</VENDORID>

            <RCPTLNNM>2</RCPTLNNM>

            <INVINDX>6335</INVINDX>

            <UOFM>Each</UOFM>

            <UNITCOST>4.25000</UNITCOST>

            <EXTDCOST>850.00</EXTDCOST>

            <NONINVEN>1</NONINVEN>

            <QTYSHPPD>200.00000</QTYSHPPD>

            <QTYINVCD>200.00000</QTYINVCD>

            <Purchase_Site_Tax_Schedu>               </Purchase_Site_Tax_Schedu>

            <LOCNCODE>HERE</LOCNCODE>

            <POLNENUM>32768</POLNENUM>

            <receiptdate>2/6/2020</receiptdate>

          </taPopRcptLineInsert>

        </taPopRcptLineInsert_Items>

        <taPopRcptMultiBin_Items xsi:nil="true" />

        <taPopRcptLineTaxInsert_Items />

        <taPopRctUserDefined xsi:nil="true" />

        <taPopDistribution_Items xsi:nil="true" />

        <taAnalyticsDistribution_Items xsi:nil="true" />

        <taPopRcptHdrInsert>

          <POPRCTNM>RCT12345</POPRCTNM>

          <POPTYPE>3</POPTYPE>

          <VNDDOCNM>ABCD</VNDDOCNM>

          <receiptdate>2/6/2020</receiptdate>

          <BACHNUMB>TEST</BACHNUMB>

          <VENDORID>12345</VENDORID>

          <SUBTOTAL>850.00000</SUBTOTAL>

          <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>

        </taPopRcptHdrInsert>

        <taMdaUpdate_Items xsi:nil="true" />

      </POPReceivingsType>


    Any ideas on what could be wrong?
    Thanks.

    ------------------------------
    Chris Adaline
    Wounded Warrior Project, Inc.
    Jacksonville FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: eConnect error - invoicing drop-ship PO

    GPUG ALL STAR
    Posted Feb 12, 2020 04:43 PM
    Hi @Chris Adaline

    Your POPTYPE is a 3, which is a Blanket PO, not a Drop-Ship​

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: eConnect error - invoicing drop-ship PO

    Posted Feb 13, 2020 08:47 AM
    Thank you for your quick response.  I don't think the eConnect node is same as the POP tables.  The reference shows that 1 = Shipment and 3 = Shipment/Invoice (https://docs.microsoft.com/en-us/previous-versions/dynamicsgp/developer/ff623950(v=msdn.10) ).

    ------------------------------
    Chris Adaline
    Wounded Warrior Project, Inc.
    Jacksonville FL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: eConnect error - invoicing drop-ship PO

    GPUG ALL STAR
    Posted Feb 13, 2020 08:58 AM
    @Chris Adaline

    I did not read that this was a Pop Receipt, I read that it was straight POP.

    In essence, though, if the Purchase Order is Drop Ship you cannot do a Receipt/Invoice you can only go straight to Invoice since the product will never be in YOUR warehouse, but is being sent to a client site, one of your customers.

    You still must change the POPTYPE to 2, to be a straight Invoice and not a receivings invoice in order to invoice a drop-ship PO

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role