Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Date is not valid error

Posted on by 225

When we go to order planning or the planning worksheet we are getting an error "Date is not valid" when we try and calculate a plan. Any idea on what could have caused this or more important of how to fix it?

*This post is locked for comments

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Date is not valid error

    You may check what is ProdEndingDate from the above screen print and check whether the Calendar Entries are existing for that date.

  • Kyle Simpson Profile Picture
    Kyle Simpson 225 on at
    RE: Date is not valid error

    I went through the walkthrough and the calculations seem to be working fine. do you know of anything particular to look for?

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Date is not valid error

    Hi,

    Could you check the Calendar entries again?

    Please check the below link:

    www.archerpoint.com/.../understanding-concurrent-capacities-dynamics-nav-routing-lines

    Best Regards,

    MMV

  • Kyle Simpson Profile Picture
    Kyle Simpson 225 on at
    RE: Date is not valid error

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Date is not valid error

    Kyle,

    Please run the debugger and place the screenshot of it

  • Kyle Simpson Profile Picture
    Kyle Simpson 225 on at
    RE: Date is not valid error

    Any idea of what to look for in that table? This is a migration from an older version but the issue didnt occur until about 6 months after the migration to 2013.

  • Kyle Simpson Profile Picture
    Kyle Simpson 225 on at
    RE: Date is not valid error

    I searched for the calendar and they all seem to be correct. Am I missing something?

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Date is not valid error

    Could you check whether the calendar is setup correctly?

  • Suggested answer
    Miguel Llorca Profile Picture
    Miguel Llorca User Group Leader on at
    RE: Date is not valid error

    Some times I found an incorrect entry in "Item Ledger Entry" table. You started from NAV 2013 or that's a migration from a previous version?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans