Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
abragg 7/29/2012 11:40:57 PM

Errors trying to receive inventory to a PO

Edit 9/17/15 View the main article for this error here 

Hello,

I'm trying to receive inventory and I'm getting a slew of errors.  The PO exists, and I can receieve into if from the GP UI.  The information I'm passing to the XML comes directly from the PO tables, so I know it's correct.  The errors seem to indicate that it can't find the line and/or item number in the PO.  XML follows the error messages below.  Thanks in advance for any help!

- Art

 

Sql procedure error codes returned:

Error Number = 1276  Stored Procedure= taPopRcptLineInsert  Error Description = POP Setup does not allow the site to be changed in Receiving
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
PONUMBER = PO2084
LOCNCODE = Myers

Error Number = 1277  Stored Procedure= taPopRcptLineInsert  Error Description = Location code does not exist in inventory
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
LOCNCODE = Myers

Error Number = 2053  Stored Procedure= taPopRcptLineInsert  Error Description = Purchase Order Line Item does not exist
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
PONUMBER = PO2084

Error Number = 3799  Stored Procedure= taPopRcptLineInsert  Error Description = VENDORID does not match the Purchase Order
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
PONUMBER = PO2084
VENDORID = ACETRAVE0001

Error Number = 3808  Stored Procedure= taPopRcptLineInsert  Error Description = Invalid PO Line number. This line number does not exists on the corresponding PO
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
PONUMBER = PO2084
POLNENUM = 1

Error Number = 3809  Stored Procedure= taPopRcptLineInsert  Error Description = Invalid Item number. This Item number does not match Item number on the corresponding PO
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
ITEMNMBR = KPA100

Error Number = 4604  Stored Procedure= taPopRcptLineInsert  Error Description = Item number/location code does not exist in inventory
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
ITEMNMBR = KPA100
LOCNCODE = Myers

Error Number = 6662  Stored Procedure= taPopRcptLineInsert  Error Description = VENDORID does not match the Purchase Order
Node Identifier Parameters: taPopRcptLineInsert
POPRCTNM = RCT1208
RCPTLNNM = 1
PONUMBER = PO2084
POLNENUM = 1
Related Error Code Parameters for Node : taPopRcptLineInsert
VENDORID = ACETRAVE0001

Error Number = 7922  Stored Procedure= taPopRcptLineInsert  Error Description = Item Number/Vendor Item number does not match a line on the Purchase Order
Node Identifier Parameters: taPopRcptLineInsert
POPTYPE = 1
POPRCTNM = RCT1208
PONUMBER = PO2084
ITEMNMBR = KPA100
Related Error Code Parameters for Node : taPopRcptLineInsert
ITEMNMBR = KPA100
VNDITNUM = KPA100
VENDORID = ACETRAVE0001
PONUMBER = PO2084
POLNENUM = 1

<taPopRcptLineInsert>
  <POPTYPE>1</POPTYPE>
  <POPRCTNM>RCT1208</POPRCTNM>
  <PONUMBER>PO2084</PONUMBER>
  <ITEMNMBR>KPA100</ITEMNMBR>
  <VENDORID>ACETRAVE0001</VENDORID>
  <RCPTLNNM>1</RCPTLNNM>
  <VNDITNUM>KPA100</VNDITNUM>
  <QTYSHPPD>50</QTYSHPPD>
  <AUTOCOST>1</AUTOCOST>
  <LOCNCODE>Myers</LOCNCODE>
  <POLNENUM>1</POLNENUM>
</taPopRcptLineInsert>

Here's the XML:

 

<?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>RCT1208</POPRCTNM>
                <PONUMBER>PO2084</PONUMBER>
                <ITEMNMBR>KPA100</ITEMNMBR>
                <VENDORID>ACETRAVE0001</VENDORID>
                <RCPTLNNM>1</RCPTLNNM>
                <VNDITNUM>KPA100</VNDITNUM>
                <QTYSHPPD>50</QTYSHPPD>
                <AUTOCOST>1</AUTOCOST>
                <LOCNCODE>Myers</LOCNCODE>
                <POLNENUM>1</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>RCT1208</POPRCTNM>
            <POPTYPE>1</POPTYPE>
            <receiptdate>07/29/2012</receiptdate>
            <BACHNUMB>ARTSBATCH</BACHNUMB>
            <VENDORID>ACETRAVE0001</VENDORID>
        </taPopRcptHdrInsert>
        <taMdaUpdate_Items xsi:nil="true" />
    </POPReceivingsType>
</eConnect>

Version: GP 2010
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