Why can't I rename item no??

Visi_V

Hello.

Why can't I rename the Item No. from 1000 to 1000x?

If I change the number to 10001 its okay,
but if I use string character (1000s), then its gives me error.


I have debugged but didn't help.

I use navision: 2017


The error:

Dolsha

I'll try rename Item No.1000 in cronus db on 2016 NAV and everything went well.
Then i'll try rename Item No. 1000 to 1000s in cronus db on 2017 NAV and everything went well.
How u try rename Item No. in 2017?

Dolsha

I'll try rename Item No.1000 in cronus db on 2016 NAV and everything went well.
Then i'll try rename Item No. 1000 to 1000s in cronus db on 2017 NAV and everything went well.
How u try rename Item No. in 2017?

sorenhinrup

Do you have any modifications to your database? It seems as if the Item Number, somewhere in your database has another datatype than the Item Table.
I just renamed the same item in my Nav2017 Cronus Danmark A/S - without problems.

kalyankandimalla

Hi,
May be some changes in your database is blocking you to rename "Item No.". Please cross check for any changes in Database.

Kishorm

It could be because the "SQL Data Type" property of the "No." field on the "Item" table is set to Integer or BigInteger

Visi_V

I tried to rename it, and it suddenly worked.