how to delete the dimension value that aready use in entry

apples12

hi,

i am fresh in using navision, thank you for all your help

i create the dimension value 3100-mbs(berjaya) in dimension
after i use this dimension to post in the general journal.

when i want to view the account that i post using dimension detail report.
come out the message say that
the filter 3100-mbs(berjaya) is invalid
you entered an invalid expression in the filter on teh dimension
4 value code field in teh analysi view entry table


please help me

is it in dimension value we can nto user ( )...

please tell me how to delete the dimension value..

Marije_Brummel

Have you checked the Analisys view if everything is properly setup. :?:

The message says something like the Dimension 4 code being wrong :?

Maybe you need to update the analisys view...

And if you do not want a user to use a dimension value no more you can block it, you cannot delete it if it is used in an entry.

Luc_VanDyck

I guess you need to use a different Dimension Value for this one. When I create a new Dimension Value "3100-MBS(BERJAYA)" for a specific Dimension Code, and I want to set a Field Filter on the field Code in the Dimension Values form (Form 537), the following error is displayed:

Microsoft Navision Attain

---

The filter '3100-MBS(BERJAYA)' is invalid.

You entered an invalid expression in the filter on the Code field in the Dimension Value table.

For information about entering filters, see the online Help.

The problem are the "(" & ")" characters. Try to use some other chars.

Marije_Brummel

Yes, Luc is right.

You can rename the Dimension Value. The ledger entry dimensions should be updated automaticaly.

apples12

Mark Brummel wrote:

Yes, Luc is right.

You can rename the Dimension Value. The ledger entry dimensions should be updated automaticaly.

thank you. after i update analysis view..the error message same just the problem now occur at dimension value table..so..i can't rename..becuase the message say that the the dimension value is use in posted entry..u can not rename it.

so any solution?

Marije_Brummel

If I rename a dimension value in my cronus database it gives no problem, even if there were postings.

How are you trying to rename it? You can just type a new code over the old code and navision will rename the field.

apples12

Mark Brummel wrote:

If I rename a dimension value in my cronus database it gives no problem, even if there were postings.

How are you trying to rename it? You can just type a new code over the old code and navision will rename the field.

i am posting my dimension code in general journal.
before i posting the code, the navision allow me to changing the code, but after i post my general journal, the navision pop up the message say
"You cannot rename it.This dimension value is used in posted entries."

is it i need to change some setting?

Marije_Brummel

I think you need to change the setup table.

If you go to Setup - Dimension - Dimension Values you can rename it here.

apples12

Mark Brummel wrote:

I think you need to change the setup table.

If you go to Setup - Dimension - Dimension Values you can rename it here.

yes.i do. but still can not.
i try to search go to dimension table but still can not change in there.

is that because i using the version 3.01 navision
oldest version make this dimension can not be change?

..

Marije_Brummel

Can be, I have to check this. :?

apples12

somebody please help me..

thank you.

i will try to use the version 4.0 later, but because my company still using the version 3.01..so anybody can help me?

Marije_Brummel

Yes, I've looked it up and you are right. It cannot be renamed in 3.01

I think the best way to go is to write a report that does the rename function for you.

Can you write such a report?

apples12

Mark Brummel wrote:

Yes, I've looked it up and you are right. It cannot be renamed in 3.01

I think the best way to go is to write a report that does the rename function for you.

Can you write such a report?

i am no idea about that..can give me same guide?

Marije_Brummel

I suppose I could, but not today.

Can you contact your solution center for this?

apples12

never mind..is ok..

after that i try to do one very risky method, i close the "checking rename function" in dimension value table, mean that i not allow the table running any checking process. finally , i succes to change the dimension value

i do in my testing database, look like no error happen, sure i unremark the code after that..is tha method can work?
i know this is not the right way...

Marije_Brummel

This can work, this means doing manualy what the report should do.

Just remember to update all ledger entry dimensions.

apples12

Mark Brummel wrote:

This can work, this means doing manualy what the report should do.

Just remember to update all ledger entry dimensions.

hi, mark,

i am sorry, because i am still new in navision, maybe my this question is sound stupig, how to update all ledger entry dimension?

but after i change the dimension, i go to general ledger entry and check for the account that i post withdimension value mbs(berjaya) , all automatic change to mbsberjaya. Is that mean that i no need to update and the navision auto update for me?

apples12

mark,

thank you