How to Change Item Code on which there are transactions made.

[Former Member]

Hi All,

There are around 3000 and more Items in our Data Base. The item code is given in this format.

001-001-00

001-001-01

001-001-02

-

-

-

-

-

And Go On.

Now we planned to Change it to SPGEN0001 This is for generator Spare part. like this we have classified each and every Item. By doing this we can Identify the Item by looking at the Item Code.

And there are many Purchase documents raised on all Items which are present.

Is there any query which can replace the Item codes in all the tables where ever it is present.

Thankyou,

Sree

[Former Member · Accepted solution]

Hi,

Unfortunately, once you have transactions, item codes will be locked up. There is no option to change. If you desperately need them to be changed, you have to create a new database and start it from scratch.

Thanks,

Gordon

[former_member187989]

hi dasari,

Use the query to retrieve all items.

Select T0.ItemCode From OITM T0 Where T0.ItemCode LIKE '001-%%'

Cancel all purchase order linked to above items this will nullify ordered quantity If

it have no subsequent documents.

Cancel all item masters created with wrong codes.

Create new item masters using DTW.

Jeyakanthan