web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SqlDateTime overflow. ...

Microsoft Dynamics GP (Archived)

SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

(0) Share

Report

Report

Posted on by Community Member

Hi Guys,

When i sync an Item ( ITEMNMBR is WAV605M - Outdoor Cap Flame Trucker)from Magento to GP ,it throws an error as like below

"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."

I thought,That Item Length is more than the item characters in GP table (IV00101).

Is this correct ?.

Please any one confirm this and any one can suggest on this if any other reason behind that ?.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

it's not because of the length of item number, but it is because of date fields for IV00101 table. what value you are entering for DEX_ROW_TS field?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Almas,

Thanks for responding to my question. Your answer has corrected me. Actually NULL is passing in that field which i want to pass the datetime. thastsy i got that error.

now i corrected my assumption.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Community Member 2

#2

#2

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans