Building SSRS reports

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

blogs.msdn.com/.../567113.aspx

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

you could start here:

msdn.microsoft.com/.../hh168574(v=nav.70).aspx

www.youtube.com/watch

community.dynamics.com/.../107691

best you contact your nav partner for a customization.

Was this reply helpful? Yes No