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
mfronczak 11/26/2010 11:57:59 AM

Receipts Posting

I am having some difficulty getting the a Receipt posted to GP Dynamics 9.0 using eConnect.  I receive the following message:

 The INSERT statement conflicted with the CHECK constraint "CK__POP10300__GLPOST__77FFC2B3". The conflict occurred in database "TWO", table "dbo.POP10300", column 'GLPOSTDT'.
The statement has been terminated.

 I can not find any reference to the GLPOSTDT in any of the POP Receivings Schema....

 Below is the XML file used. 

************************************  XML FILE **********************************************

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <POPReceivingsType>
        <taUpdateCreateVendorRcd>
  </taUpdateCreateVendorRcd>
  <taCreateVendorAddress>
        </taCreateVendorAddress>
  <taPopRcptLineInsert_Items>
         <taPopRcptLineInsert>
    <POPTYPE> 1</POPTYPE><!-- (REQUIRED) i4 Receipt type:-->
    <!--  1=Shipment;-->
    <!--  3=Shipment/invoice-->
    <POPRCTNM>IND202</POPRCTNM><!-- (REQUIRED) string(17) Receipt number-->
    <PONUMBER>PO2077</PONUMBER><!-- string(17) Purchase order number; required if receiving against a purchase order-->
    <ITEMNMBR>ACCS-CRD-12WH </ITEMNMBR><!-- (REQUIRED) string(30) Item number-->
    <ITEMDESC>Phone Cord - 12' White</ITEMDESC><!-- string(100) Item description for non-inventory-->
    <VENDORID>ACETRAVE0001</VENDORID><!-- (REQUIRED) string(15) Vendor ID-->
    <RCPTLNNM> </RCPTLNNM><!-- i4 Receipt line number-->
    <VNDITNUM>ACCS-CRD-12WH </VNDITNUM><!-- (REQUIRED) string(30) Vendor item number-->
    <VNDITDSC> </VNDITDSC><!-- string(100) Vendor item description-->
    <ACTLSHIP></ACTLSHIP><!-- datetime Actual ship date-->
    <INVINDX> </INVINDX><!-- i4 Inventory index-->
    <InventoryAccount> </InventoryAccount><!-- string(75) Inventory account-->
    <UOFM>Each</UOFM><!-- string(8) Unit of measure-->
    <UNITCOST> </UNITCOST><!-- number Unit cost; set to zero, or leave "null" if using AUTOCOST=1-->
    <EXTDCOST> </EXTDCOST><!-- number  Extended cost-->
    <NONINVEN> </NONINVEN><!-- i4 Non-inventory-->
    <JOBNUMBR> </JOBNUMBR><!-- string(17) Job number-->
    <BOLPRONUMBER> </BOLPRONUMBER><!-- string(30) BOL/pro number-->
    <QTYSHPPD>2</QTYSHPPD><!-- (REQUIRED) number Quantity shipped-->
    <QTYINVCD> </QTYINVCD><!-- number Quantity invoiced (required if POPTYPE=3)-->
    <AUTOCOST>1</AUTOCOST><!-- i4 Parameter to autofill cost based on the PO:-->
    <!--  0=Manual;-->
    <!--  1=Automatic-->
    <Purchase_IV_Item_Taxable> </Purchase_IV_Item_Taxable><!-- i4 Purchase inventory item taxable:-->
    <!--  1=Taxable;-->
    <!--  2=Nontaxable;-->
    <!--  3=Based on vendor-->
    <Purchase_Item_Tax_Schedu> </Purchase_Item_Tax_Schedu><!-- string(15) Purchase item tax schedule (blank unless Purchase_IV_Item_Taxable=1)-->
    <Purchase_Site_Tax_Schedu> </Purchase_Site_Tax_Schedu><!-- string(15) Purchase site tax schedule-->
    <TAXAMNT> </TAXAMNT><!-- number Tax amount-->
    <Landed_Cost_Group_ID> </Landed_Cost_Group_ID><!-- string(15) Landed cost group ID-->
    <LOCNCODE> </LOCNCODE><!-- string(10) Location code in receiving-->
    <POLNENUM> </POLNENUM><!-- i4 PO line number; must be unique per PO line-->
    <receiptdate>2009-05-04T00:00:00-05:00</receiptdate><!-- datetime Receipt date; required if using landed cost-->
    <CURNCYID> </CURNCYID><!-- string(15) Currency ID; information pulled from purchase order unless not doing a receiving against a purchase order-->
    <ProjNum> </ProjNum><!-- string(15) Project number; for use with Project Accounting only-->
    <CostCatID> </CostCatID><!-- string(15) Cost category ID: for use with Project Accounting only-->
    <AutoAssignBin> </AutoAssignBin><!-- i4 Use Default Bin; will use the PORECEIPTBIN bin from the item site combination or the site default-->
    <RequesterTrx> </RequesterTrx><!-- i4 Requester transaction:-->
    <!--  0=False;-->
    <!--  1=True (if True, it populates the requester shadow table)-->
    <USRDEFND1> </USRDEFND1><!-- string(50) User-defined field?developer use only-->
    <USRDEFND2> </USRDEFND2><!-- string(50) User-defined field?developer use only-->
    <USRDEFND3> </USRDEFND3><!-- string(50) User-defined field?developer use only-->
    <USRDEFND4> </USRDEFND4><!-- string(8000) User-defined field?developer use only-->
    <USRDEFND5> </USRDEFND5><!-- string(8000) User-defined field?developer use only-->
         </taPopRcptLineInsert>
  </taPopRcptLineInsert_Items>
        <taPopRcptHdrInsert>
   <POPRCTNM>IND202</POPRCTNM><!-- (REQUIRED) string(17) Receipt number-->
   <POPTYPE>1</POPTYPE><!-- (REQUIRED) i4 Receipt type:-->
   <!--  1=Shipment-->
   <!--  3=Shipment/invoice-->
   <VNDDOCNM> </VNDDOCNM><!-- string(20) Vendor document number-->
   <!--  Required when POPTYPE=3-->
   <receiptdate>2009-05-04T00:00:00-05:00</receiptdate><!-- (REQUIRED) datetime Receipt date-->
   <ACTLSHIP> </ACTLSHIP><!-- datetime Actual ship date-->
   <BACHNUMB>RECEIVING ENTRY</BACHNUMB><!-- (REQUIRED) string(15) Batch number-->
   <VENDORID>ACETRAVE0001</VENDORID><!-- (REQUIRED) string(15) Vendor ID-->
   <VENDNAME> </VENDNAME><!-- string(64) Vendor name-->
   <SUBTOTAL> </SUBTOTAL><!-- number Subtotal?set to 0 if using AUTOCOST option-->
   <TRDISAMT> </TRDISAMT><!-- number Trade discount amount-->
   <FRTAMNT> </FRTAMNT><!-- number Freight amount-->
   <MISCAMNT> </MISCAMNT><!-- number Miscellaneous amount-->
   <TAXAMNT> </TAXAMNT><!-- number Tax amount-->
   <TEN99AMNT> </TEN99AMNT><!-- number 1099 amount-->
   <PYMTRMID> </PYMTRMID><!-- string(20) Payment terms ID-->
   <DSCPCTAM> </DSCPCTAM><!-- number Discount percent amount-->
   <DSCDLRAM> </DSCDLRAM><!-- number Discount dollar amount-->
   <DISAVAMT> </DISAVAMT><!-- number Discount available amount-->
   <REFRENCE> </REFRENCE><!-- string(30) Reference-->
   <USER2ENT> </USER2ENT><!-- string(15) User who entered-->
   <VCHRNMBR> </VCHRNMBR><!-- string(20) Voucher number-->
   <Tax_Date> </Tax_Date><!-- datetime Tax date-->
   <TIME1> </TIME1><!-- datetime Time 1-->
   <WITHHAMT> </WITHHAMT><!-- number Withholding amount-->
   <TXRGNNUM> </TXRGNNUM><!-- string(25) Tax registration number-->
   <AUTOCOST> </AUTOCOST><!-- i4 Parameter to autofill cost based on PO:-->
   <!--  0=Enter manually;-->
   <!--  1=Automatic-->
   <TAXSCHID> </TAXSCHID><!-- string(15) Tax schedule ID-->
   <Purchase_Freight_Taxable> </Purchase_Freight_Taxable><!-- i4 Purchase freight taxable-->
   <Purchase_Misc_Taxable> </Purchase_Misc_Taxable><!-- i4 Purchase miscellaneous taxable-->
   <FRTSCHID> </FRTSCHID><!-- string(15) Freight tax schedule ID-->
   <MSCSCHID> </MSCSCHID><!-- string(15) Miscellaneous tax schedule ID-->
   <FRTTXAMT> </FRTTXAMT><!-- number Freight tax amount-->
   <MSCTXAMT> </MSCTXAMT><!-- number Miscellaneous tax amount-->
   <BCKTXAMT> </BCKTXAMT><!-- number Back tax amount-->
   <BackoutTradeDiscTax> </BackoutTradeDiscTax><!-- number Back out trade discount tax amount-->
   <SHIPMTHD> </SHIPMTHD><!-- string(15) Shipping method-->
   <USINGHEADERLEVELTAXES> </USINGHEADERLEVELTAXES><!-- i4 Using header level taxes-->
   <CREATEDIST> </CREATEDIST><!-- i4 Flag to autocreate distributions:-->
   <!--  0=Manual (need to call <taPopDistributions>);-->
   <!--  1=Automatic-->
   <CURNCYID> </CURNCYID><!-- string(15) Currency ID-->
   <XCHGRATE> </XCHGRATE><!-- number Exchange rate-->
   <RATETPID> </RATETPID><!-- string(15) Rate type ID-->
   <EXPNDATE> </EXPNDATE><!-- datetime Expiration date-->
   <EXCHDATE> </EXCHDATE><!-- datetime Exchange date-->
   <EXGTBDSC> </EXGTBDSC><!-- string(30) Exchange ID description-->
   <EXTBLSRC> </EXTBLSRC><!-- string(50) Exchange rate source-->
   <RATEEXPR> </RATEEXPR><!-- i4 Rate expiration:-->
   <!--  0=None-->
   <!--  1=Daily;-->
   <!--  2=Weekly;-->
   <!--  3=Biweekly;-->
   <!--  4=Semimonthly;-->
   <!--  5=Monthly;-->
   <!--  6=Quarterly;-->
   <!--  7=Annually;-->
   <!--  8=Miscellaneous;-->
   <!--  9=None;-->
   <DYSTINCR> </DYSTINCR><!-- i4 Days to Increment?used only when RATEEXPR=8-->
   <RATEVARC> </RATEVARC><!-- number Rate variance-->
   <TRXDTDEF> </TRXDTDEF><!-- i4 Transaction date default:-->
   <!--  0=Exact date;-->
   <!--  1=Next date;-->
   <!--  2=Previous date-->
   <RTCLCMTD> </RTCLCMTD><!-- i4 Rate calculation method:-->
   <!--  0=Multiply;-->
   <!--  1=Divide-->
   <PRVDSLMT> </PRVDSLMT><!-- i4 Previous day's limits-->
   <DATELMTS> </DATELMTS><!-- i4 Date limits:-->
   <!--  0=Unlimited;-->
   <!--  1=Limited-->
   <DUEDATE>2007-04-21 00:00:00.000</DUEDATE><!-- datetime Due date-->
   <DISCDATE> </DISCDATE><!-- datetime Discount date-->
   <NOTETEXT> </NOTETEXT><!-- string(8000) PO receipt note text-->
   <VADCDTRO> </VADCDTRO><!-- string(15) Remit to address ID-->
   <RequesterTrx> </RequesterTrx><!-- i4 Requester transaction:-->
   <!--  0=False;-->
   <!--  1=True (if True, populates requester shadow table)-->
   <USRDEFND1> </USRDEFND1><!-- string(50) User-defined field?developer use only-->
   <USRDEFND2> </USRDEFND2><!-- string(50) User-defined field?developer use only-->
   <USRDEFND3> </USRDEFND3><!-- string(50) User-defined field?developer use only-->
   <USRDEFND4> </USRDEFND4><!-- string(8000) User-defined field?developer use only-->
   <USRDEFND5> </USRDEFND5><!-- string(8000) User-defined field?developer use only-->
        </taPopRcptHdrInsert>
    </POPReceivingsType>
</eConnect>

 

Version: Unknown or N/A
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