Dear Experts,
Please guide me on how to export more than 5000 records to excel from RTC. Is this possible or Is this a limitation?
Ishwar
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.
Neil
Hi Ishwar
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.
Thanks
Blog - https://rockwithnav.wordpress.com/
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.
Hi,
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" />
to
<add key="MaxNoOfXMLRecordsToSend" value="1000000" />
This solves your problem in the RTC, but you have to do it on every client.
best regards
Robert
Thanks Neil, RockwithNAV, Jonathan and Robert for your replies. I tried Robert's suggestion and it works for me. Thank you everyone!
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
best regards,