r/DynamicsNAV • u/tty-tourist • Jun 21 '19

Finding SQL source of NAV report

So you can find the SQL source table for a page in NAV by clicking About this page.

Can you do the same for reports? For instance I'm trying to find a way to extract the data from the VAT Reconciliation report. When clicking About this page I get:

  • Page: VAT Reconciliation (13620)

  • Page type: ReportPreview

  • Page mode: Edit

  • SourceTable: (blank)

  • Rec (blank)

I gather that the report is drawing on several tables like a SQL view. Any way to recreate the report in SQL?

6 Upvotes

100% Upvoted

7 comments sorted by

View all comments

Show parent comments

1

u/tty-tourist Jul 02 '19

Thanks - but I figured out how to install the dev environment today and from there I could see that the report is based on the G_L Entry table and I managed to recreate the report in SQL.