How to fix date error on customer card.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Cannot open one customer card, all others are functioning properly as far as we can tell.

When I try to open the one customer card I receive the following message: The date is not valid. Page Edit - Customer Card must close.

*This post is locked for comments

All responses (5)

Answers (0)

ManishS 6,578 on at

Like (0)

Report

RE: How to fix date error on customer card.

is there any customization, some date calculation is happening when you try to open the page.
Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to fix date error on customer card.

This is regarding that you system has a different date format then the customer data has the date, in that case, please debug and analysis the problem
Suggested answer

RockwithNav 6,562 on at

Like (0)

Report

RE: How to fix date error on customer card.

Sis you triggered anything from SQL?
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: How to fix date error on customer card.

Activate debugger to check the issue in detail..
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to fix date error on customer card.

Hello,

Well, I suggest you use the debugger to get in which table the date causes the problem then use NAV Development Environment to open it (using Run button) and correct the date manually. you can correct the date using SQL server as well.

--PERHAPS you've changed your date format in Windows/NAV and you stored a date in this format for example dd-mm-yyyy (let's say it's 15-08-2018) then you changed the date format to mm-dd-yyyy which means mm=15 while there is no month 15 !

-------------

Please verify my answer if you find my answer helpful. Doing so you'll show other community members that there was found a solution and you credit my help.

-------------

Best Regards,