Share
Report
125Hello 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
All responses (
Answers (
