Change code Items

danmst98

Hello,

I,m working with Navision 4.0 with SQL.

I have to change some item code in my database, I explain an example of what I have to do.

I have code 100,200 and 300 and I want to make 100 --> X, 200 --> X and 300 to X.

So at the end I only have the item code X.

¿Someone can can give me an Idea of how to make this?

Thanks in advance.

David_Singleton

You basically need to delete each item card (WITHOUT VALIDATING THE ONDELETE TRIG|GER) then rename each one.

Its a pretty simple procedure and i think Rashed wrote a detailed post some time back on how to do it.