Skip to main content

Excel Integration With NAV 2013 - Part I

Hi all,

Today i will be explaining you the Send to Excel Feature in NAV 2013.

After installing NAV 2013, you might have found 2 Things



1. New Tab in Excel Called Microsoft Dynamics NAV as Shown Below.



2. Send To Option in List Pages as shown below.



If you don't find a New Tab in Excel, Please follow steps in this ARTICLE.

Now let's Export Sales Order List into Excel. (You can apply filters as per your requirement).

I am applying filter of Status Released.

After applying filter i clicked on send to excel and i got all record in Excel as shown below.


Points -
1) You will find Refresh Button Active Now in dynamics NAV Tab.
2) Line 1 have address of My Service.
3) Line 2 Have Details of Last Refresh (Update every time we click refresh).



Let's see its uses for Non NAV Users in a Organization in Next Post.

Regards,
Saurav Dhyani
Labels:

Comments

Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------
10 comments
Read Complete Article »

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.
Post a Comment
Read Complete Article »

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------
5 comments
Read Complete Article »