We have an Analysis View for one of our dimensions. The Analysis View is set up for Date Compression = Day and we have a job queue entry that updates the Analysis VIew every hour. We have found a variane between the G/L and the Analysis View. We traced one of these variances back to a specific G/L on a specific Day.
I then was able to trace the variance back to a specific document (in this case a Production Order). I now see that the Analysis View doubled its entry. The G/L has -1,245.17 for that specific production order but the Analysis View is for -2,490.34. I went back to the production order and found that all the G/L entries for that Production Order had doubled in the related Analysis Entries.
Has anyone ever seen this before (we are on NAV 2018)?
I have a few ideas on how to fix but not pretty so I am open to suggestions.