Receiving this erro message inserting a sales order with Web Serivce:
“The INSERT statement conflicted with the CHECK constraint "CK__SOP10100__DOCDAT__56BECA79". The conflict occurred in database "XXXX", table "dbo.SOP10100", column 'DOCDATE'.
Date tag is <Date>2012-08-06T01:22:28</Date> Does anyone know how to resolve?
Thanks,
Donnette
*This post is locked for comments
Yes, GP simply does not accept tme with date as the product does not use time in the DocDate field, therefore this constraint was added, you either pass the date as 2012-08-06 without the time or just remove the constraint!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (