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
- 300 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 35 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
REPORTING WITH NAVISION
BAX
Member Posts: 2
DOES ANYBODY KNOW OF A GOOD APPLICATION OR ANY DEVELOPMENT FOR CREATING REPORTS OR ADVANCED ANALYSIS FROM NAVISION.
I AM CURRENTLY USING THE ODBC DRIVER TO CREATE EXCEL QUERY REPORTS BUT THIS IS A SLOW PROCESS AND THE ODBC DRIVER SEEMS VERY UNSTABLE.
I HAVE HEARD VARIOUS OPTIONS ARE AVAILABLE BUT WONDERED IF ANY OF YOU KNEW OF OTHERS OR HAD EXPERIENCE OF SUCH THINGS AS EUREKA FROM COMPUTER ASSOCIATES, STATSEXPLORER FROM GESWAY.
I HAVE ALSO HEARD THAT NAVISION ARE BRINGING OUT THEIR OWN ANALYSIS TOOL AT THE END OF THIS MONTH, DOES ANYONE HAVE FURTHER DETAILS?
I AM CURRENTLY USING THE ODBC DRIVER TO CREATE EXCEL QUERY REPORTS BUT THIS IS A SLOW PROCESS AND THE ODBC DRIVER SEEMS VERY UNSTABLE.
I HAVE HEARD VARIOUS OPTIONS ARE AVAILABLE BUT WONDERED IF ANY OF YOU KNEW OF OTHERS OR HAD EXPERIENCE OF SUCH THINGS AS EUREKA FROM COMPUTER ASSOCIATES, STATSEXPLORER FROM GESWAY.
I HAVE ALSO HEARD THAT NAVISION ARE BRINGING OUT THEIR OWN ANALYSIS TOOL AT THE END OF THIS MONTH, DOES ANYONE HAVE FURTHER DETAILS?
0
Comments
If a printout is not enough I recommend creating an excel worksheet from within Navision using automation.
The third option is Crystal reports 8.0
Marcus
Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72
Marcus Fabian
And, as Marcus mentioned, Navision has its own report writer. However, to customize these reports, an end user would have to get a report writing license. This costs money, and you would have to train your key personnel to use the report writer. You would also have to choose your solution center carefully, because you can't call up Atlanta (or Toronto, or wherever) for tech support: you must call up your NSC.
If you don't want to get the report writer, you can have your NSC write reports for you and/or you can learn to use the Account Schedule area of Navision (which I believe is one of the granules every site has to purchase.) This is basically a set of two tables: one for the rows (with G/L Accounts or ranges of G/L Accounts), one for the columns (usually a time period such as Year-To-Date, Previous Year, etc.)
Tim Horrigan, NCSD
<Horrigan@AOL.com>
Currently in search of new employment!
Certified as a Solution Developer and an HR/Payroll Specialist!
<Horrigan@AOL.com>
Currently in search of new employment!
Certified as a Solution Developer and an HR/Payroll Specialist!
StatsExplorer is a generator of statistics completely integrated with Navision Financials, enabling statistics to be set up, viewed, printed and sent to Excel.
10 levels of sorting for all or some of the codes among the 70 available values : customers, salespeople, groups ...
250 customizable columns : periods, calculations, filters, %, etc,
Till 100 types of flows : sales, purchases, jobs entries, inventory entries, orders, jobs ...
StatsExplorer is developed in multi-language, and available in French, English an Spanish ... and more languages soon ...