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
AsherB
4Penny.net
Points: 6950

2/17/2017 10:36:28 AM

Invalid Purchase Freight Taxable (Purchase_Freight_Taxable) status

Sql procedure error codes returned:
Error Number = 839  Stored Procedure= taPopRcptHdrInsert  Error Description = Invalid Purchase Misc Taxable (Purchase_Misc_Taxable) status (1=Taxable,2=Nontaxable,3=Base on Vendor
Node Identifier Parameters: taPopRcptHdrInsert
POPRCTNM = 26              
POPTYPE = 1
receiptdate = 2/3/2017
BACHNUMB = RCPT 0217     
VENDORID = 0000250       
Related Error Code Parameters for Node : taPopRcptHdrInsert
Purchase_Misc_Taxable = 0
Error Number = 840  Stored Procedure= taPopRcptHdrInsert  Error Description = Invalid Purchase Freight Taxable (Purchase_Freight_Taxable) status (1=Taxable,2=Nontaxable,3=Base on Vendor
Node Identifier Parameters: taPopRcptHdrInsert
POPRCTNM = 26              
POPTYPE = 1
receiptdate = 2/3/2017
BACHNUMB = RCPT 0217     
VENDORID = 0000250       
Related Error Code Parameters for Node : taPopRcptHdrInsert
Purchase_Freight_Taxable = 0
<taPopRcptHdrInsert>
  <POPRCTNM>26               </POPRCTNM>
  <POPTYPE>1</POPTYPE>
  <receiptdate>2/3/2017</receiptdate>
  <ACTLSHIP>2/3/2017</ACTLSHIP>
  <BACHNUMB>RCPT 0217      </BACHNUMB>
  <VENDORID>0000250        </VENDORID>
  <DISAVAMT>0</DISAVAMT>
  <Purchase_Freight_Taxable>0</Purchase_Freight_Taxable>
  <Purchase_Misc_Taxable>0</Purchase_Misc_Taxable>
  <CREATEDIST>0</CREATEDIST>
  <RATEEXPR>0</RATEEXPR>
  <DYSTINCR>0</DYSTINCR>
  <TRXDTDEF>0</TRXDTDEF>
  <RTCLCMTD>0</RTCLCMTD>
</taPopRcptHdrInsert>
<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>26               </POPRCTNM>
        <PONUMBER>PO001307         </PONUMBER>
        <ITEMNMBR>143345                        </ITEMNMBR>
        <VENDORID>0000250        </VENDORID>
        <UNITCOST>2.00000</UNITCOST>
        <QTYSHPPD>48096.00000</QTYSHPPD>
        <LOCNCODE>WAREHOUSE1</LOCNCODE>
        <AutoAssignBin>0</AutoAssignBin>
      </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>26               </POPRCTNM>
      <POPTYPE>1</POPTYPE>
      <receiptdate>2/3/2017</receiptdate>
      <ACTLSHIP>2/3/2017</ACTLSHIP>
      <BACHNUMB>RCPT 0217      </BACHNUMB>
      <VENDORID>0000250        </VENDORID>
      <DISAVAMT>0</DISAVAMT>
      <Purchase_Freight_Taxable>0</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>0</Purchase_Misc_Taxable>
      <CREATEDIST>0</CREATEDIST>
      <RATEEXPR>0</RATEEXPR>
      <DYSTINCR>0</DYSTINCR>
      <TRXDTDEF>0</TRXDTDEF>
      <RTCLCMTD>0</RTCLCMTD>
    </taPopRcptHdrInsert>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPReceivingsType>
</eConnect>
4Penny.net
Version: All
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
site