Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Export flowfields to Excel connecting from SQL Server
Reedberg
Member Posts: 68
Hi, experts,
I need to export Item Ledger Entry table into Excel. I export data using "Connect from SQL" function in Excel. It works fine but it does not export the content of flowfields, namely there is no fields "Amount" and "Adjusted Cost" in the resulting Excel file.
I understand that "Amount" and "Adjust Cost" are actually views on SQL server and thus I can't simply export them. But may be there is a simple way to export the content of flowfields using "Connect from SQL" function anyway?
Thanks in advance!
I need to export Item Ledger Entry table into Excel. I export data using "Connect from SQL" function in Excel. It works fine but it does not export the content of flowfields, namely there is no fields "Amount" and "Adjusted Cost" in the resulting Excel file.
I understand that "Amount" and "Adjust Cost" are actually views on SQL server and thus I can't simply export them. But may be there is a simple way to export the content of flowfields using "Connect from SQL" function anyway?
Thanks in advance!
0
Comments
What i can understand from your query is you want to have table flowfield in excel without much effort.
If you are using NAV 2013 or Later you can use ODATA for same.
Below links should help -
http://saurav-nav.blogspot.in/2013/04/introduction-of-odata-services-in-nav.html
http://saurav-nav.blogspot.in/2013/04/consuming-output-of-odata-part-1.html
If you have any issues let me know
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page