Webservice DocDate Constrant Error GP2010R2

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No