Exporting More Than 5000 - NAV 2009 RTC

(0) Share

Report

Posted on by edwardl

Hello,

My accountants need to export more than 5000 records to excel however every time they try to do this they receive an automatic error stating that this isn't possible and that it can affect performance.

Where can I go to change this setting as we aren't worried about performance when it comes to <10,000 records.

*This post is locked for comments

All responses (6)

Answers (2)

Suresh Kulla 44,614 on at

Like (0)

Report

RE: Exporting More Than 5000 - NAV 2009 RTC

On other note you might have to restart the services if you change CustomSettings.Config file changes to take affect.
Suresh Kulla 44,614 on at

Like (0)

Report

RE: Exporting More Than 5000 - NAV 2009 RTC

Yes, it should be on the server where you installed the NAV server

The path for the file is

C:\Program Files\Microsoft Dynamics NAV\60\service
edwardl 2 on at

Like (0)

Report

RE: Exporting More Than 5000 - NAV 2009 RTC

Where is this CustomSetting.config file everyone is talking about? Is it on the server?
Suggested answer

Suresh Kulla 44,614 on at

Like (0)

Report

RE: Exporting More Than 5000 - NAV 2009 RTC

Edward,

Have you tried the setting i posted above ?
Verified answer

edwardl 2 on at

Like (0)

Report

RE: Exporting More Than 5000 - NAV 2009 RTC

There is an easy way to do this in Classic Client.

Tools -> Options -> Max. no. of XML records to send

Changing this value fixed the issue in Classic but not in RTC.
Verified answer

Suresh Kulla 44,614 on at

Like (0)

Report

RE: Exporting More Than 5000 - NAV 2009 RTC

Edward

Check the below key in clientusersettings.config and also there is a limit in CustomSettings.config file about the size of the file MaxUploadSize change that too

<add key="MaxNoOfXMLRecordsToSend" />.