Want to modify the Item no - Primary key from report.

JAYESH

HI to all..

I have one table which contain the NEW no and OLd no.

I want to replace or rename the ITEM no with the New no. Item no is the primary key in the item card.

I want to do this by report.

Can any one give me idean how to do this.

Thank you..

Sunset

The command is Item.rename(New no.)
However if you are planning to do this with several items in 1 go, you have to take in to considoration the fact that as you rename the items they shift place in the sorting. So you have to plan for this.
If I understand you correctly you have a seperate table which contain the old and new numbers. So you could make a report that goes through the table, gets the items from your table and rename them

Item.GET("Old number");
Item.RENAME("New number);

However if you have entries in your database the renaming will take quite some time. So it might be an idea to split it.

JAYESH

Thanks for the information.

It's work fine.

Thanks ..