I was creating a new report and applying some filters while testing it.
After a while, after changing the dataitems structure, i got the following error:
Microsoft Dynamics NAV
Filter could not be applied. Could not apply filter “01/01/10..03/06/14” to column no. “20” because the field is missing or unavailable.
To resolve it, here’s what I did.
1. Close Dynamics NAV
2. Find the following file: C:\Users\<username>\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\PersonalizationStore.xml
Dynamics NAV saves some personalization info in these file.
3. You could simply delete this file but you may lose some another filters and personalizations. I didn’t wanted that! So i’ve searched for “70035”, my report ID.
4. Delete the lines found. In my case were:
5. Save the file and open Dynamics NAV again. You can now run your report
Note: This solution may be applied in similar errors in pages.