Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
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

  • Community Member Profile Picture
    Community Member on at
    RE: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

    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.

  • Verified answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,006 User Group Leader on at
    RE: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans