Get Receipt Lines Function very slow

vijay4398
vijay4398 Member Posts: 35
edited 2009-11-04 in NAV/Navision Classic Client
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

Comments

  • ssingla
    ssingla Member Posts: 2,973
    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.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • kapamarou
    kapamarou Member Posts: 1,152
    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
    kriki Member, Moderator Posts: 9,129
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories