How to Change Item Code on which there are transactions made.
There are around 3000 and more Items in our Data Base. The item code is given in this format.
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.
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.