5
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 ?
You can also publish the G/L Entry page as a webservice and access that web service from Excel.
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.
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.
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.inecta.com/how-to-work-with-excel-and-microsoft-dynamics-nav-2016
I don't think I have understood your question, are you asking "how to export GL Entries in Excel format from NAV"?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (