form 355 is just wacked out

TrintTrint Member Posts: 44
edited 2006-09-25 in Navision Attain
when i go to:
G/L
Chart of Accounts
Account button at bottom
select Receivables-Payables
it displays one line every second...this is crazy.
what is wrong and how can i fix it...i've already imported the 'cronus' version of that form and this 2.5 gig database still all but dies.
thanks for help in advance,
Trint

Comments

  • eromeineromein Member Posts: 589
    It's probably either a wrong key or to much flowfields.

    1.) Check if the key is the primaire key, if not select this key and see if it's still slow. If it's faster, pick another key or find a solution for your wongly sorted form.

    2.) Hide all flowfields in this form and check if the form is faster. If it is, check if all the tables that are being flowed have the right keys. If not, make'm. But be carefull, ask a proffesinol to make sure you don't add bad keys!

    If it isn't one of these thing, then it could be some bad programming in the form. But if you imported the cronus form, this could not be a problem.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • FranVLCFranVLC Member Posts: 22
    Hi!

    I just landed to this old post because i have the same problem, except i'm using NAV 4.0.

    I got the same performance problem with a local database, so it seems it is not a problem of services in the server.
    I tried to increase the database size, but the problem remains.
    The form 355 is standard, so it's not modified. :-s

    Anyone has an idea?? :-k

    This problem is the same as seen on:
    http://www.mibuso.com/forum/viewtopic.php?t=1834&highlight=receivablespayables

    Thanks a lot!
    Thank you very much to all users who actively participate in this forum!
  • Francis_MalengierFrancis_Malengier Member Posts: 28
    Hi,

    did you try to increase your object cache ? The information is displayed in a matrix form, and matrix forms use object cache. Increasing it might increase the speed of the form.


    Francis
  • Francis_MalengierFrancis_Malengier Member Posts: 28
    Sorry, forgot to mention how to change it :

    It is in Tools-->options

    the value is stored in your zup file, so it is an individual parameter for each user.

    Francis
  • FranVLCFranVLC Member Posts: 22
    Hi, Francis.

    I've just tried to increase object cache to 120000 KB, but it doesn't seems to work.

    On open form 355 Navision shows a little form with this info:
    Searching the Detailed Cust. Ledg. Entry table
    Counter.... 26016
    Table...... Detailed Cust. Ledg. Entry 
    Key........ Excluded from calculation,Customer No.,
    

    Tables 98 and 379, and form 355 seems OK (I mean, equal to standard), so I'm lost... :|

    Thanks!
    Thank you very much to all users who actively participate in this forum!
  • SavatageSavatage Member Posts: 7,142
    I checked it out on mine - and I receieved the counter box for a few seconds then the Lines appeared.

    Then I closed it and went back into the form 355 and it opened very quickly the second time.

    Personally, Looking at these numbers I can't see them being very useful..at least for us.

    It seems to total all Cust Balances Due & Vendor Balances Due by date for every date you're ever had Navision. Thats alot of calcs.

    PS My Caches are set at 8000 and it's pretty fast. Have you tried to recompile the form to remove any possible filters?
  • FranVLCFranVLC Member Posts: 22
    Hi, Savatage.

    I'll try to recompile the form and post again my results.

    Thank you very much for your attention.
    Thank you very much to all users who actively participate in this forum!
  • FranVLCFranVLC Member Posts: 22
    Unfortunately, recompiling the form doesn't improve performance ](*,) .
    Thank you very much to all users who actively participate in this forum!
Sign In or Register to comment.