Changing Stock ID's in the Stockmaster
Hi,
I need to change all the stock id's in our data base. I've been given the job to clean the database up because past users have entered the ID's wrong.
Now we 7000+ lines to change so I'm doing it in stages. Today our I.T guys tried to import the adjusted stockmaster list back into WEBERP but it didn't work.
They said that in order to change the stock id's we have to change it in three different place in three different tables,one of them is the sales table which has every transaction in it and to try and change that table would be impossible.
So my question is..... Is there any other way change the stock id's that anyone knows of?
It looks like if there is no other way we'll have to either start fresh on a second data base without any sales history or go to a new software program and import everything.
|