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
0
Comments
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.
If it was hard to write, it should be hard to understand."
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!
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
It is in Tools-->options
the value is stored in your zup file, so it is an individual parameter for each user.
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:
Tables 98 and 379, and form 355 seems OK (I mean, equal to standard), so I'm lost...
Thanks!
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?
http://www.BiloBeauty.com
http://www.autismspeaks.org
I'll try to recompile the form and post again my results.
Thank you very much for your attention.