Get Receipt Lines Function very slow

vijay4398

Hi Experts,

I have a issue with the Get Receipt Lines function in NAV 2005 . Problem is that its very slow..I tried table optimization as well but after sometime it again gets to the same level..

Do you guys have any ideas how to improve this...

Thanks

Vijay

ssingla

If you are using sql then use client monitor to check which step is consuming more time and try to optimize. AFAIK Table optimization in SQL does not serve too much purpose.

kapamarou

vijay4398 wrote:

NAV 2005

Did you mean 2009?

As suggested use the client monitor. I suppose it is because of the filters used being applied, that are not supported by a key (i.e. Qty. Rcd. Not Invoiced <>0).

kriki

Maybe it is because there is a filter on the currency code of the lines and that is a flowfield that points to the header. If there are a lot of records, that can be slow.