Microsoft Dynamics NAV (Archived)

Posted Sales Invoices - Display Error

(0) Share

Report

Posted on by Oakwinds

Hi, I recently uploaded some sales invoices. When attempting to view them under path:

Departments > Sales & Marketing > History > Posted Sales Invoices

I get the following error message:

“The date is not valid. Page Posted Sales Invoices must close.”

And I cannot view the invoices through the application.

What is the cause of this error? Which date is not valid?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Suggested answer

Ahmed Mohamed Rafik 3,049 User Group Leader on at

Like (0)

Report

In which version you are working on Microsoft Dynamics NAV?

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,999 Super User 2025 Season 2 on at

Like (0)

Report

what do you mean by upload? didn't you post them?

Was this reply helpful? Yes No
Oakwinds 40 on at

Like (0)

Report

Dynamics NAV 2015. And no they were not posted manually through the application; they were uploaded via SQL due to the number of transactions, so the issue is to which date is the application referring that is causing the error. Thanks.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,999 Super User 2025 Season 2 on at

Like (0)

Report

if you are a programmer then you need to check it by activating the debugger.

Was this reply helpful? Yes No
Oakwinds 40 on at

Like (0)

Report

I am not - can you instruct me on how to use the debugger for this particular error? Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Oakwinds,

"they were not posted manually through the application; they were uploaded via SQL due to the number of transactions"

I'm afraid you're doing it all wrong. You should create and post document through NAV Validation code/program. Otherwise, you'll only have some sh*** on your database

Was this reply helpful? Yes No
Oakwinds 40 on at

Like (0)

Report

These are transactional records, not master records. And a date seems to be the issue, but which date?

Please provide the debugger procedure for this particular type of error. Thanks.

Was this reply helpful? Yes No
Suggested answer

jcastro 2,245 on at

Like (0)

Report

Hello Oakwinds,

In order to use the debugger you need certain requirements to be met first, like being the administrator of the database and having full access both technical and functional to the application, which you may or may not :-) Please let us know if that's your case or you might need to get in touch with your IT department.

Also, what Nabil is saying is the most appropiate procedure to do the invoice posting. In a nutshell, in order to post an invoice you should do it using the posting routine provided by the application. Otherwise you will create inconsistent data, and can cause troublesome issues in the application. For instance, if the invoice that is giving you the problem had been posted using the proper routine, now you wouldn't have a missing date because the routine wouldn't have allowed it to post without that date.

Cheers!

Was this reply helpful? Yes No
Oakwinds 40 on at

Like (0)

Report

Thanks Jose - that is understood. But that standard approach is not possible when uploading a large number of transaction records. I have full access to all aspects of the application. So instructions in using the debugger for this error would be appreciated. Thanks.

Was this reply helpful? Yes No
Suggested answer

jcastro 2,245 on at

Like (0)

Report

Sure thing. Just trying to help.

For more info on debugging and how to use it, you can check this documentation: docs.microsoft.com/.../debugging

Best of luck!

Was this reply helpful? Yes No