-
Its not possible in NAV, but still there is a solution... Export your Analysis View to Excel - that will create an Excel Pivot Table. There you will have enormous possibilities to "slice & dice" your data - far more than in NAV, just to mention several levels of grouping by row/col, adding...
-
Hi there! I am trying to build a reporting Excel spreadsheet using VB and SQL. While trying to query info from a table using SQL script, I can see some field names such as GL Posting Code. Normally such fields are created using the underscore like GL_Posting_Code. In Navision the fields do not have the...
-
Its not possible in NAV, but still there is a solution... Export your Analysis View to Excel - that will create an Excel Pivot Table. There you will have enormous possibilities to "slice & dice" your data - far more than in NAV, just to mention several levels of grouping by row/col, adding...
-
Hi there! I am trying to build a reporting Excel spreadsheet using VB and SQL. While trying to query info from a table using SQL script, I can see some field names such as GL Posting Code. Normally such fields are created using the underscore like GL_Posting_Code. In Navision the fields do not have the...
-
I am new to Navision, been working with it less than three months, and need to start working with Excel 11.0 Automation Server. I've searched forums and support sites and have found some code, mostly for VB, but can't find any documentation. I have even looked in the VB Script of MS Excel, as...
-
Hi everyone, I work with Nav. 5. I am trying to import Vendor's data through Excel. First, I export blank file from Nav. 5 to Excel, than in Excel I fill it with data. When I try to import it back to Nav. 05 I see a message: /This message if for C/AL programmers: The call to member selectSingleNode...
-
Hi all! I want to use Excel mapping tool to import all data ( customer, item, vendor) from Excel into Nav5 BUT I do not see where that tool is now? Any help please?? I used to use that in Navision4 . Thanks
-
Hi All I have just written 16 style sheets for various areas of Navision. I now need to print multiple reports to Excel from the same form, and have discovered I cant! Has anyone solved this problem yet? Thanks Colin
-
Well it has moved. Now you find it under: Application Setup>Company Setup and is now called Data Migration.
-
NAV releases from 5 and up support importing entries form excel in stadard, using data migration.