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>