web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / eConnect Integration f...
Finance | Project Operations, Human Resources, ...
Suggested Answer

eConnect Integration for Purchase Orders - Insert error conflicted with CHECK Constraint CK_POP10100_CREATD Column CREATDDT

(0) ShareShare
ReportReport
Posted on by lisasorensen15 10

I have a client that is importing Purchase Orders from an outside system using eConnect. While running the integration, the following error is generated: 

The INSERT statement conflicted with the CHECK constraint "CK__POP10100__CREATD__5540965B". The conflict occurred in database "COMPANY", table "dbo.POP10100", column 'CREATDDT'.

I found the following post related to the DOCDATE field, but don't see anything related to the Created Date field: https://community.dynamics.com/gp/b/dynamicsgpthoughts/posts/the-insert-statement-conflicted-with-the-check-constraint 

I know the Created Date is a system generated date of the first save of the Purchase Order in the header table. 

We are not passing a value for the CREATDDT field so we are not certain why we are receiving the error. Does it make sense to set a value for the field? Or is it another date field that is triggering this error? 

Any insight on how to get around the error would be helpful. 

Thank you. 

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at

    Below are some items to check.

    1) Do you have a pre or post Econnect proc that is setting\ altering the CREATDDT field?

    2) If you look at the table design for POP10100, is the default binding for CREATDDT set to dbo.GPS_DATE? I'm guessing if it's not you would have this issue entering PO's in general as well.

    3) Are there any triggers on the POP10100 which could be affecting the process?

    4) If you check the DOCDATE field in your XML file, does it have a time listed after the date?

    I checked and it looks like econnect uses the same date value as DOCDATE for CREATDDT

    What's happening is that the check constraint on this column prevents you have having a time in the datetime column as an example in Fabricam if you ran the below statement you would get the same error because we are setting the hour value. Somewhere in the process the created date value is being added\ updated with the time portion of the datetime stamp being set.

    update POP10100 set CREATDDT='2013-07-21 03:00:00.000' where DEX_ROW_ID=1

  • lisasorensen15 Profile Picture
    lisasorensen15 10 on at

    Hi Josh, 

    Thanks for the response. I don't have a Pre/Post proc that is setting or altering the CREATDDT field.

    As a precaution, I did confirm that the default binding for the CREATDDT field is set to dbo.GPS_DATE but there shouldn't be any modifications as the client doesn't have any 3rd party software installed and have not been using the POP module. I did confirm that there is only the standard trigger on the POP10100 table so nothing unusual there. 

    I forwarded your responses to the developers to have them confirm the date value format for the DOCDATE and all Date fields they are attempting to import. I haven't received a reply regarding the progress. If we still have issues, I will follow-up but I appreciate the feedback. All good suggestions! 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans