I would like to export a Sales ledger (at the detail level) as a flat CSV file. I am using NAV 2015. Any help on how to achieve this would be most appreciated.
Thanks,
Ben
*This post is locked for comments
I would like to export a Sales ledger (at the detail level) as a flat CSV file. I am using NAV 2015. Any help on how to achieve this would be most appreciated.
Thanks,
Ben
*This post is locked for comments
You have two easy methods to do this.
1.You can use RapidStart Services to export data : https://msdn.microsoft.com/en-us/library/hh179428(v=nav.70).aspx
Video : https://msdn.microsoft.com/en-us/dynamics/nav/dn848428.aspx
2. Or you can use XML ports to export data : https://msdn.microsoft.com/en-us/library/hh167691(v=nav.70).aspx
Walkthrough: Exporting Data from Tables to CSV Files
Hi Bleah,
If you need it frequently, you should have your software vendor make it. Otherwise, you can save the report as excel, copy data part to new excel file, then save it as csv format.
Hi, I really after a way just to export the standard report "Aged Accounts Receivable" to a flat CSV file , so that each item appears on it's row. e.g.
AA1, Customer Name, 12/03/2003, Invoice, 567.44.....
Hi Bleah,
You have 2 options for this:
1. Create a XML port with CSV format, please refer to this link.
2. Use my solution Universal Data Import Export, please refer to this link.
You can use RapidStart Services to export the data you need. Below is the link for more information
msdn.microsoft.com/.../hh179428(v=nav.70).aspx
Or you can create an xmlport and export the data you need
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156