Rich Stephens 1/13/2015 2:03:41 PM

eConnect - Shipment Line Item does not exist to match Invoice against

OK, here we go.  This is a long one.  I've gotten past my original error in creating the shipping receipt.

That said, The shipping receipt, RCT1185, got successfully created.  HOWEVER, it seems like GP created TWO shipping receipts for some reason: The one I requested, RCT1185, and an identical one pointing to the same PO, RCT1187 (This is NOT an invoice receipt - it's a shipping receipt).  I'm not sure if this happened when I created the shipping receipt transaction, or when I later sent the invoice with the RCT1185 shipping receipt referenced. I know I didn't create two of them, because if I had, it would be in my application log.

The receipt was created successfully. However, when I tried to create the invoice, I got the following error:

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

Error Number = 4852  Stored Procedure= taPopEnterMatchInvLine  Error Description = Shipment Line Item does not exist to match Invoice against
Node Identifier Parameters: taPopEnterMatchInvLine
POPRCTNM = RCT1186
PONUMBER = PO2075
POLNENUM = 16384
Related Error Code Parameters for Node : taPopEnterMatchInvLine
PONUMBER = PO2075
POPMtchShpRcpt = RCT1187
ShipRCPTLNNM = 16384
ITEMNMBR = 256 SDRAM
VENDORID = COMVEXIN0001

<taPopEnterMatchInvLine>
  <POPRCTNM>RCT1186</POPRCTNM>
  <POPMtchShpRcpt>RCT1187</POPMtchShpRcpt>
  <ShipRCPTLNNM>16384</ShipRCPTLNNM>
  <PONUMBER>PO2075</PONUMBER>
  <QTYINVCD>1.00000</QTYINVCD>
  <ITEMNMBR>256 SDRAM</ITEMNMBR>
  <VENDORID>COMVEXIN0001</VENDORID>
  <UNITCOST>0</UNITCOST>
  <EXTDCOST>0</EXTDCOST>
  <AUTOCOST>1</AUTOCOST>
  <POLNENUM>16384</POLNENUM>
< /taPopEnterMatchInvLine>

For reference, here is the shipping receipt transaction I sent:

<?xml version="1.0"?>
< eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
     <POPReceivingsType>
          <eConnectProcessInfo xsi:nil="true" />
          <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>1</POPTYPE>
                    <POPRCTNM>RCT1185</POPRCTNM>
                    <PONUMBER>PO2075</PONUMBER>
                    <ITEMNMBR>256 SDRAM</ITEMNMBR>
                    <VENDORID>COMVEXIN0001</VENDORID>
                    <RCPTLNNM>16384</RCPTLNNM>
                    <VNDITNUM>256 SDRAM</VNDITNUM>
                    <QTYSHPPD>1.00000</QTYSHPPD>
                    <AUTOCOST>1</AUTOCOST>
                    <POLNENUM>16384</POLNENUM>
               </taPopRcptLineInsert>
          </taPopRcptLineInsert_Items>
          <taPopRcptMultiBin_Items xsi:nil="true" />
          <taPopRcptLineTaxInsert_Items xsi:nil="true" />
          <taPopRctUserDefined xsi:nil="true" />
          <taPopDistribution_Items xsi:nil="true" />
          <taAnalyticsDistribution_Items xsi:nil="true" />
          <taPopRcptHdrInsert>
               <POPRCTNM>RCT1185</POPRCTNM>
               <POPTYPE>1</POPTYPE>
               <receiptdate>1/13/2015</receiptdate>
               <BACHNUMB>PAYABLES BATCH </BACHNUMB>
               <VENDORID>COMVEXIN0001</VENDORID>
               <AUTOCOST>1</AUTOCOST>
               <NOTETEXT>http://sp2010dev/tap/Invoices/Invoice2.pdf</NOTETEXT>
               <USRDEFND4>http://sp2010dev/tap/Invoices/Invoice2.pdf</USRDEFND4>
          </taPopRcptHdrInsert>
          <taMdaUpdate_Items xsi:nil="true" />
     </POPReceivingsType>
< /eConnect>

Here is the invoice transaction I sent:

<?xml version="1.0"?>
< eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <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 xsi:nil="true" />
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopEnterMatchLotInsert_Items xsi:nil="true" />
    <taPopEnterMatchSerialInsert_Items xsi:nil="true" />
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCT1184</POPRCTNM>
        <POPMtchShpRcpt>RCT1185</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>PO2075</PONUMBER>
        <QTYINVCD>1.00000</QTYINVCD>
        <ITEMNMBR>256 SDRAM</ITEMNMBR>
        <VENDORID>COMVEXIN0001</VENDORID>
        <UNITCOST>0</UNITCOST>
        <EXTDCOST>0</EXTDCOST>
        <AUTOCOST>1</AUTOCOST>
        <POLNENUM>16384</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items />
    <taPopEnterMatchInvHdr>
      <POPRCTNM>RCT1184</POPRCTNM>
      <VNDDOCNM>12345-2075</VNDDOCNM>
      <receiptdate>1/13/2015</receiptdate>
      <BACHNUMB>PAYABLES BATCH </BACHNUMB>
      <VENDORID>COMVEXIN0001</VENDORID>
      <SUBTOTAL>0</SUBTOTAL>
      <AUTOCOST>1</AUTOCOST>
      <NOTETEXT>http://sp2010dev/tap/Invoices/Invoice2.pdf</NOTETEXT>
      <USRDEFND4>http://sp2010dev/tap/Invoices/Invoice2.pdf</USRDEFND4>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPEnterMatchInvoiceType>
< /eConnect>

Version: GP 2013
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3