I am writing a report using the GL function for a few specific accounts and filtering by dimension. We upgraded from NAV 2009 R2 to NAV 2013 R2 at the end of April. My report works great through 4/30/15 (when we upgraded). From May on, I am not getting any results using the analysis view filtering by dimension. I can see in NAV the dimensions are still there and I should be getting results in my report, but the only way I get any number is to remove all filtering based on dimensions. I'm sure this has to do with the change from 2009 to 2013, but what am I doing wrong? Attached is the function wizard I am using. As I mentioned before, I am getting the results I expect through the end of April, which is when we upgraded.
Thanks!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello,
It sounds to me like the Analysis Views may not be getting updated in NAV. If you run the Analysis by Dimensions report in NAV does this reflect correct totals? If not, you may need to speak with your NAV partner or go into the Analysis View card and either click the Update button to have NAV updated the Analysis Views which may not be set to update automatically. This can be done by clicking the "Enable Update on Posting" button which will keep the Analysis Views up to date but will incur more overhead. If the issue does seem to stem from the Analysis Views not being updated your NAV partner will be able to assist in determining the best way to get them updated for your organization. Let us know if you still have issues!
Please sign in to leave a comment.