You’re offline. This is a read only version of the page.
125
Hello Everyone,
I've been using Web Services for Dynamics GP for a month or so now, and have run into a problem that likely has a simple solution that I just can't seem to locate. I just installed GP and the Web Services on a server in a different time zone, and when i try to export just about anything with a date I get the following error (or something similar, always with dates):
The INSERT statement conflicted with the CHECK constraint "CK__RM00401__DOCDATE__08C03A61". The conflict occurred in database "GP2", table "dbo.RM00401", column 'DOCDATE'.
The statement has been terminated.
I have used the same code on different databases and this is the first i'm seeing this problem. With a bit of research I found that time zone had caused problems for others, so i changed the timezone on my machine to match that of the server and it will work with no problems.
So i'm wondering what i can do to resolve this issue without having to take steps like these, and hoping there is something quick and easy I can do that i just haven't been able to find.
Thanks!
*This post is locked for comments
I have the same question (0)
Hi Andrew - most like you are passing in a time component as well. If you take off the time and just pass in the date alone, it should work.
Thanks.
Share
Report
All responses (
Answers (
