Hey,<\/p>\n
I was creating a new report and applying some filters while testing it.<\/p>\n
After a while, after changing the dataitems structure, i got the following error:<\/p>\n
<\/p>\n
<\/p>\n
Microsoft Dynamics NAV
\n\u2014\u2014\u2014
\nFilter 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.
\n\u2014\u2014\u2014
\nOK
\n\u2014\u2014\u2014<\/p>\n
To resolve it, here’s what I did.<\/p>\n
1. Close Dynamics NAV<\/p>\n
2. Find the following file: C:\\Users\\<username>\\AppData\\Roaming\\Microsoft\\Microsoft Dynamics NAV\\PersonalizationStore.xml<\/p>\n
Dynamics NAV saves some personalization info in these file.<\/p>\n
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.<\/p>\n
4. Delete the lines found. In my case were:<\/p>\n
<\/p>\n
<\/p>\n
5. Save the file and open Dynamics NAV again. You can now run your report<\/p>\n
Note: This solution may be applied in similar errors in pages.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, 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 \u2014\u2014\u2014 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. \u2014\u2014\u2014 OK […]<\/p>\n","protected":false},"author":1,"featured_media":138,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[4],"tags":[6,12,10,7,9,11],"class_list":{"0":"post-115","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-dynamics365bc","8":"tag-dynamicsnav-2","9":"tag-error","10":"tag-microsoft","11":"tag-nav2013","12":"tag-nav2013r2","13":"tag-rtc","15":"post-with-thumbnail","16":"post-with-thumbnail-icon"},"yoast_head":"\n