Hi I would really appreciate if anyone has built any succesful SSRS reports for NAV from Financial management if they could share some of their queries with me. I am just looking to find out really what tables I should be looking at to extract GL entries, Customers data, client reports for WIP and invoicing etc. Please can someone share any information they have on this, perhaps with a couple of examples.
Thanks
*This post is locked for comments
you could start here:
msdn.microsoft.com/.../hh168574(v=nav.70).aspx
community.dynamics.com/.../107691
best you contact your nav partner for a customization.
You can also check the Jet Reports library for examples: http://jetexpress.jetreports.com/resource-center/reports-library.php
But, the most important thing is to analyze which information do you really need (are you using Jobs, Production, ...??). I think that you won't find anything that fits to you... because every business has its singularities.
Good luck!
There is a report pack available for download for very old version of NAV 4.0 in the below link, this should give you some insight about the tables and structure.
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156