Hello Friends,
Dynamics NAV default setting doesn't allow user to export more than 5000 rows to excel in NAV 2013 and newer version.
If user want to export more than 5000 rows to excel than we need to update following parameter in user custom setting files.
Update the value in following parameter.
You can find the user configuration file at following location:
Dynamics NAV default setting doesn't allow user to export more than 5000 rows to excel in NAV 2013 and newer version.
If user want to export more than 5000 rows to excel than we need to update following parameter in user custom setting files.
update the tag value: <add
key=”MaxNoOfXMLRecordsToSend” value=”100000″/> in user configuration
file.
File is located in respected version folder:
Update the value in following parameter.
You can find the user configuration file at following location:
Windows Server 2003 or Windows XP: (Documents and
Settings\<username>\Local Settings\Application Data\Microsoft\Microsoft
Dynamics NAV\ClientUserSetting.config)
Windows 7, Windows Vista, or Windows Server
2008 : (C:\Users\<username>\AppData\Local\Microsoft\Microsoft
Dynamics NAV\ClientUserSetting.config)
Hello! :) It's exactly the information I needed, thank you so much for clear explanation of how to export more than 5000 records to excel in Microsoft Dynamics NAV solution.
ReplyDeletesorry but i need to ask again if it also supposed to work for Nav 2016 0.8? because i am not able to find thefile clientUsersetting.config ???
ReplyDeleteYour music is amazing. You have some very talented artists. I wish you the best of success.
ReplyDeleteexcel courses
Thank you for sharing this topics.
ReplyDeleteI like your post.
จีคลับ
goldenslot mobile