i want to build a report in excel, but want to know how do i export GL entries from NAV to excel allowed me to refresh to get the live data from NAV then my report will be exactly live data in NAV ?
I don't think I have understood your question, are you asking "how to export GL Entries in Excel format from NAV"?
Meaning that I can extract the data into excel and the data actual I can right click refresh in excel then I can get the live update from NAV whenever there is some new entries enter in NAV.
This feature is possible nowadays in Business Central SaaS version. Can you let me know what version of NAV you are using?
You can explore the below links:
www.encorebusiness.com/.../
www.cdata.com/.../
www.inecta.com/how-to-work-with-excel-and-microsoft-dynamics-nav-2016
Is it this one ?
If you are using BC On Prem you can directly link your DB using SQL query in Excel, using some sql query, it will refresh automatically live data in the excel file or Powerbi also has other option to integrate.
learn.microsoft.com/.../connect-excel
Thanks.
yeah. I remember my ex-company did something similar things, we used to import data from MS query to export all the GL entries instead of pay some money buy the add-in &etc. But before IT will do something in order we able to see "IFSPRD", however, i totally dont know where can i setup this.
You can also publish the G/L Entry page as a webservice and access that web service from Excel.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sumit Singh 2,179
OussamaSabbouh 1,999
YUN ZHU 1,892 Super User 2025 Season 2
