Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Building SSRS reports

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Building SSRS reports

    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.

  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    Miguel Llorca Gómez 7,019 User Group Leader on at
    RE: Building SSRS reports

    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!

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,927 on at
    RE: Building SSRS reports

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans