Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 310 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Analyses by Dimensions is wrong
ouredp
Member Posts: 56
Has anybody experienced some problems with "Analyses by Dimensions"?
The values in this inquiry are wrong . They don´t match with the values in our Chart of Account. This is now the second time within the last 6 months that this problem happens.
We are running batch update of our analyses (not at each transaction) and place all G/L bookings in Standard Journalsentries.
By building -up a new analyse , every thing is fine, so the data in the tables seems to be allright.
The values in this inquiry are wrong . They don´t match with the values in our Chart of Account. This is now the second time within the last 6 months that this problem happens.
We are running batch update of our analyses (not at each transaction) and place all G/L bookings in Standard Journalsentries.
By building -up a new analyse , every thing is fine, so the data in the tables seems to be allright.
0
Comments
Navision GUI guidelines do not permit an extra row showing blank values...
Suggested Solution :
You should create a totaling value in your dimension with totaling formula '' (single quote twice)
Then it should be possible to see the blank values in the Analysis by dimension form.
Louis
Zoltan
If you have a account no. let's say 35 which you use as a Begin-total account and you have a 3599 which you use as a End-total with Totaling 35..3599, showing this in "Analyses by Dimensions" will be wrong. The account no 3599 will be the sum of amounts of all accounts from the number 35 to 3599, which will include 1400, 3000 and so on because the field G/L account no. i Analysis View Entry is a code-field, and not a text-field. And this means Navision reads the totaling 35..3599 as the sum of account no. 35 + 36 + 37 + ... + 1400 + ... + 3010 and so on when showing this in "Analyses By dimensions".
Best Regards from Bente