Duplicate Record ID

Problem

File asks to rebuild record array and/or menu array every time.

Verify File gives warning about dupe ID (plus a 'record not in right place' error)

Diagnosis

Versions of Goldenseal accounting software before 2.4 would save a record with the wrong ID in a few extreme cases, so it would duplicate an existing ID. It may also be possible to get a dupe ID if importing data that fills values into the ID field, if there is a duplicate there (we've seen it in one user file, although theoretically the code should not do that).

Goldenseal business management software gets confused by having two records with the same ID and gives various error messages.

Solution

We now have an interface for removing duplicate ID numbers.

Before you begin, jot down the name of the class that is giving an error message about duplicate ID numbers-- for example, Customer Accounts or Checking Transactions. If you get more than one error message when you open Goldenseal, jot down the names of all classes where there are errors.

WARNING-- Before doing the following, be sure to make a backup copy, just in case the repair makes things worse instead of better.

Next, follow these steps:

1. Click the Option key (Macintosh) or Alt key (Windows) on your keyboard, and keep holding it down.
2. Click in any Record Window, then choose Security from the View menu. Choose Developer Tools from the submenu, then choose Rebuild Record List from the second submenu.
3. Enter the type of record you'd like to repair. You'll first need to enter the basic type of record (Accounts, Transactions or Lists). Then you will see a list of specific record classes.
4. Goldenseal will check the records, and eventually it will ask what to do about the duplicated record. Click Delete.
5. It may give some error messages later or even crash. Don't worry, it's just temporary.
6. When opening again it will ask to rebuild the menu array. Click OK.
7. The file should be fixed the NEXT time file is opened.

Comments

Entered 7/16/04 by Casey. Revised 2/14/06. Updated 11/4/2010.