Analysis by Dimension Vs COA

Chika
Member Posts: 45
Dear All,
I tried to create a report using analysis by dimension and then I try to compare the amount of one account in my report for. e.g Sales Account and the amount of that account in the COA.
There are huge difference between them. Is there any idea why can I get these difference?
I think the value from my report and value in COA comes from the same table which is G/L entry.
Thanks for any advice.
Regards,
Chika
I tried to create a report using analysis by dimension and then I try to compare the amount of one account in my report for. e.g Sales Account and the amount of that account in the COA.
There are huge difference between them. Is there any idea why can I get these difference?
I think the value from my report and value in COA comes from the same table which is G/L entry.
Thanks for any advice.
Regards,
Chika
0
Comments
-
Look at the COA entries, many will not have dimensions. Otherwise your analysis report is not picking up all of the data in the COA you are looking at. Drill into the data and manually compare it and you will see quickly the issue.The art of teaching is clarity and the art of learning is to listen0
-
Hi,
Try to update the Analysis View.
Go to Analysis View, & click the update. And don't forget to click OK.
Hope it helps. Thanks0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions