Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP 2013 creat...
Microsoft Dynamics GP (Archived)

Dynamics GP 2013 create Enter/Match Invoice, pop up error message "4852 Stored Procedure= taPopEnterMatchInvLine Error Description = Shipment Line Item does not exist to match Invoice against"

(0) ShareShare
ReportReport
Posted on by Tony Peng 10

I have created a Purchase Order in GP, and created a PO Receiving Transaction for this PO. After that I use the e-Connect POPEnterMatchInvoiceType to create the Enter/Match Invoice. but e-Connect pops up error message "4852  Stored Procedure= taPopEnterMatchInvLine  Error Description = Shipment Line Item does not exist to match Invoice against". The Xml file as below.

PO Number:PO2085,  the PO Receiving No. is RCT1163.  I checked the PO Receiving thru Receiving Transaction Entry and SQL table POP10500, the Receiving Data is correctly.

<?xml version="1.0" encoding="utf-8"?>

<eConnect xmlns:xsi="www.w3.org/.../XMLSchema-instance" xmlns:xsd="www.w3.org/.../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>122</POPRCTNM>

       <POPMtchShpRcpt>RCT1163</POPMtchShpRcpt>

       <PONUMBER>PO2085</PONUMBER>

       <QTYINVCD>10</QTYINVCD>

       <ITEMNMBR>128 SDRAM</ITEMNMBR>

       <VENDORID>ACETRAVE0001</VENDORID>

       <UNITCOST>152.1</UNITCOST>

       <EXTDCOST>1521</EXTDCOST>

     </taPopEnterMatchInvLine>

   </taPopEnterMatchInvLine_Items>

   <taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true" />

   <taPopEnterMatchInvHdr>

     <POPRCTNM>122</POPRCTNM>

     <VNDDOCNM>122</VNDDOCNM>

     <receiptdate>3/19/2013</receiptdate>

     <BACHNUMB>INVOICETESTEDI03/19/2013</BACHNUMB>

     <VENDORID>ACETRAVE0001</VENDORID>

     <SUBTOTAL>1521</SUBTOTAL>

   </taPopEnterMatchInvHdr>

   <taMdaUpdate_Items xsi:nil="true" />

 </POPEnterMatchInvoiceType>

</eConnect>

*This post is locked for comments

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamics GP 2013 create Enter/Match Invoice, pop up error message "4852 Stored Procedure= taPopEnterMatchInvLine Error Description = Shipment Line Item does not exist to match Invoice against"

    That I'm not completely sure as I'm more on the GP Systems side, then the GP Applications side who works more with the data, but speaking to one of them, it may be because the items are being rounded per line or something like that, but to be sure, you may want to open a support case with the Application side or even enter this as a new forum question so everyone can see it, as I'm sure you're not the only one seeing this issue.

    Thanks

  • sstyer65 Profile Picture
    sstyer65 95 on at
    RE: Dynamics GP 2013 create Enter/Match Invoice, pop up error message "4852 Stored Procedure= taPopEnterMatchInvLine Error Description = Shipment Line Item does not exist to match Invoice against"

    Quick Question... have you ever had issues with rounding / significance on invoices?

    we have some vendors that send us invoices. (thru edi)

    and, the totals don't match the individual lines summed up.   They give us discount percentages

    and, some of our discount prices would be for example 11.224   -   but, if you bought 3 of two of these, and multiplier with the significance

    it would come out to be 22.45 rounded.  

    It causes us some headaches... because it won't match on totals

    Crazy huh...

    I'm sure our system is set to 2 digits of significance

    but... I think there's not going to be any easy way around this

    I'll do some searching to see if others have had similar issues

  • sstyer65 Profile Picture
    sstyer65 95 on at
    RE: Dynamics GP 2013 create Enter/Match Invoice, pop up error message "4852 Stored Procedure= taPopEnterMatchInvLine Error Description = Shipment Line Item does not exist to match Invoice against"

    yeah... our CFO just said the very same thing, about 15 mins ago

    Thank you for confirming this!

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamics GP 2013 create Enter/Match Invoice, pop up error message "4852 Stored Procedure= taPopEnterMatchInvLine Error Description = Shipment Line Item does not exist to match Invoice against"

    In the taPopEnterMatchInvLine procedure for eConnect, error 4852 is generated from the following bit of code:

    if (not exists(select 1 from POP10500 (nolock)

    where PONUMBER = @I_vPONUMBER and POPRCTNM = @I_vPOPMtchShpRcpt and RCPTLNNM = @I_vShipRCPTLNNM and

    ITEMNMBR = @I_vITEMNMBR and VENDORID = @I_vVENDORID and POPTYPE in(1,3) and Status = 1))

    begin

    select @O_iErrorState = 4852  

    exec @iStatus = taUpdateString

    @O_iErrorState,

    @oErrString,

    @oErrString output,

    @O_oErrorState output

    end

    In our case history, we've seen this error almost always caused when there is no line number for the shipment and/or shipment receipt hasn't been posted yet so the status of the receipt in the POP10500 table was still set to '0', thus the receipt needed to be posed prior to integrating the invoice. So, based on this, make sure you're posting the shipment receipt in Dynamics GP prior to bringing in the transaction.

    Thank you

  • sstyer65 Profile Picture
    sstyer65 95 on at
    RE: Dynamics GP 2013 create Enter/Match Invoice, pop up error message "4852 Stored Procedure= taPopEnterMatchInvLine Error Description = Shipment Line Item does not exist to match Invoice against"

    did anyone come up with a solution to this?   I have the same issue

    it looks like the receipt is there / and fine

    not sure why it's being kicked out with an error.   Some of mine work... some don't

  • Tony Peng Profile Picture
    Tony Peng 10 on at
    RE: Dynamics GP 2013 create Enter/Match Invoice, pop up error message "4852 Stored Procedure= taPopEnterMatchInvLine Error Description = Shipment Line Item does not exist to match Invoice against"

    Also I tested to add the  Element  <ShipRCPTLNNM>16384</ShipRCPTLNNM> into the taPopEnterMatchInvLine XmlNode, e-connect pops up the same error message.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans