Export flowfields to Excel connecting from SQL Server

Reedberg

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!

postsaurav

Hey Reedburg,

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

Reedberg

Sorry I didn't mention it before. I am using Navision attain 3.7 and NAV 5 as a client, so I can not use ODATA.