0

Virtual Tables

Iborn Scott

October 16, 2017 23:10

Answered

Follow

How can I use the NL function to display the records in the "Object" table?

• Facebook
• Twitter
• LinkedIn

7 comments

• 0
  
  Harry Lewis October 17, 2017 14:41

  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.

• 0
  
  Iborn Scott October 17, 2017 15:46

  We are using NAV 2013.

   

  Just using something simple like =NL("Rows","Object")

  returns no results.

• 0
  
  Harry Lewis October 17, 2017 17:48

  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.,

  

• 0
  
  Iborn Scott October 17, 2017 18:52

  

• 0
  
  Iborn Scott October 17, 2017 18:55

  

• 0
  
  Harry Lewis October 17, 2017 19:06

  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.

   

  Edited by Harry Lewis October 17, 2017 19:06
• 0
  
  Iborn Scott October 17, 2017 19:29

  thank you.