I encountered this problem only in one report (nav 4sp3 sql).
this report import a text file and put it into a table "control panel", which contains also "operation occured date" field.
after importing the file, the user launch a process wich read this table and create purchase invoices.
There are a lot of controls on this procedure, e.g. "operation occured date" must be <> 0D.
sometimes, it happens that the user finds all the "created-by-process" invoices with operation occured date blank, but, after deleting them, reimporting the file and recreating the invoices, the date is correctly filled.
Why?!?! (while writing, i realized that the problem is not about the file importation, because the "control panel" table always have the "operation occured date" and the user can't create the invoices without this field filled) ](*,) ](*,)
thanks in advance
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog0
Comments
2) Check which input values are used and which can be cleared incorrectly when starting the import.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
BTW, the file is imported correctly:
quoting myself
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
Another way how to find more is to enable change log to track possible user intervention. If you are using SQL, you can use SQL Profiler to try catch the query which change this value...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
and I couldn't manage to replicate the error on my db...(also my customer can't as it happens only some times)
BTW...i'll write if I'll find the solution
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog