Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K 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
- 272 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
List of G/L Entries for a specific dimension value?
livingdoll
Member Posts: 45
Hi!
Our customer wants an detail overview of all G/L Entries that have a specific dimension value (for a non-global dimension code). He wants to export this list to excel. Is there a way to achieve this with 'Analysis by Dimensions' or do I have to find another way?
Thx in advance,
Greys
Our customer wants an detail overview of all G/L Entries that have a specific dimension value (for a non-global dimension code). He wants to export this list to excel. Is there a way to achieve this with 'Analysis by Dimensions' or do I have to find another way?
Thx in advance,
Greys
0
Comments
Yes using through 'Analysis by Dimensions' it is possible.
1. Create new Analysis item in Analysis View Card. and select the other options in that card.
2. then i the Dimension tab you can select what ever the dimensions you have posted for that account.
then update.
After that you can select that Analysis item in the Analysis by dimensions and give the date filter. then it will list down all the entries.
you will have the option : in that same screen : Functions -> Export To Excel.
if you use this option it will work.