NAV 2015 Posted Sales Invoice Loading Delay

JMSRSP

Hi,

Recently we have upgraded NAV from 2009 to 2015. After upgrade posted sales invoice page is taking too much time to load the data. All the posted document pages are slow after upgrade, In this posted sales invoice is very slow, it takes nearly 15-20 seconds to bring the data on the screen. Posted tables have entries from the year 2000. so we have manually archived the data till 2010, we dint find any improvement.

Could you please help us to locate the exact issue.

Thanks
Rajasekar

archer89

for a detailed analysis run sql profiler parallel when opening the posted sales invoice page.

Check if there are additional flow fields in the page, which are not optimized.
also check all auto-calculated fields, used on the page and the flow fields in the FactBoxes of the page. for testing remove all factboxes, then add them one by one.