How can I fix this error?

Trint

In the g/l, chart of accounts, receivables-payables, that form is soooo slow that something has to be wrong. Well, I ran a test and got this error on so many accounts that I had to cancel the test:

'Dimension Value' does not exist.
Code:SKH, Global Dimension No.:1
The Global Dimension 1 Code field in the G/L Entry table has a table relationship to the Code field in the Dimension Value table.
'G/L Entry' has the following identification fields and values:
Entry No.='75958'

This slowness only occurred after they upgraded from 2.5 to 3.6.
What will it take to fix this?
thanks,
Trint

Sbhat

Hi,

In Attain Department Code and Project Code have been replaced with Global Dimension 1 as Department Code and Global Dimension 2 as Project Code, instead of having a value in the Global Dimension fields you could define them in Dimensions, hence it looks to me that when a upgrade was done the Departments and Projects were not carried out correctly to the respective Dimensions. You could fix it either by writing a temporary codeunit which will update the Dimension value table.

Thanks
Best regards
Suresh.

Torben_R.

To me it looks like somebody has deleted some department codes in the 2.60 database.

When you make a database test maximum you test the relations between the tables G/L Entries and Dimension Values and you will have lots of these messages.

If you have lots of Item Ledger Entries you will get lots of messages from table 46 Item Register, because the old table is split between Item Ledger Entries and Value Entries.

lakshmivalluru

Hi friends,

This form Receivables-Payables Lines is purely designed on Date table.I think Trint question is y is the form running slow nothing to do with dimensions.u can delete dept code if u dont want it.only drawback will be u cant analyse your data by dimensions.

Trint my suggestion to u is to check the following :
1.the database size.if the database is full,increase the size
2.if ur database is running on server,check how many services r running.
the more the no. of services the less the performance.
3.is the form modified ?check y.

i hope this will help u. :-)

FranVLC

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

Thanks a lot!