DynDeveloper.com

DynDeveloper.com

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