How can I use the NL function to display the records in the "Object" table?
7 comments
-
Harry Lewis Hello -
I assume you are using Dynamics NAV.
If you are using NAV 2009R2 or earlier or are using NAV's Web Services connection to access NAV 2013 or newer, all virtual tables should be available to you.
If you are using the SQL Server Connector to NAV 2013 or newer, the "Date" and "Integer" virtual table are supported. Other virtual tables (which are "virtual" within NAV and not available directly in the SQL database) require that a Web Service connection be used.
-
Iborn Scott We are using NAV 2013.
Just using something simple like =NL("Rows","Object")
returns no results.
-
Harry Lewis when you look at you Data Source Settings, which type of NAV connection are you using... SQL Server or Web Services?
When you type your NL() function into a cell and then press the Enter key, what shows up in that cell?
e.g.,
-
-
-
Harry Lewis Thank you.
The SQL Server data source type retrieves information directly from NAV's SQL database (not from NAV itself).
Because virtual tables exist only within NAV (not in the SQL database), most of those table are not available through the Jet Excel add-in when using a SQL Server data source type. The only exceptions to this are the DATE and INTEGER virtual tables.
If I were needing to access a virtual table through the Jet Excel add-in, I would need to work with my system admin to establish a Web Services connection (instead of a SQL Server connection).
I hope that helps clarify.
-
Iborn Scott thank you.