Please guide me on how to export more than 5000 records to excel from RTC. Is this possible or Is this a limitation?
I have found the same issue in Nav 2009 and Nav 2013 but are you saying you get the same issue on Nav 2016?
Our work around is Copy and Paste rather than Send To.
In reply to Neil Fraser:
Please increase the length from 5000 to what to want. Below is the Screenshot. Navigate to Tools - Option
Apart from this one more thing i want to say if you just want to export Data from NAV for any purpose then Use SQL to Export instead of NAV, Its much faster.
Blog - https://rockwithnav.wordpress.com/
In reply to RockWithNAV:
the solution of rockwithnav could work.
you also could create a xmlport to export the lines or use the universal excel import/export tool, http://dynamicsuser.net/media/p/474170.aspx.
best regards Jonathan Blog: http://moxie4nav.wordpress.com
In reply to archer, MVP:
The solution in the classic client will not work!
Go to the file:
"C:\Users\YourUser\AppData\Local\Microsoft\Microsoft Dynamics NAV\ClientUserSettings.config"
change the value of
<add key="MaxNoOfXMLRecordsToSend" value="5000" />
<add key="MaxNoOfXMLRecordsToSend" value="1000000" />
This solves your problem in the RTC, but you have to do it on every client.
Thanks Neil, RockwithNAV, Jonathan and Robert for your replies. I tried Robert's suggestion and it works for me. Thank you everyone!
In reply to Ishwar Sharma:
In reply to Amaytors:
Hello, you have to C:\Users\Current User\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\
In the next folder with the NAV version number you can find the ClientUserSettings.config