Topic: Removing an item from the selection list, or changing an item code
Now that I have been using FrontAccounting for a while, I have created a small problem for my company.
We sell many products, and the list of products has grown to the point where users are missing existing products and creating new, duplicate products. As a result, I have decided to institute a product code policy that should eliminate the creation of duplicate products by making existing products easier to find. My problem now is that I can't simply rename the item codes for existing items, and I can't delete the items because they've been sold.
I am sure I am not telling anyone anything they don't already know.
However, I am not so far gone that if I could find a clean, back-door, method of renaming item codes for existing items, I would be ok.
So my question is, can anyone help in any of these ways:
1. Has anyone written a script that will update all occurrences of an item code with a replacement item code?
2. Provide me with all the tables that contain the item codes so that I could create a script? Also any caveats in creating such a script (I envision a simple series of update table_name set item_code='newid' where item_code='oldid', but things often aren't that simple.)
3. Can someone offer me another solution? I really want to get these existing products fixed and implement the new naming system before the list gets unmanageable.