Cannot Rename a Record

Ganesh2002

We are using NAV 2009 SP1.

We have a blank customer and we have transactions too. Now we want to rename a record. There is no code behind RENAME trigger except "Last Modified Date".
I am getting an error.

You cannot rename a record because the old value for the following field is ''.
Field: No.
Table:Customer

How do we rename the record from blank to something else?

Any suggestions?

Rishi1109

which version of NAV ?

Ganesh2002

NAV 2009 SP1

Rishi1109

Why and How have you created a Customer with Blank Customer No ?
I am trying the same but system is not allowing

pschoenmaker

In NAV2009 SP1 it is not possible to rename an empty field

Rishi1109

You can try through SQL Queries but in that case you must take care of all the linked records Although it is possible in NAV 2016 through client only

Ganesh2002

Thank You.