Hi,
We want to change am exisitng item code from "A" to "B" and there are all sorts of transactions in the company.

Can it be done in the following way:
1) Logout all used from BaaN.
2) Take backup of the data.
3) In the backup, search for the item code "A" and replace with "B" using any editor.
4) Reload the modified backup by specifying "Drop Existing Tables", "Disable Domain & Integrity Contraints".
5) Reorganize Tables

Should we able be able to get all the data related to item code "A" changed to "B". It can be noted here that the codes "A" and "B" are used symbolically and I am sure that actual code is so peculiar that it would not be used anywhere else for some other meaning.

Just want to know if the above procedure is possible. Has someone tried the stunt?

Warm Regards
Manu

There may be following problems

1. Table delete may not succeed due to error like error 600.
2. In case of table delete success, rebuild of large transaction table takes good
amount of time.

Though theoretically it seems perfect idea , I have never tried this and would
not recommend this. Instead users need to be convinced about any functional solution.

hi

we had the similar requirement.

changing of item code and deleting bulk items.

- we just generated the list of tables where item is used
- exported them out using exchange
- deleted the tables concerned
- imported the data back using exchange. while importing we
used conditions for changing the item code.


tks

vish

Hi,
I tried it in the following manner and was successful in it.

1) Created a test company and copied the data of live company in test company.
2) Did company corrections in test company.
3) Verified correct data in test company.
4) Took backup of selected tables (which have item code) in the test company.
5) Opened all the backup files in editor and "Find-Replaced" the item code.
6) Restored the backup with "Drop existing tables" and "Ignore referential integrity".
7) Reorganized tables.

And all the data was changed perfectly as intended.

Warm Regards
Manu