Hi, on the A/R aging report, when a lot of records are being inserted into the temporary table, it takes up all of the CPU and memory on the service tier causing slowdown across the board.
Will remove the data in the temporary table address this? Or does one of the hotfixes address this?
This is for NAV 2013.
0
Comments
One mod is to check the customer balance using flowfields and bypass everyone with a zero balance. If accompany has a huge number of customers with a small % active at any one time, that can save a lot of time.
If the problem is caused by their customers having a huge number of transactions, then some code to filter out the transactions being processed could work too - for example only look at open entries - downside, the closing date is not updated for all entries, so without a posting mod, this will give you point in time only.
http://mibuso.com/blogs/davidmachanick/
Yes, the A/R report is the one I'm troubleshooting. However, for any other reports where Excel buffer is used as temporary table, any work arounds or hotfixes that will address the memory issue?
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book